Monitor SQL Activity metrics

On this page Carat arrow pointing down
Note:

These graphs are available for CockroachDB Advanced and CockroachDB Basic deployments. For graphs available to CockroachDB Standard deployments, refer to the CockroachDB Cloud Console Metrics page.

To view these graphs, select a cluster from the Clusters page, and click Metrics in the Monitoring section of the left side navigation. On the Metrics page, click the Monitor SQL Activity tab.

Time interval selection

The time interval selector at the top of each tab allows you to filter the view for a predefined or custom time interval. Use the navigation buttons to move to the previous, next, or current time interval. When you select a time interval, the same interval is selected for all charts on the Metrics page.

Open SQL Transactions

The graph shows the total number of open SQL transactions across the cluster.

See the Transactions page for more details on the transactions.

SQL Statements

  • The graph shows a moving average of the number of SELECT/INSERT/UPDATE/DELETE statements per second issued by SQL clients on the cluster.

See the Statements page for more details on the statements.

SQL Statement Latency

SQL statement latency is calculated as the total time in nanoseconds a statement took to complete. This graph shows the p50-p99.99 latencies for statements issued on the cluster.

SQL Open Sessions

This graph shows the total number of SQL client connections across the cluster.

See the Sessions page for more details on the sessions.

SQL Connection Latency

Connection latency is calculated as the time in nanoseconds between when the cluster receives a connection request and establishes the connection to the client, including authentication. This graph shows the p90-p99.99 latencies for SQL connections to the cluster.

SQL Connection Attempts

This graph shows a moving average of new SQL connection attempts to the cluster per second.

See also


Yes No
On this page

Yes No