This topic describes the limits of query and analysis in Simple Log Service.
Query
Item | Description | Remarks |
Number of keywords | The number of keywords that are used as search conditions. The number of logical operators is not included. You can specify up to 30 keywords in a search statement. | None |
Size of a field value | The maximum size of a field value is 512 KB. The excess part is not involved in searching. | If the size of a field value is greater than 512 KB, logs may fail to be obtained by using keywords, but the logs are actually stored in the Logstore. |
Maximum number of concurrent search statements | Each project supports up to 100 concurrent search statements. | For example, 100 users can concurrently execute search statements in all Logstores of a project. |
Returned result | The returned logs are displayed on multiple pages. Each page displays up to 100 logs. | None |
Fuzzy search | In a fuzzy search, Simple Log Service matches up to 100 words that meet the specified conditions and returns the logs that meet the search conditions and contain one or more of these words. For more information, see Fuzzy search. | None |
Data sorting in search results | By default, search results are displayed in descending order of time, which is accurate to seconds, or even to nanoseconds if such precision is available. | None |
Analytics
Item | Standard SQL | Dedicated SQL |
Number of concurrent analytic statements | Each project supports a maximum of 15 concurrent analytic statements. For example, 15 users can concurrently execute analytic statements in all Logstores of a project. | Each project supports a maximum of 100 concurrent analytic statements. For example, 100 users can concurrently execute analytic statements in all Logstores of a project. |
Data volume | Each shard supports only 1 GB of data for a single analytic statement. | An analytic statement can scan a maximum of 200 billion rows of data at the same time. |
Method to enable | By default, Standard SQL is enabled. | A switch is provided for you to manually enable Dedicated SQL. For more information, see Enable Dedicated SQL. |
Resource usage fee | Free of charge. | You are charged based on the actual CPU time. |
Applicable scope | You can analyze only the data that is written to Simple Log Service after the log analysis feature is enabled. If you want to analyze historical data, you must reindex the historical data. For more information, see Reindex logs for a Logstore. | You can analyze only the data that is written to Simple Log Service after the log analysis feature is enabled. If you want to analyze historical data, you must reindex the historical data. For more information, see Reindex logs for a Logstore. |
Returned result | By default, an analytic statement returns a maximum of 100 rows of data. If you want to view more data, use a LIMIT clause. For more information, see LIMIT clause. | By default, an analytic statement returns a maximum of 100 rows of data. If you want to view more data, use a LIMIT clause. For more information, see LIMIT clause. |
Length of a field value | The maximum length of a field value that can be retained for analysis is 16,384 bytes, which is equivalent to 16 KB. Note By default, the maximum length of a field value that can be retained for analysis is 2,048 bytes, which is equivalent to 2 KB. If you want to change the maximum length of a field value, you can configure the Maximum Statistics Field Length parameter. For more information, see Specify the maximum length of a field value. | The maximum length of a field value that can be retained for analysis is 16,384 bytes, which is equivalent to 16 KB. Note By default, the maximum length of a field value that can be retained for analysis is 2,048 bytes, which is equivalent to 2 KB. If you want to change the maximum length of a field value, you can configure the Maximum Statistics Field Length parameter. For more information, see Specify the maximum length of a field value. |
Timeout period | The maximum timeout period for a single analytic statement is 55 seconds. | The maximum timeout period for a single analytic statement is 55 seconds. |
Number of decimal places in the value of a double-type field | The value of a double-type field can contain a maximum of 52 decimal places. If the number of decimal places is greater than 52, the accuracy of the field value is compromised. | The value of a double-type field can contain a maximum of 52 decimal places. If the number of decimal places is greater than 52, the accuracy of the field value is compromised. |