Skip to main content
As part of normal operation, CockroachDB continuously records metrics that track performance, latency, usage, and many other runtime indicators. These metrics are often useful in diagnosing problems, troubleshooting performance, or planning cluster infrastructure modifications. This page documents locations where metrics are exposed for analysis.

Available metrics

CockroachDB Metric NameDescriptionTypeUnitSupported Deployments
addsstable.delay.total
Amount by which evaluation of AddSSTable requests was delayedCOUNTERNANOSECONDSself-hosted
addsstable.proposals
Number of SSTable ingestions proposed (i.e. sent to Raft by lease holders)COUNTERCOUNTAdvanced/self-hosted
admission.io.overload
1-normalized float indicating whether IO admission control considers the store as overloaded with respect to compaction out of L0 (considers sub-level and file counts).GAUGEPERCENTAdvanced/self-hosted
admission.wait_durations.kv
Wait time durations for requests that waitedHISTOGRAMNANOSECONDSAdvanced/self-hosted
admission.wait_durations.kv-stores
Wait time durations for requests that waitedHISTOGRAMNANOSECONDSAdvanced/self-hosted
auth.cert.conn.latency
Latency to establish and authenticate a SQL connection using certificateHISTOGRAMNANOSECONDSself-hosted
auth.gss.conn.latency
Latency to establish and authenticate a SQL connection using GSSHISTOGRAMNANOSECONDSself-hosted
auth.jwt.conn.latency
Latency to establish and authenticate a SQL connection using JWT TokenHISTOGRAMNANOSECONDSself-hosted
auth.ldap.conn.latency
Latency to establish and authenticate a SQL connection using LDAPHISTOGRAMNANOSECONDSself-hosted
auth.ldap.conn.latency.internal
Internal Auth Latency to establish and authenticate a SQL connection using LDAP(excludes external LDAP calls)HISTOGRAMNANOSECONDSself-hosted
auth.password.conn.latency
Latency to establish and authenticate a SQL connection using passwordHISTOGRAMNANOSECONDSself-hosted
auth.scram.conn.latency
Latency to establish and authenticate a SQL connection using SCRAMHISTOGRAMNANOSECONDSself-hosted
capacity
Total storage capacityGAUGEBYTESAdvanced/self-hosted
capacity.available
Available storage capacityGAUGEBYTESAdvanced/self-hosted
capacity.used
Used storage capacityGAUGEBYTESAdvanced/self-hosted
changefeed.backfill_count
Number of changefeeds currently executing backfillGAUGECOUNTStandard/Advanced/self-hosted
changefeed.commit_latency
Event commit latency: a difference between event MVCC timestamp and the time it was acknowledged by the downstream sink. If the sink batches events, then the difference between the oldest event in the batch and acknowledgement is recorded. Excludes latency during backfill.HISTOGRAMNANOSECONDSStandard/Advanced/self-hosted
changefeed.emitted_bytes
Bytes emitted by all feedsCOUNTERBYTESStandard/Advanced/self-hosted
changefeed.emitted_messages
Messages emitted by all feedsCOUNTERCOUNTStandard/Advanced/self-hosted
changefeed.error_retries
Total retryable errors encountered by all changefeedsCOUNTERCOUNTStandard/Advanced/self-hosted
changefeed.failures
Total number of changefeed jobs which have failedCOUNTERCOUNTStandard/Advanced/self-hosted
changefeed.max_behind_nanos
The most any changefeed’s persisted checkpoint is behind the presentGAUGENANOSECONDSStandard/Advanced/self-hosted
changefeed.running
Number of currently running changefeeds, including sinklessGAUGECOUNTStandard/Advanced/self-hosted
clock-offset.meannanos
Mean clock offset with other nodesGAUGENANOSECONDSStandard/Advanced/self-hosted
distsender.errors.notleaseholder
Number of NotLeaseHolderErrors encountered from replica-addressed RPCsCOUNTERCOUNTStandard/Advanced/self-hosted
distsender.rpc.sent.nextreplicaerror
Number of replica-addressed RPCs sent due to per-replica errorsCOUNTERCOUNTStandard/Advanced/self-hosted
exec.latency
Latency of batch KV requests (including errors) executed on this node. This measures requests already addressed to a single replica, from the moment at which they arrive at the internal gRPC endpoint to the moment at which the response (or an error) is returned. This latency includes in particular commit waits, conflict resolution and replication, and end-users can easily produce high measurements via long-running transactions that conflict with foreground traffic. This metric thus does not provide a good signal for understanding the health of the KV layer.HISTOGRAMNANOSECONDSAdvanced/self-hosted
go.scheduler_latency
Go scheduling latencyHISTOGRAMNANOSECONDSself-hosted
intentcount
Count of intent keysGAUGECOUNTAdvanced/self-hosted
jobs.auto_create_partial_stats.currently_paused
Number of auto_create_partial_stats jobs currently considered PausedGAUGECOUNTself-hosted
jobs.auto_create_partial_stats.currently_running
Number of auto_create_partial_stats jobs currently running in Resume or OnFailOrCancel stateGAUGECOUNTself-hosted
jobs.auto_create_partial_stats.resume_failed
Number of auto_create_partial_stats jobs which failed with a non-retriable errorCOUNTERCOUNTself-hosted
jobs.auto_create_stats.currently_paused
Number of auto_create_stats jobs currently considered PausedGAUGECOUNTself-hosted
jobs.auto_create_stats.currently_running
Number of auto_create_stats jobs currently running in Resume or OnFailOrCancel stateGAUGECOUNTself-hosted
jobs.auto_create_stats.resume_failed
Number of auto_create_stats jobs which failed with a non-retriable errorCOUNTERCOUNTself-hosted
jobs.backup.currently_paused
Number of backup jobs currently considered PausedGAUGECOUNTself-hosted
jobs.backup.currently_running
Number of backup jobs currently running in Resume or OnFailOrCancel stateGAUGECOUNTself-hosted
jobs.changefeed.currently_paused
Number of changefeed jobs currently considered PausedGAUGECOUNTStandard/Advanced/self-hosted
jobs.changefeed.protected_age_sec
The age of the oldest PTS record protected by changefeed jobsGAUGESECONDSStandard/Advanced/self-hosted
jobs.create_stats.currently_running
Number of create_stats jobs currently running in Resume or OnFailOrCancel stateGAUGECOUNTself-hosted
jobs.row_level_ttl.currently_paused
Number of row_level_ttl jobs currently considered PausedGAUGECOUNTStandard/Advanced/self-hosted
jobs.row_level_ttl.currently_running
Number of row_level_ttl jobs currently running in Resume or OnFailOrCancel stateGAUGECOUNTStandard/Advanced/self-hosted
jobs.row_level_ttl.delete_duration
Duration for delete requests during row level TTL.HISTOGRAMNANOSECONDSStandard/Advanced/self-hosted
jobs.row_level_ttl.num_active_spans
Number of active spans the TTL job is deleting from.GAUGECOUNTStandard/Advanced/self-hosted
jobs.row_level_ttl.resume_completed
Number of row_level_ttl jobs which successfully resumed to completionCOUNTERCOUNTStandard/Advanced/self-hosted
jobs.row_level_ttl.resume_failed
Number of row_level_ttl jobs which failed with a non-retriable errorCOUNTERCOUNTStandard/Advanced/self-hosted
jobs.row_level_ttl.rows_deleted
Number of rows deleted by the row level TTL job.COUNTERCOUNTStandard/Advanced/self-hosted
jobs.row_level_ttl.rows_selected
Number of rows selected for deletion by the row level TTL job.COUNTERCOUNTStandard/Advanced/self-hosted
jobs.row_level_ttl.select_duration
Duration for select requests during row level TTL.HISTOGRAMNANOSECONDSStandard/Advanced/self-hosted
jobs.row_level_ttl.span_total_duration
Duration for processing a span during row level TTL.HISTOGRAMNANOSECONDSStandard/Advanced/self-hosted
jobs.row_level_ttl.total_expired_rows
Approximate number of rows that have expired the TTL on the TTL table.GAUGECOUNTStandard/Advanced/self-hosted
jobs.row_level_ttl.total_rows
Approximate number of rows on the TTL table.GAUGECOUNTAdvanced/self-hosted
kv.concurrency.locks
Number of active locks held in lock tables. Does not include replicated locks (intents) that are not held in memoryGAUGECOUNTself-hosted
kv.rangefeed.catchup_scan_nanos
Time spent in RangeFeed catchup scanCOUNTERNANOSECONDSself-hosted
leases.epoch
Number of replica leaseholders using epoch-based leasesGAUGECOUNTAdvanced/self-hosted
leases.expiration
Number of replica leaseholders using expiration-based leasesGAUGECOUNTAdvanced/self-hosted
leases.leader
Number of replica leaseholders using leader leasesGAUGECOUNTself-hosted
leases.liveness
Number of replica leaseholders for the liveness range(s)GAUGECOUNTself-hosted
leases.transfers.error
Number of failed lease transfersCOUNTERCOUNTAdvanced/self-hosted
leases.transfers.success
Number of successful lease transfersCOUNTERCOUNTAdvanced/self-hosted
livebytes
Number of bytes of live data (keys plus values)GAUGEBYTESAdvanced/self-hosted
liveness.heartbeatfailures
Number of failed node liveness heartbeats from this nodeCOUNTERCOUNTAdvanced/self-hosted
liveness.heartbeatlatency
Node liveness heartbeat latencyHISTOGRAMNANOSECONDSAdvanced/self-hosted
liveness.livenodes
Number of live nodes in the cluster (will be 0 if this node is not itself live)GAUGECOUNTAdvanced/self-hosted
logical_replication.commit_latency
Event commit latency: a difference between event MVCC timestamp and the time it was flushed into disk. If we batch events, then the difference between the oldest event in the batch and flush is recordedHISTOGRAMNANOSECONDSself-hosted
logical_replication.events_dlqed
Row update events sent to DLQCOUNTERCOUNTself-hosted
logical_replication.events_ingested
Events ingested by all replication jobsCOUNTERCOUNTself-hosted
logical_replication.logical_bytes
Logical bytes (sum of keys + values) received by all replication jobsCOUNTERBYTESself-hosted
logical_replication.replicated_time_seconds
The replicated time of the logical replication stream in seconds since the unix epoch.GAUGESECONDSself-hosted
physical_replication.logical_bytes
Logical bytes (sum of keys + values) ingested by all replication jobsCOUNTERBYTESAdvanced/self-hosted
physical_replication.replicated_time_seconds
The replicated time of the physical replication stream in seconds since the unix epoch.GAUGESECONDSAdvanced/self-hosted
queue.gc.pending
Number of pending replicas in the MVCC GC queueGAUGECOUNTAdvanced/self-hosted
queue.gc.process.failure
Number of replicas which failed processing in the MVCC GC queueCOUNTERCOUNTAdvanced/self-hosted
queue.lease.pending
Number of pending replicas in the replica lease queueGAUGECOUNTself-hosted
queue.merge.pending
Number of pending replicas in the merge queueGAUGECOUNTself-hosted
queue.merge.process.failure
Number of replicas which failed processing in the merge queueCOUNTERCOUNTself-hosted
queue.merge.process.success
Number of replicas successfully processed by the merge queueCOUNTERCOUNTself-hosted
queue.merge.processingnanos
Nanoseconds spent processing replicas in the merge queueCOUNTERNANOSECONDSself-hosted
queue.raftlog.pending
Number of pending replicas in the Raft log queueGAUGECOUNTAdvanced/self-hosted
queue.raftlog.process.failure
Number of replicas which failed processing in the Raft log queueCOUNTERCOUNTAdvanced/self-hosted
queue.raftlog.process.success
Number of replicas successfully processed by the Raft log queueCOUNTERCOUNTAdvanced/self-hosted
queue.raftlog.processingnanos
Nanoseconds spent processing replicas in the Raft log queueCOUNTERNANOSECONDSAdvanced/self-hosted
queue.replicagc.pending
Number of pending replicas in the replica GC queueGAUGECOUNTAdvanced/self-hosted
queue.replicagc.process.failure
Number of replicas which failed processing in the replica GC queueCOUNTERCOUNTAdvanced/self-hosted
queue.replicagc.process.success
Number of replicas successfully processed by the replica GC queueCOUNTERCOUNTAdvanced/self-hosted
queue.replicate.pending
Number of pending replicas in the replicate queueGAUGECOUNTAdvanced/self-hosted
queue.replicate.process.failure
Number of replicas which failed processing in the replicate queueCOUNTERCOUNTAdvanced/self-hosted
queue.replicate.process.success
Number of replicas successfully processed by the replicate queueCOUNTERCOUNTAdvanced/self-hosted
queue.replicate.replacedecommissioningreplica.error
Number of failed decommissioning replica replacements processed by the replicate queueCOUNTERCOUNTStandard/Advanced/self-hosted
raft.scheduler.latency
Queueing durations for ranges waiting to be processed by the Raft scheduler. This histogram measures the delay from when a range is registered with the scheduler for processing to when it is actually processed. This does not include the duration of processing.HISTOGRAMNANOSECONDSself-hosted
raftlog.behind
Number of Raft log entries followers on other stores are behind. This gauge provides a view of the aggregate number of log entries the Raft leaders on this node think the followers are behind. Since a raft leader may not always have a good estimate for this information for all of its followers, and since followers are expected to be behind (when they are not required as part of a quorum) *and* the aggregate thus scales like the count of such followers, it is difficult to meaningfully interpret this metric.GAUGECOUNTAdvanced/self-hosted
range.adds
Number of range additionsCOUNTERCOUNTAdvanced/self-hosted
range.merges
Number of range mergesCOUNTERCOUNTStandard/Advanced/self-hosted
range.snapshots.send-queue
Number of snapshots queued to sendGAUGECOUNTself-hosted
range.splits
Number of range splitsCOUNTERCOUNTAdvanced/self-hosted
ranges
Number of rangesGAUGECOUNTAdvanced/self-hosted
ranges.decommissioning
Number of ranges with at lease one replica on a decommissioning nodeGAUGECOUNTself-hosted
ranges.unavailable
Number of ranges with fewer live replicas than needed for quorumGAUGECOUNTAdvanced/self-hosted
ranges.underreplicated
Number of ranges with fewer live replicas than the replication targetGAUGECOUNTAdvanced/self-hosted
rebalancing.cpunanospersecond
Average CPU nanoseconds spent on processing replica operations in the last 30 minutes.GAUGENANOSECONDSStandard/Advanced/self-hosted
rebalancing.lease.transfers
Number of lease transfers motivated by store-level load imbalancesCOUNTERCOUNTStandard/Advanced/self-hosted
rebalancing.queriespersecond
Number of kv-level requests received per second by the store, considering the last 30 minutes, as used in rebalancing decisions.GAUGECOUNTStandard/Advanced/self-hosted
rebalancing.range.rebalances
Number of range rebalance operations motivated by store-level load imbalancesCOUNTERCOUNTStandard/Advanced/self-hosted
rebalancing.replicas.cpunanospersecond
Histogram of average CPU nanoseconds spent on processing replica operations in the last 30 minutes.HISTOGRAMNANOSECONDSStandard/Advanced/self-hosted
rebalancing.replicas.queriespersecond
Histogram of average kv-level requests received per second by replicas on the store in the last 30 minutes.HISTOGRAMCOUNTStandard/Advanced/self-hosted
replicas
Number of replicasGAUGECOUNTAdvanced/self-hosted
replicas.leaseholders
Number of lease holdersGAUGECOUNTAdvanced/self-hosted
requests.slow.latch
Number of requests that have been stuck for a long time acquiring latches. Latches moderate access to the KV keyspace for the purpose of evaluating and replicating commands. A slow latch acquisition attempt is often caused by another request holding and not releasing its latches in a timely manner. This in turn can either be caused by a long delay in evaluation (for example, under severe system overload) or by delays at the replication layer. This gauge registering a nonzero value usually indicates a serious problem and should be investigated.GAUGECOUNTself-hosted
requests.slow.lease
Number of requests that have been stuck for a long time acquiring a lease. This gauge registering a nonzero value usually indicates range or replica unavailability, and should be investigated. In the common case, we also expect to see ‘requests.slow.raft’ to register a nonzero value, indicating that the lease requests are not getting a timely response from the replication layer.GAUGECOUNTAdvanced/self-hosted
requests.slow.raft
Number of requests that have been stuck for a long time in the replication layer. An (evaluated) request has to pass through the replication layer, notably the quota pool and raft. If it fails to do so within a highly permissive duration, the gauge is incremented (and decremented again once the request is either applied or returns an error). A nonzero value indicates range or replica unavailability, and should be investigated.GAUGECOUNTAdvanced/self-hosted
rocksdb.block.cache.hits
Count of block cache hitsCOUNTERCOUNTAdvanced/self-hosted
rocksdb.block.cache.misses
Count of block cache missesCOUNTERCOUNTAdvanced/self-hosted
rocksdb.compactions
Number of table compactionsCOUNTERCOUNTAdvanced/self-hosted
rocksdb.read-amplification
Number of disk reads per queryGAUGECONSTAdvanced/self-hosted
round-trip-latency
Distribution of round-trip latencies with other nodes. This only reflects successful heartbeats and measures gRPC overhead as well as possible head-of-line blocking. Elevated values in this metric may hint at network issues and/or saturation, but they are no proof of them. CPU overload can similarly elevate this metric. The operator should look towards OS-level metrics such as packet loss, retransmits, etc, to conclusively diagnose network issues. Heartbeats are not very frequent (~seconds), so they may not capture rare or short-lived degradations.HISTOGRAMNANOSECONDSStandard/Advanced/self-hosted
rpc.connection.avg_round_trip_latency
Sum of exponentially weighted moving average of round-trip latencies, as measured through a gRPC RPC. Since this metric is based on gRPC RPCs, it is affected by application-level processing delays and CPU overload effects. See rpc.connection.tcp_rtt for a metric that is obtained from the kernel’s TCP stack. Dividing this Gauge by rpc.connection.healthy gives an approximation of average latency, but the top-level round-trip-latency histogram is more useful. Instead, users should consult the label families of this metric if they are available (which requires prometheus and the cluster setting ‘server.child_metrics.enabled’); these provide per-peer moving averages. This metric does not track failed connection. A failed connection’s contribution is reset to zero.GAUGENANOSECONDSself-hosted
rpc.connection.failures
Counter of failed connections. This includes both the event in which a healthy connection terminates as well as unsuccessful reconnection attempts. Connections that are terminated as part of local node shutdown are excluded. Decommissioned peers are excluded.COUNTERCOUNTself-hosted
rpc.connection.healthy
Gauge of current connections in a healthy state (i.e. bidirectionally connected and heartbeating)GAUGECOUNTself-hosted
rpc.connection.healthy_nanos
Gauge of nanoseconds of healthy connection time On the prometheus endpoint scraped with the cluster setting ‘server.child_metrics.enabled’ set, the constituent parts of this metric are available on a per-peer basis and one can read off for how long a given peer has been connectedGAUGENANOSECONDSself-hosted
rpc.connection.heartbeats
Counter of successful heartbeats.COUNTERCOUNTself-hosted
rpc.connection.tcp_rtt
Kernel-level TCP round-trip time as measured by the Linux TCP stack. This metric reports the smoothed round-trip time (SRTT) as maintained by the kernel’s TCP implementation. Unlike application-level RPC latency measurements, this reflects pure network latency and is less affected by CPU overload effects. This metric is only available on Linux.GAUGENANOSECONDSself-hosted
rpc.connection.tcp_rtt_var
Kernel-level TCP round-trip time variance as measured by the Linux TCP stack. This metric reports the smoothed round-trip time variance (RTTVAR) as maintained by the kernel’s TCP implementation. This measures the stability of the connection latency. This metric is only available on Linux.GAUGENANOSECONDSself-hosted
rpc.connection.unhealthy
Gauge of current connections in an unhealthy state (not bidirectionally connected or heartbeating)GAUGECOUNTself-hosted
rpc.connection.unhealthy_nanos
Gauge of nanoseconds of unhealthy connection time. On the prometheus endpoint scraped with the cluster setting ‘server.child_metrics.enabled’ set, the constituent parts of this metric are available on a per-peer basis and one can read off for how long a given peer has been unreachableGAUGENANOSECONDSself-hosted
schedules.BACKUP.failed
Number of BACKUP jobs failedCOUNTERCOUNTStandard/Advanced/self-hosted
schedules.BACKUP.last-completed-time
The unix timestamp of the most recently completed backup by a schedule specified as maintaining this metricGAUGETIMESTAMP_SECStandard/Advanced/self-hosted
schedules.scheduled-row-level-ttl-executor.failed
Number of scheduled-row-level-ttl-executor jobs failedCOUNTERCOUNTAdvanced/self-hosted
seconds.until.enterprise.license.expiry
Seconds until enterprise license expiry (0 if no license present or running without enterprise features)GAUGETIMESTAMP_SECself-hosted
security.certificate.expiration.ca
Expiration for the CA certificate. 0 means no certificate or error.GAUGETIMESTAMP_SECAdvanced/self-hosted
security.certificate.expiration.ca-client-tenant
Expiration for the Tenant Client CA certificate. 0 means no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.expiration.client
Minimum expiration for client certificates, labeled by SQL user. 0 means no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.expiration.client-ca
Expiration for the client CA certificate. 0 means no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.expiration.client-tenant
Expiration for the Tenant Client certificate. 0 means no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.expiration.node
Expiration for the node certificate. 0 means no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.expiration.node-client
Expiration for the node’s client certificate. 0 means no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.expiration.ui
Expiration for the UI certificate. 0 means no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.expiration.ui-ca
Expiration for the UI CA certificate. 0 means no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.ttl.ca
Seconds till expiration for the CA certificate. 0 means expired, no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.ttl.ca-client-tenant
Seconds till expiration for the Tenant Client CA certificate. 0 means expired, no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.ttl.client
Seconds till expiration for the client certificates, labeled by SQL user. 0 means expired, no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.ttl.client-ca
Seconds till expiration for the client CA certificate. 0 means expired, no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.ttl.client-tenant
Seconds till expiration for the Tenant Client certificate. 0 means expired, no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.ttl.node
Seconds till expiration for the node certificate. 0 means expired, no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.ttl.node-client
Seconds till expiration for the node’s client certificate. 0 means expired, no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.ttl.ui
Seconds till expiration for the UI certificate. 0 means expired, no certificate or error.GAUGETIMESTAMP_SECself-hosted
security.certificate.ttl.ui-ca
Seconds till expiration for the UI CA certificate. 0 means expired, no certificate or error.GAUGETIMESTAMP_SECself-hosted
sql.conn.failures
Number of SQL connection failuresCOUNTERCOUNTStandard/Advanced/self-hosted
sql.conn.latency
Latency to establish and authenticate a SQL connectionHISTOGRAMNANOSECONDSStandard/Advanced/self-hosted
sql.conns
Number of open SQL connectionsGAUGECOUNTStandard/Advanced/self-hosted
sql.ddl.count
Number of SQL DDL statements successfully executedCOUNTERCOUNTStandard/Advanced/self-hosted
sql.delete.count
Number of SQL DELETE statements successfully executedCOUNTERCOUNTStandard/Advanced/self-hosted
sql.distsql.contended_queries.count
Number of SQL queries that experienced contentionCOUNTERCOUNTStandard/Advanced/self-hosted
sql.exec.latency
Latency of SQL statement executionHISTOGRAMNANOSECONDSStandard/Advanced/self-hosted
sql.failure.count
Number of statements resulting in a planning or runtime errorCOUNTERCOUNTStandard/Advanced/self-hosted
sql.full.scan.count
Number of full table or index scansCOUNTERCOUNTStandard/Advanced/self-hosted
sql.insert.count
Number of SQL INSERT statements successfully executedCOUNTERCOUNTStandard/Advanced/self-hosted
sql.mem.root.current
Current sql statement memory usage for rootGAUGEBYTESself-hosted
sql.new_conns
Number of SQL connections createdCOUNTERCOUNTStandard/Advanced/self-hosted
sql.query.count
Number of SQL operations started including queries, and transaction control statementsCOUNTERCOUNTStandard/Advanced/self-hosted
sql.routine.delete.count
Number of SQL DELETE statements successfully executed within routine invocationCOUNTERCOUNTself-hosted
sql.routine.insert.count
Number of SQL INSERT statements successfully executed within routine invocationCOUNTERCOUNTself-hosted
sql.routine.select.count
Number of SQL SELECT statements successfully executed within routine invocationCOUNTERCOUNTself-hosted
sql.routine.update.count
Number of SQL UPDATE statements successfully executed within routine invocationCOUNTERCOUNTself-hosted
sql.select.count
Number of SQL SELECT statements successfully executedCOUNTERCOUNTStandard/Advanced/self-hosted
sql.service.latency
Latency of SQL request executionHISTOGRAMNANOSECONDSStandard/Advanced/self-hosted
sql.statements.active
Number of currently active user SQL statementsGAUGECOUNTStandard/Advanced/self-hosted
sql.txn.abort.count
Number of SQL transaction abort errorsCOUNTERCOUNTStandard/Advanced/self-hosted
sql.txn.begin.count
Number of SQL transaction BEGIN statements successfully executedCOUNTERCOUNTStandard/Advanced/self-hosted
sql.txn.commit.count
Number of SQL transaction COMMIT statements successfully executedCOUNTERCOUNTStandard/Advanced/self-hosted
sql.txn.latency
Latency of SQL transactionsHISTOGRAMNANOSECONDSStandard/Advanced/self-hosted
sql.txn.rollback.count
Number of SQL transaction ROLLBACK statements successfully executedCOUNTERCOUNTStandard/Advanced/self-hosted
sql.txns.open
Number of currently open user SQL transactionsGAUGECOUNTStandard/Advanced/self-hosted
sql.update.count
Number of SQL UPDATE statements successfully executedCOUNTERCOUNTStandard/Advanced/self-hosted
storage.disk-slow
Number of instances of disk operations taking longer than 10sCOUNTERCOUNTself-hosted
storage.disk-stalled
Number of instances of disk operations taking longer than 20sCOUNTERCOUNTself-hosted
storage.disk.iopsinprogress
IO operations currently in progress on the store’s disk (as reported by the OS)GAUGECOUNTself-hosted
storage.disk.read-max.bytespersecond
Maximum rate at which bytes were read from disk (as reported by the OS)GAUGEBYTESself-hosted
storage.disk.read.bytes
Bytes read from the store’s disk since this process started (as reported by the OS)COUNTERBYTESself-hosted
storage.disk.read.count
Disk read operations on the store’s disk since this process started (as reported by the OS)COUNTERCOUNTself-hosted
storage.disk.write-max.bytespersecond
Maximum rate at which bytes were written to disk (as reported by the OS)GAUGEBYTESself-hosted
storage.disk.write.bytes
Bytes written to the store’s disk since this process started (as reported by the OS)COUNTERBYTESself-hosted
storage.disk.write.count
Disk write operations on the store’s disk since this process started (as reported by the OS)COUNTERCOUNTself-hosted
storage.keys.tombstone.count
Approximate count of DEL, SINGLEDEL and RANGEDEL internal keys across the storage engine.GAUGECOUNTself-hosted
storage.l0-level-size
Size of the SSTables in level 0GAUGEBYTESself-hosted
storage.wal.failover.switch.count
Count of the number of times WAL writing has switched from primary to secondary and vice versa.COUNTERCOUNTself-hosted
storage.wal.failover.write_and_sync.latency
The observed latency for writing and syncing to the logical Write-Ahead Log.HISTOGRAMNANOSECONDSself-hosted
storage.wal.fsync.latency
The fsync latency to the Write-Ahead Log device.HISTOGRAMNANOSECONDSAdvanced/self-hosted
storage.write-stall-nanos
Total write stall duration in nanosCOUNTERNANOSECONDSself-hosted
storage.write-stalls
Number of instances of intentional write stalls to backpressure incoming writesCOUNTERCOUNTself-hosted
storeliveness.heartbeat.failures
Number of Store Liveness heartbeats that failed to be sent out by the Store Liveness Support ManagerCOUNTERCOUNTself-hosted
sys.cgo.allocbytes
Current bytes of memory allocated by cgoGAUGEBYTESAdvanced/self-hosted
sys.cgo.totalbytes
Total bytes of memory allocated by cgo, but not releasedGAUGEBYTESAdvanced/self-hosted
sys.cpu.combined.percent-normalized
Current user+system cpu percentage consumed by the CRDB process, normalized 0-1 by number of coresGAUGEPERCENTAdvanced/self-hosted
sys.cpu.host.combined.percent-normalized
Current user+system cpu percentage across the whole machine, normalized 0-1 by number of coresGAUGEPERCENTself-hosted
sys.cpu.sys.ns
Total system cpu time consumed by the CRDB processCOUNTERNANOSECONDSAdvanced/self-hosted
sys.cpu.sys.percent
Current system cpu percentage consumed by the CRDB processGAUGEPERCENTAdvanced/self-hosted
sys.cpu.user.ns
Total user cpu time consumed by the CRDB processCOUNTERNANOSECONDSAdvanced/self-hosted
sys.cpu.user.percent
Current user cpu percentage consumed by the CRDB processGAUGEPERCENTAdvanced/self-hosted
sys.gc.count
Total number of GC runsCOUNTERCOUNTAdvanced/self-hosted
sys.gc.pause.ns
Total GC pauseCOUNTERNANOSECONDSAdvanced/self-hosted
sys.gc.pause.percent
Current GC pause percentageGAUGEPERCENTAdvanced/self-hosted
sys.go.allocbytes
Current bytes of memory allocated by goGAUGEBYTESAdvanced/self-hosted
sys.go.heap.allocbytes
Cumulative bytes allocated for heap objects.COUNTERBYTESself-hosted
sys.go.heap.heapfragmentbytes
Total heap fragmentation bytes, derived from bytes in in-use spans minus bytes allocatedGAUGEBYTESself-hosted
sys.go.totalbytes
Total bytes of memory allocated by go, but not releasedGAUGEBYTESAdvanced/self-hosted
sys.goroutines
Current number of goroutinesGAUGECOUNTAdvanced/self-hosted
sys.host.disk.iopsinprogress
IO operations currently in progress on this host (as reported by the OS)GAUGECOUNTAdvanced/self-hosted
sys.host.disk.read.bytes
Bytes read from all disks since this process started (as reported by the OS)COUNTERBYTESAdvanced/self-hosted
sys.host.disk.read.count
Disk read operations across all disks since this process started (as reported by the OS)COUNTERCOUNTAdvanced/self-hosted
sys.host.disk.write.bytes
Bytes written to all disks since this process started (as reported by the OS)COUNTERBYTESAdvanced/self-hosted
sys.host.disk.write.count
Disk write operations across all disks since this process started (as reported by the OS)COUNTERCOUNTAdvanced/self-hosted
sys.host.net.recv.bytes
Bytes received on all network interfaces since this process started (as reported by the OS)COUNTERBYTESAdvanced/self-hosted
sys.host.net.send.bytes
Bytes sent on all network interfaces since this process started (as reported by the OS)COUNTERBYTESAdvanced/self-hosted
sys.host.net.send.tcp.retrans_segs
The number of TCP segments retransmitted across all network interfaces. This can indicate packet loss occurring in the network. However, it can also be caused by recipient nodes not consuming packets in a timely manner, or the local node overflowing its outgoing buffers, for example due to overload. Retransmissions also occur in the absence of problems, as modern TCP stacks err on the side of aggressively retransmitting segments. The linux tool ‘ss -i’ can show the Linux kernel’s smoothed view of round-trip latency and variance on a per-connection basis. Additionally, ‘netstat -s’ shows all TCP counters maintained by the kernel.COUNTERCOUNTself-hosted
sys.rss
Current process RSSGAUGEBYTESAdvanced/self-hosted
sys.runnable.goroutines.per.cpu
Average number of goroutines that are waiting to run, normalized by number of coresGAUGECOUNTAdvanced/self-hosted
sys.totalmem
Total memory (both free and used)GAUGEBYTESAdvanced/self-hosted
sys.uptime
Process uptimeCOUNTERSECONDSStandard/Advanced/self-hosted
txn.restarts
Number of restarted KV transactionsHISTOGRAMCOUNTStandard/Advanced/self-hosted
txn.restarts.serializable
Number of restarts due to a forwarded commit timestamp and isolation=SERIALIZABLECOUNTERCOUNTStandard/Advanced/self-hosted
txn.restarts.txnaborted
Number of restarts due to an abort by a concurrent transaction (usually due to deadlock)COUNTERCOUNTStandard/Advanced/self-hosted
txn.restarts.txnpush
Number of restarts due to a transaction push failureCOUNTERCOUNTStandard/Advanced/self-hosted
txn.restarts.unknown
Number of restarts due to a unknown reasonsCOUNTERCOUNTStandard/Advanced/self-hosted
txn.restarts.writetooold
Number of restarts due to a concurrent writer committing firstCOUNTERCOUNTStandard/Advanced/self-hosted
txnwaitqueue.deadlocks_total
Number of deadlocks detected by the txn wait queueCOUNTERCOUNTStandard/Advanced/self-hosted
Total metrics (225)

See also