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 Identify SQL Problems 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.
Transaction Restarts
This graph shows the number of transactions restarted across the cluster.
See the Transaction Retry Error Reference for details on the errors that caused the transaction to restart.
SQL Statement Errors
This graph shows a moving average of the number of SQL statements that returned a planning, runtime, or retry error across all nodes.
See the Statements page for more details on the cluster's SQL statements.
SQL Statement Full Scans
This graph shows a moving average of the number of statements with full table and index scans across all nodes in the cluster.
Examine the statements that result in full table scans and consider adding secondary indexes.
SQL Statement Contention
This graph shows a moving average of the number of SQL statements that experienced contention across the cluster.
See the Statements page for more details on the cluster's SQL statements.
See also
Was this helpful?
