Use the Cockroach DB Console to Observe and Troubleshoot SQL

CockroachDB provides a DB Console for developers and operators to monitor their clusters. The console offers access to important cluster data such as Metrics, Databases, Sessions (new in CockroachDB 20.2), Transactions (new in CockroachDB 20.2), Statements, and more. Operators can use the DB Console to evaluate node status, replication health, and key metrics like CPU, memory, and disk usage. Developers can observe their workloads and sessions, transactions, and statements that comprise them. The Sessions page allows developers to find and cancel problematic active sessions, while the Transactions page provides visibility into transaction fingerprints on a new transactions page in the DB Console. SQL shell users can access this information directly through CockroachDB Internal Tables or by using SHOW SESSIONS, SHOW TRANSACTIONS, and SHOW QUERIES commands.