The DB Console provides details about your cluster and database configuration, and helps you optimize cluster performance.
DB Console areas
|Essential metrics about the cluster and nodes, including liveness status, replication status, uptime, and hardware usage.
|Geographical configuration of your cluster and metrics at the locality and node levels, visualized on a map.
|Metrics about SQL performance, replication, and storage.
|Metrics about CPU usage, disk throughput, network traffic, storage capacity, and memory.
|Metrics about node count, CPU time, and memory usage.
|Metrics about SQL connections, byte traffic, queries, transactions, and service latency.
|Metrics about storage capacity and file descriptors.
|Metrics about how data is replicated across the cluster, e.g., range status, replicas per store, and replica quiescence.
|Metrics about the changefeeds created across your cluster.
|Details about the system and user databases in the cluster.
|Details about open sessions in the cluster.
|Frequently executed and high latency SQL statements, with the option to collect statement diagnostics.
|Details about transactions running on the cluster.
|Latencies and lost connections between all nodes in your cluster.
|Details of jobs running in the cluster.
|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.
DB Console access
The DB Console is accessible from every node at
http://<host>:8080 by default.
- If you included the
--http-addrflag when starting nodes, use the IP address/hostname and port specified by that flag.
- If you didn't include the
--http-addrflag when starting nodes, use the IP address/hostname specified by the
--listen-addrflag and port
- If you are running a secure cluster, use
http. You will also need to create a user with a password to log in.
DB Console security
On insecure clusters, all areas of the DB Console are accessible to all users.
root user is a member of the
admin role. Use the following command to grant users membership to the
GRANT admin TO <sql_user>;
For security reasons, non-admin users access only the data over which they have privileges (e.g., their tables, jobs, and list of sessions), and data that does not require privileges (e.g., cluster health, node status, metrics).
The following areas of the DB Console can only be accessed by
admin users. These areas display information from privileged HTTP endpoints that operate with
|Database and table names
|Stored table data
|Advanced Debug (some reports)
|Stored table data, operational details, internal IP addresses, names, credentials, application data (depending on report)
By default, the DB Console shares anonymous usage details with Cockroach Labs. For information about the details shared and how to opt-out of reporting, see Diagnostics Reporting.