Performance diagnostics in Yandex StoreDoc

Yandex StoreDoc provides a built-in tool for diagnosing your database cluster performance. You can use it to analyze Yandex StoreDoc profiling and index metrics.

Enabling statistics collectionEnabling statistics collection

To use this diagnostic tool, enable statistics collection during cluster creation or update. By default, the system only collects statistics for queries longer than 300 ms. If necessary, change the slow query collection threshold by adjusting the slowOpThreshold setting in your database configuration.

Getting profiling dataGetting profiling data

For read, write, and other database queries, such as aggregate operations, you can view the data collected by the Yandex StoreDoc profiler:

• Chart with metrics for the selected data slice. You can toggle individual categories in the chart by clicking the category name in the chart legend.
• Table with statistics broken down by query type.

To get this data:

1. Open the folder dashboard.

2. Navigate to the Yandex StoreDoc service.

3. Click the name of your cluster and select Performance diagnostics → Profiling.

4. Specify a time range and adjust filters as needed.

5. Select:

   • Data segment:
     • FORM: By query type
     • HOSTNAME: By shard’s primary host
     • NAMESPACE: By collection name
     • SHARD: By shard
     • USER: By user
   • Data grouping:
     • COUNT: Number of queries.
     • DOCUMENTS_EXAMINED: Number of collection documents scanned per query.
     • DOCUMENTS_RETURNED: Number of returned documents.
     • DURATION: Query execution duration.
     • KEYS_EXAMINED: Number of index keys scanned per query.
     • RESPONSE_LENGTH: Size of the document returned by the query.
   • Aggregation function for the selected metric:
     • AVG: Average
     • SUM: Sum

Getting information about indexesGetting information about indexes

The system provides collection access statistics and indexing recommendations for specific fields to improve query speed.

1. Open the folder dashboard.
2. Navigate to the Yandex StoreDoc service.
3. Click the name of your cluster and select Performance diagnostics → Suggested indexes.
4. Specify a time range and adjust filters as needed.

The table shows recommended index fields and collection access counts.