| title | summary | toc |
|---|---|---|
Overview Dashboard |
The Overview dashboard lets you monitor important SQL performance, replication, and storage metrics. |
true |
On accessing the CockroachDB Admin UI, the Overview is shown by default. This dashboard lets you monitor important SQL performance, replication, and storage metrics.
The Overview dashboard displays the following time series graphs:
-
In the node view, the SQL Queries graph shows the current moving average, over the last 10 seconds, of the number of
SELECT/INSERT/UPDATE/DELETEqueries per second issued by SQL clients on the node. -
In the cluster view, the graph shows the sum of the per-node averages, that is, an aggregate estimation of the current query load over the cluster, assuming the last 10 seconds of activity per node are representative of this load.
Service latency is calculated as the time between when the cluster receives a query and finishes executing the query. This time does not include returning results to the client.
-
In the node view, the graph shows the 99th percentile of service latency for the node.
-
In the cluster view, the graph shows the 99th percentile of service latency across all nodes in the cluster.
Ranges are subsets of your data, which are replicated to ensure survivability. Ranges are replicated to a configurable number of CockroachDB nodes.
-
In the node view, the graph shows the number of range replicas on the selected node.
-
In the cluster view, the graph shows the number of range replicas on each node in the cluster.
For details about how to control the number and location of replicas, see Configure Replication Zones.
You can monitor the Capacity graph to determine when additional storage is needed.
-
In the node view, the graph shows the maximum allocated capacity, available storage capacity, and capacity used by CockroachDB for the selected node.
-
In the cluster view, the graph shows the maximum allocated capacity, available storage capacity, and capacity used by CockroachDB across all nodes in the cluster.
On hovering over the graph, the values for the following metrics are displayed:
| Metric | Description |
|---|---|
| Capacity | The maximum storage capacity allocated to CockroachDB. You can configure the maximum allocated storage capacity for CockroachDB using the --store flag. For more information, see Start a Node. |
| Available | The free storage capacity available to CockroachDB. |
| Used | Disk space used by the data in the CockroachDB store. Note that this value is less than (Capacity - Available) because Capacity and Available metrics consider the entire disk and all applications on the disk including CockroachDB, whereas Used metric tracks only the store's disk usage. |
{{site.data.alerts.callout_info}} {% include v1.1/misc/available-capacity-metric.md %} {{site.data.alerts.end}}