The CockroachDB Admin UI provides details about your cluster and database configuration, and helps you optimize cluster performance.
Admin UI areas
|Node Map||View and monitor the metrics and geographical configuration of your cluster.|
|Cluster Health||View essential metrics about the cluster's health, such as the number of live, dead, and suspect nodes, the number of unavailable ranges, and the queries per second and service latency across the cluster.|
|Overview Metrics||View important SQL performance, replication, and storage metrics.|
|Hardware Metrics||View metrics about CPU usage, disk throughput, network traffic, storage capacity, and memory.|
|Runtime Metrics||View metrics about node count, CPU time, and memory usage.|
|SQL Performance||View metrics about SQL connections, byte traffic, queries, transactions, and service latency.|
|Storage Utilization||View metrics about storage capacity and file descriptors.|
|Replication Details||View metrics about how data is replicated across the cluster, such as range status, replicas per store, and replica quiescence.|
|Changefeed Details||View metrics about the changefeeds created across your cluster.|
|Nodes Details||View details of live, dead, and decommissioned nodes.|
|Events||View a list of recent cluster events.|
|Database Details||View details about the system and user databases in the cluster.|
|Statements Details||Identify frequently executed or high latency SQL statements|
|Jobs Details||View details of the jobs running in the cluster.|
|Advanced Debugging Pages||View advanced monitoring and troubleshooting reports. These include details about data distribution, the state of specific queues, and slow query metrics. These details are largely intended for use by CockroachDB developers.|
Admin UI access
On insecure clusters, all areas of the Admin UI are accessible to all users.
For security reasons, non-admin users access only the data over which they have privileges (e.g., their tables and list of sessions), and data that does not require privileges (e.g., cluster health, node status, metrics).
root user is a member of the
admin role, but on CockroachDB clusters prior to v20.1, the Admin UI cannot be accessed by
root. To access the secure Admin UI areas, grant a user membership to the
admin role using an enterprise license (a trial license can be used).
If you don't have an enterprise license, use this command to manually create a secondary
INSERT INTO system.role_members (role, member, "isAdmin") VALUES ('admin', '<sql_user>', true);
Note that you may need to restart a node for new
admin roles to take effect.
|Secure area||Privileged information|
|Node Map||Database and table names|
|Database Details||Stored table data|
|Statements Details||SQL statements|
|Jobs Details||SQL statements and operational details|
|Advanced Debugging Pages (some reports)||Stored table data, operational details, internal IP addresses, names, credentials, application data (depending on report)|
By default, the Admin UI shares anonymous usage details with Cockroach Labs. For information about the details shared and how to opt-out of reporting, see Diagnostics Reporting.