Performance diagnostics in Managed Service for ClickHouse®

To enable statistics collection, select Statistics sampling when creating or updating a cluster. This option is disabled by default.

1. In the management console, select the folder the cluster is in.

2. Navigate to Managed Service for ClickHouse.

3. Click the cluster name and select the Performance diagnostics tab.

   To view query history or statistics, select the relevant tab. The data is displayed for the selected time period.

4. Optionally, add query filters:

   1. Select hosts.
   2. Select users.
   3. Select query result: QueryFinish, ExceptionBeforeStart, or ExceptionWhileProcessing.
   4. Select query type.

5. To view query info, select the query of interest in the History tab. This will open the query page.

   For queries of 5 seconds and longer, the following charts will be displayed:

   • Chart CPU: CPU usage.
   • Chart memory: RAM usage.
   • Chart rows: Number of rows read and added via the query.
   • Chart bytes: Amount of data read and added via the query, in bytes.

1. In the management console, select the folder the cluster is in.

2. Navigate to Managed Service for ClickHouse.

3. Click the cluster name and select the Performance diagnostics tab.

4. Navigate to the Query groups tab.

   The page displays unique queries for the selected time period.

5. Optionally, add query filters:

   1. Select hosts.
   2. Select users.
   3. Select query result: QueryFinish, ExceptionBeforeStart, or ExceptionWhileProcessing.
   4. Select query type.