CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally, survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention. CockroachDB provides a familiar SQL API for structuring, manipulating, and querying data.

Prerequisite

For Virtual Machines, install the Linux Agent.

Configuring the credentials

Configure the credentials in the directory /opt/opsramp/agent/conf/app.d/creds.yaml

cockroachdb:
- name: cockroachdb
  user: <username>
  pwd: <Password>
  encoding-type: plain
  labels:
    key1: val1
    key2: val2

Configuring the application

Virtual machine

Configure the application in the directory /opt/opsramp/agent/conf/app/discovery/auto-detection.yaml

- name: cockroachdb
  instance-checks:
    service-check:
      - cockroach
    process-check:
      - cockroach
    port-check:
      - 26257
      - 8080

Docker environment

Configure the application in the directory /opt/opsramp/agent/conf/app/discovery/auto-container-detection.yaml

- name: cockroachdb
  container-checks:
    image-check:
      - cockroach
    port-check:
      - 26257
      - 8080

Kubernetes environment

Configure the application in config.yaml

- name: cockroachdb
  container-checks:
    image-check:
      - cockroach
    port-check:
      - 26257
      - 8080

Validate

Go to Resources under the Infrastructure tab to check if your resources are onboarded and the metrics are collected.

Metrics

OpsRamp MetricMetric Display NameUnit
cockroachdb_addsstable_applications

Number of SSTable ingestions applied (applied by Replicas)
Addsstable ApplicationsOperations / second
cockroachdb_addsstable_copies

Number of SSTable ingestions that required copying files during application
Addsstable CopiesOperations / second
cockroachdb_addsstable_proposals

Number of SSTable ingestions proposed (sent to Raft by lease holders)
Addsstable ProposalsOperations / second
cockroachdb_build_timestamp

Build information
Build TimestampTime
cockroachdb_capacity_available

Available storage capacity
Capacity Availablebytes
cockroachdb_capacity_reserved

Capacity reserved for snapshots
Capacity Reservedbytes
cockroachdb_capacity_total

Total storage capacity
Capacity Totalbytes
cockroachdb_capacity_used

Used storage capacity
Capacity Usedbytes
cockroachdb_clock_offset_meannanos

Mean clock offset with other nodes
Clock Offset Meannanosnanoseconds
cockroachdb_clock_offset_stddevnanos

Stdddev clock offset with other nodes
Clock Offset Stddevnanosnanoseconds
cockroachdb_compactor_compactingnanos

Time spent compacting ranges
Compactor Compactingnanosnanoseconds / second
cockroachdb_compactor_compactions_failure

Number of failed compaction requests sent to the storage engine
Compactor Compactions FailureRequests / second
cockroachdb_compactor_compactions_success

Number of successful compaction requests sent to the storage engine
Compactor Compactions SuccessRequests / second
cockroachdb_compactor_suggestionbytes_compacted

Number of logical bytes compacted from suggested compactions
Compactor Suggestionbytes Compactedbytes / second
cockroachdb_compactor_suggestionbytes_queued

Number of logical bytes in suggested compactions in the queue
Compactor Suggestionbytes Queuedbytes
cockroachdb_compactor_suggestionbytes_skipped

Number of logical bytes in suggested compactions that were not compacted
Compactor Suggestionbytes Skippedbytes / second
cockroachdb_distsender_batches_partial

Number of partial batches processed
Distsender Batches Partialper second
cockroachdb_distsender_batches_total

Number of batches processed
Distsender Batches Totalper second
cockroachdb_distsender_errors_notleaseholder

Number of NotLeaseHolderErrors encountered
Distsender Errors NotleaseholderErrors / second
cockroachdb_distsender_rpc_sent_local

Number of local RPCs sent
Distsender Rpc Sent Localper second
cockroachdb_distsender_rpc_sent_nextreplicaerror

Number of RPCs sent due to per-replica errors
Distsender Rpc Sent NextreplicaerrorErrors / second
cockroachdb_distsender_rpc_sent_total

Number of RPCs sent
Distsender Rpc Sent Totalper second
cockroachdb_exec_error

Number of batch KV requests that failed to execute on this node
Exec ErrorRequests / second
cockroachdb_exec_latency

Average Latency of batch KV requests executed on this node since last pool
Exec Latencynanoseconds
cockroachdb_exec_success

Number of batch KV requests executed successfully on this node
Exec SuccessRequests / second
cockroachdb_gcbytesage

Cumulative age of non-live data
Gcbytesageseconds
cockroachdb_gossip_bytes_received

Number of received gossip bytes
Gossip Bytes Receivedbytes / second
cockroachdb_gossip_bytes_sent

Number of sent gossip bytes
Gossip Bytes Sentbytes / second
cockroachdb_gossip_connections_incoming

Number of active incoming gossip connections
Gossip Connections IncomingConnections
cockroachdb_gossip_connections_outgoing

Number of active outgoing gossip connections
Gossip Connections OutgoingConnections
cockroachdb_gossip_connections_refused

Number of refused incoming gossip connections
Gossip Connections RefusedConnections / second
cockroachdb_gossip_infos_received

Number of received gossip Info objects
Gossip Infos Receivedper second
cockroachdb_gossip_infos_sent

Number of sent gossip Info objects
Gossip Infos Sentper second
cockroachdb_intentage

Cumulative age of intents
Intentageseconds
cockroachdb_intentbytes

Number of bytes in intent KV pairs
Intentbytesbytes
cockroachdb_intentcount

Count of intent keys
IntentcountKeys
cockroachdb_keybytes

Number of bytes taken up by keys
KeybytesBytes
cockroachdb_keycount

Count of all keys
KeycountKeys
cockroachdb_lastupdatenanos

Time since the last update of Unix epoch at which bytes/keys/intents metrics
Lastupdatenanosnanoseconds
cockroachdb_leases_epoch

Number of replica leaseholders using epoch-based leases
Leases Epoch
cockroachdb_leases_error

Number of failed lease requests
Leases ErrorRequests / second
cockroachdb_leases_expiration

Number of replica leaseholders using expiration-based leases
Leases Expiration
cockroachdb_leases_success

Number of successful lease requests
Leases SuccessRequests / second
cockroachdb_leases_transfers_error

Number of failed lease transfers
Leases Transfers Errorper second
cockroachdb_leases_transfers_success

Number of successful lease transfers
Leases Transfers Successper second
cockroachdb_livebytes

Number of bytes of live data (keys plus values)
Livebytesbytes
cockroachdb_livecount

Count of live keys
LivecountKeys
cockroachdb_liveness_epochincrements

Number of times this node has incremented its liveness epoch
Liveness Epochincrementsper second
cockroachdb_liveness_heartbeatfailures

Number of failed node liveness heartbeats from this node
Liveness Heartbeatfailuresper second
cockroachdb_liveness_heartbeatlatency

Average node liveness heartbeat latency since last pool
Liveness Heartbeatlatencynanoseconds
cockroachdb_liveness_heartbeatsuccesses

Number of successful node liveness heartbeats from this node
Liveness Heartbeatsuccessesper second
cockroachdb_liveness_livenodes

Number of live nodes in the cluster (will be 0 if this node is not itself live)
Liveness Livenodes
cockroachdb_node_id

Node ID with labels for advertised RPC and HTTP addresses
Node Id
cockroachdb_queue_consistency_pending

Number of pending replicas in the consistency checker queue
Queue Consistency Pending
cockroachdb_queue_consistency_process_failure

Number of replicas that failed processing in the consistency checker queue
Queue Consistency Process Failureper second
cockroachdb_queue_consistency_process_success

Number of replicas successfully processed by the consistency checker queue
Queue Consistency Process Successper second
cockroachdb_queue_consistency_processingnanos

nanoseconds spent to process replicas in the consistency checker queue
Queue Consistency Processingnanosnanoseconds / second
cockroachdb_queue_gc_info_abortspanconsidered

Number of AbortSpan entries old enough to be considered for removal
Queue Gc Info Abortspanconsideredper second
cockroachdb_queue_gc_info_abortspangcnum

Number of AbortSpan entries fit for removal
Queue Gc Info Abortspangcnumper second
cockroachdb_queue_gc_info_abortspanscanned

Number of transactions present in the AbortSpan scanned from the engine
Queue Gc Info AbortspanscannedTransactions / second
cockroachdb_queue_gc_info_intentsconsidered

Number of 'old' intents
Queue Gc Info Intentsconsideredper second
cockroachdb_queue_gc_info_intenttxns

Number of associated distinct transactions
Queue Gc Info IntenttxnsTransactions / second
cockroachdb_queue_gc_info_numkeysaffected

Number of keys with GC'able data
Queue Gc Info NumkeysaffectedKeys / second
cockroachdb_queue_gc_info_pushtxn

Number of attempted pushes
Queue Gc Info Pushtxnper second
cockroachdb_queue_gc_info_resolvesuccess

Number of successful intent resolutions
Queue Gc Info Resolvesuccessper second
cockroachdb_queue_gc_info_resolvetotal

Number of attempted intent resolutions
Queue Gc Info Resolvetotalper second
cockroachdb_queue_gc_info_transactionspangcaborted

Number of GC'able entries corresponding to aborted transactions
Queue Gc Info Transactionspangcabortedper second
cockroachdb_queue_gc_info_transactionspangccommitted

Number of GC'able entries corresponding to committed transactions
Queue Gc Info Transactionspangccommittedper second
cockroachdb_queue_gc_info_transactionspangcpending

Number of GC'able entries corresponding to pending transactions
Queue Gc Info Transactionspangcpendingper second
cockroachdb_queue_gc_info_transactionspanscanned

Number of entries in transaction spans scanned from the engine
Queue Gc Info Transactionspanscannedper second
cockroachdb_queue_gc_pending

Number of pending replicas in the GC queue
Queue Gc Pending
cockroachdb_queue_gc_process_failure

Number of replicas that failed processing in the GC queue
Queue Gc Process Failureper second
cockroachdb_queue_gc_process_success

Number of replicas successfully processed by the GC queue
Queue Gc Process Successper second
cockroachdb_queue_gc_processingnanos

Time spent to process replicas in the GC queue
Queue Gc Processingnanosnanoseconds / second
cockroachdb_queue_raftlog_pending

Number of pending replicas in the Raft log queue
Queue Raftlog Pending
cockroachdb_queue_raftlog_process_failure

Number of replicas that failed processing in the Raft log queue
Queue Raftlog Process Failureper second
cockroachdb_queue_raftlog_process_success

Number of replicas successfully processed by the Raft log queue
Queue Raftlog Process Successper second
cockroachdb_queue_raftlog_processingnanos

Time spent to process replicas in the Raft log queue
Queue Raftlog Processingnanosnanoseconds / second
cockroachdb_queue_raftsnapshot_pending

Number of pending replicas in the Raft repair queue
Queue Raftsnapshot Pending
cockroachdb_queue_raftsnapshot_process_failure

Number of replicas that failed processing in the Raft repair queue
Queue Raftsnapshot Process Failureper second
cockroachdb_queue_raftsnapshot_process_success

Number of replicas successfully processed by the Raft repair queue
Queue Raftsnapshot Process Successper second
cockroachdb_queue_raftsnapshot_processingnanos

Time spent to process replicas in the Raft repair queue
Queue Raftsnapshot Processingnanosnanoseconds / second
cockroachdb_queue_replicagc_pending

Number of pending replicas in the replica GC queue
Queue Replicagc Pending
cockroachdb_queue_replicagc_process_failure

Number of replicas that failed processing in the replica GC queue
Queue Replicagc Process Failureper second
cockroachdb_queue_replicagc_process_success

Number of replicas successfully processed by the replica GC queue
Queue Replicagc Process Successper second
cockroachdb_queue_replicagc_processingnanos

Time spent processing replicas in the replica GC queue
Queue Replicagc Processingnanosnanoseconds / second
cockroachdb_queue_replicagc_removereplica

Number of replica removals attempted by the replica gc queue
Queue Replicagc Removereplicaper second
cockroachdb_queue_replicate_addreplica

Number of replica additions attempted by the replicate queue
Queue Replicate Addreplicaper second
cockroachdb_queue_replicate_pending

Number of pending replicas in the replicate queue
Queue Replicate Pending
cockroachdb_queue_replicate_process_failure

Number of replicas that failed processing in the replicate queue
Queue Replicate Process Failureper second
cockroachdb_queue_replicate_process_success

Number of replicas successfully processed by the replicate queue
Queue Replicate Process Successper second
cockroachdb_queue_replicate_processingnanos

Time spent to process replicas in the replicate queue
Queue Replicate Processingnanosnanoseconds / second
cockroachdb_queue_replicate_purgatory

Number of replicas in the replicate queue's purgatory, awaiting allocation options
Queue Replicate Purgatory
cockroachdb_queue_replicate_rebalancereplica

Number of replica rebalancer-initiated additions attempted by the replicate queue
Queue Replicate Rebalancereplicaper second
cockroachdb_queue_replicate_removedeadreplica

Number of dead replica removals attempted by the replicate queue (typically in response to a node outage)
Queue Replicate Removedeadreplicaper second
cockroachdb_queue_replicate_removereplica

Number of replica removals attempted by the replicate queue (typically in response to a rebalancer-initiated addition)
Queue Replicate Removereplicaper second
cockroachdb_queue_replicate_transferlease

Number of range lease transfers attempted by the replicate queue
Queue Replicate Transferleaseper second
cockroachdb_queue_split_pending

Number of pending replicas in the split queue
Queue Split Pending
cockroachdb_queue_split_process_failure

Number of replicas that failed processing in the split queue
Queue Split Process Failureper second
cockroachdb_queue_split_process_success

Number of replicas successfully processed by the split queue
Queue Split Process Successper second
cockroachdb_queue_split_processingnanos

Time spent to process replicas in the split queue
Queue Split Processingnanosnanoseconds / second
cockroachdb_queue_tsmaintenance_pending

Number of pending replicas in the time series maintenance queue
Queue Tsmaintenance Pending
cockroachdb_queue_tsmaintenance_process_failure

Number of replicas that failed processing in the time series maintenance queue
Queue Tsmaintenance Process Failureper second
cockroachdb_queue_tsmaintenance_process_success

Number of replicas successfully processed by the time series maintenance queue
Queue Tsmaintenance Process Successper second
cockroachdb_queue_tsmaintenance_processingnanos

Time spent to process replicas in the time series maintenance queue
Queue Tsmaintenance Processingnanosnanoseconds / second
cockroachdb_raft_commandsapplied

Count of Raft commands applied
Raft CommandsappliedCommands / second
cockroachdb_raft_enqueued_pending

Number of pending outgoing messages in the Raft Transport queue
Raft Enqueued Pending
cockroachdb_raft_heartbeats_pending

Number of pending heartbeats and responses waiting to be coalesced
Raft Heartbeats Pending
cockroachdb_raft_process_commandcommit_latency

Average latency histogram for committing Raft commands since last pool
Raft Process Commandcommit Latencynanoseconds
cockroachdb_raft_process_logcommit_latency

Average Latency histogram for committing Raft log entries since last pool
Raft Process Logcommit Latencynanoseconds
cockroachdb_raft_process_tickingnanos

Time spent in store.processRaft() processing replica.Tick()
Raft Process Tickingnanosnanoseconds / second
cockroachdb_raft_process_workingnanos

Time spent in store.processRaft() working
Raft Process Workingnanosnanoseconds / second
cockroachdb_raft_rcvd_app

Number of MsgApp messages received by this store
Raft Rcvd Appper second
cockroachdb_raft_rcvd_appresp

Number of MsgAppResp messages received by this store
Raft Rcvd Apprespper second
cockroachdb_raft_rcvd_dropped

Number of dropped incoming Raft messages
Raft Rcvd Droppedper second
cockroachdb_raft_rcvd_heartbeat

Number of (coalesced, if enabled) MsgHeartbeat messages received by this store
Raft Rcvd Heartbeatper second
cockroachdb_raft_rcvd_heartbeatresp

Number of (coalesced, if enabled) MsgHeartbeatResp messages received by this store
Raft Rcvd Heartbeatrespper second
cockroachdb_raft_rcvd_prevote

Number of MsgPreVote messages received by this store
Raft Rcvd Prevoteper second
cockroachdb_raft_rcvd_prevoteresp

Number of MsgPreVoteResp messages received by this store
Raft Rcvd Prevoterespper second
cockroachdb_raft_rcvd_prop

Number of MsgProp messages received by this store
Raft Rcvd Propper second
cockroachdb_raft_rcvd_snap

Number of MsgSnap messages received by this store
Raft Rcvd Snapper second
cockroachdb_raft_rcvd_timeoutnow

Number of MsgTimeoutNow messages received by this store
Raft Rcvd Timeoutnowper second
cockroachdb_raft_rcvd_transferleader

Number of MsgTransferLeader messages received by this store
Raft Rcvd Transferleaderper second
cockroachdb_raft_rcvd_vote

Number of MsgVote messages received by this store
Raft Rcvd Voteper second
cockroachdb_raft_rcvd_voteresp

Number of MsgVoteResp messages received by this store
Raft Rcvd Voterespper second
cockroachdb_raft_ticks

Number of Raft ticks queued
Raft Ticksper second
cockroachdb_raftlog_behind

Number of Raft log entries followers on other stores are behind
Raftlog BehindEntries
cockroachdb_raftlog_truncated

Number of Raft log entries truncated
Raftlog TruncatedEntries / second
cockroachdb_range_adds

Number of range additions
Range Addsper second
cockroachdb_range_raftleadertransfers

Number of raft leader transfers
Range Raftleadertransfersper second
cockroachdb_range_removes

Number of range removals
Range Removesper second
cockroachdb_range_snapshots_generated

Number of generated snapshots
Range Snapshots Generatedper second
cockroachdb_range_snapshots_normal_applied

Number of applied snapshots
Range Snapshots Normal Appliedper second
cockroachdb_range_snapshots_preemptive_applied

Number of applied pre-emptive snapshots
Range Snapshots Preemptive Appliedper second
cockroachdb_range_splits_total

Number of range splits
Range Splits Totalper second
cockroachdb_ranges

Number of ranges
Ranges
cockroachdb_ranges_unavailable

Number of ranges with fewer live replicas than needed for quorum
Ranges Unavailable
cockroachdb_ranges_underreplicated

Number of ranges with fewer live replicas than the replication target
Ranges Underreplicated
cockroachdb_rebalancing_writespersecond

Number of keys written (applied by raft) per second to the store, averaged over a large time period as used in rebalancing decisions
Rebalancing WritespersecondKeys
cockroachdb_replicas_commandqueue_combinedqueuesize

Number of commands in all CommandQueues combined
Replicas Commandqueue CombinedqueuesizeCommands
cockroachdb_replicas_commandqueue_combinedreadcount

Number of read-only commands in all CommandQueues combined
Replicas Commandqueue CombinedreadcountCommands
cockroachdb_replicas_commandqueue_combinedwritecount

Number of read-write commands in all CommandQueues combined
Replicas Commandqueue CombinedwritecountCommands
cockroachdb_replicas_commandqueue_maxoverlaps

Largest number of overlapping commands seen when adding to any CommandQueue
Replicas Commandqueue MaxoverlapsCommands
cockroachdb_replicas_commandqueue_maxreadcount

Largest number of read-only commands in any CommandQueue
Replicas Commandqueue MaxreadcountCommands
cockroachdb_replicas_commandqueue_maxsize

Largest number of commands in any CommandQueue
Replicas Commandqueue MaxsizeCommands
cockroachdb_replicas_commandqueue_maxtreesize

Largest number of intervals in any CommandQueue's interval tree
Replicas Commandqueue Maxtreesize
cockroachdb_replicas_commandqueue_maxwritecount

Largest number of read-write commands in any CommandQueue
Replicas Commandqueue MaxwritecountCommands
cockroachdb_replicas_leaders

Number of raft leaders
Replicas Leaders
cockroachdb_replicas_leaders_not_leaseholders

Number of replicas that are Raft leaders whose range lease is held by another store
Replicas Leaders Not Leaseholders
cockroachdb_replicas_leaseholders

Number of lease holders
Replicas Leaseholders
cockroachdb_replicas_quiescent

Number of quiesced replicas
Replicas Quiescent
cockroachdb_replicas_reserved

Number of replicas reserved for snapshots
Replicas Reserved
cockroachdb_replicas_total

Number of replicas
Replicas Total
cockroachdb_requests_backpressure_split

Number of backpressured writes waiting on a Range split
Requests Backpressure Split
cockroachdb_requests_slow_commandqueue

Number of requests that have been stuck for a long time in the command queue
Requests Slow CommandqueueRequests
cockroachdb_requests_slow_distsender

Number of requests that have been stuck for a long time in the dist sender
Requests Slow DistsenderRequests
cockroachdb_requests_slow_lease

Number of requests that have been stuck for a long time acquiring a lease
Requests Slow LeaseRequests
cockroachdb_requests_slow_raft

Number of requests that have been stuck for a long time in raft
Requests Slow RaftRequests
cockroachdb_rocksdb_block_cache_hits

Count of block cache hits
Rocksdb Block Cache Hits
cockroachdb_rocksdb_block_cache_misses

Count of block cache misses
Rocksdb Block Cache Misses
cockroachdb_rocksdb_block_cache_pinned_usage

Bytes pinned by the block cache
Rocksdb Block Cache Pinned Usagebytes
cockroachdb_rocksdb_block_cache_usage

Bytes used by the block cache
Rocksdb Block Cache Usagebytes
cockroachdb_rocksdb_bloom_filter_prefix_checked

Number of times the bloom filter was checked
Rocksdb Bloom Filter Prefix Checked
cockroachdb_rocksdb_bloom_filter_prefix_useful

Number of times the bloom filter helped avoid iterator creation
Rocksdb Bloom Filter Prefix Useful
cockroachdb_rocksdb_compactions_total

Number of table compactions
Rocksdb Compactions Total
cockroachdb_rocksdb_flushes_total

Number of table flushes
Rocksdb Flushes Total
cockroachdb_rocksdb_memtable_total_size

Current size of memtable
Rocksdb Memtable Total Sizebytes
cockroachdb_rocksdb_num_sstables

Number of rocksdb SSTables
Rocksdb Num SstablesTables
cockroachdb_rocksdb_read_amplification

Number of disk reads per query
Rocksdb Read AmplificationReads
cockroachdb_rocksdb_table_readers_mem_estimate

Memory used by index and filter blocks
Rocksdb Table Readers Mem Estimate
cockroachdb_round_trip_latency

Average distribution of round-trip latencies with other nodes since last pool
Round Trip Latencynanoseconds
cockroachdb_sql_bytesin

Number of SQL bytes received
Sql Bytesinbytes / second
cockroachdb_sql_bytesout

Number of SQL bytes sent
Sql Bytesoutbytes / second
cockroachdb_sql_conns

Number of active SQL connections
Sql ConnsConnections
cockroachdb_sql_ddl_count

Number of SQL DDL statements
Sql Ddl Countper second
cockroachdb_sql_delete_count

Number of SQL DELETE statements
Sql Delete Countper second
cockroachdb_sql_distsql_exec_latency

Average Latency of DistSQL statement execution since last pool
Sql Distsql Exec Latencynanoseconds
cockroachdb_sql_distsql_flows_active

Number of distributed SQL flows currently active
Sql Distsql Flows Active
cockroachdb_sql_distsql_flows_total

Number of distributed SQL flows executed
Sql Distsql Flows Totalper second
cockroachdb_sql_distsql_queries_active

Number of distributed SQL queries currently active
Sql Distsql Queries Active
cockroachdb_sql_distsql_queries_total

Number of distributed SQL queries executed
Sql Distsql Queries Totalper second
cockroachdb_sql_distsql_select_count

Number of DistSQL SELECT statements
Sql Distsql Select Countper second
cockroachdb_sql_distsql_service_latency

Average Latency of DistSQL request execution since last pool
Sql Distsql Service Latencynanoseconds
cockroachdb_sql_exec_latency

Average Latency of SQL statement execution since last pool
Sql Exec Latencynanoseconds
cockroachdb_sql_insert_count

Number of SQL INSERT statements
Sql Insert Countper second
cockroachdb_sql_mem_admin_current

Current SQL statement memory usage for admin
Sql Mem Admin Current
cockroachdb_sql_mem_admin_max

Average memory usage per SQL statement for admin since last pool
Sql Mem Admin Max
cockroachdb_sql_mem_admin_session_current

Current SQL session memory usage for admin
Sql Mem Admin Session Current
cockroachdb_sql_mem_admin_session_max

Average memory usage per SQL session for admin since last pool
Sql Mem Admin Session Max
cockroachdb_sql_mem_admin_txn_current

Current SQL transaction memory usage for admin
Sql Mem Admin Txn Current
cockroachdb_sql_mem_admin_txn_max

Average memory usage per SQL transaction for admin since the last pool.
Sql Mem Admin Txn Max
cockroachdb_sql_mem_client_current

Current SQL statement memory usage for client
Sql Mem Client Current
cockroachdb_sql_mem_client_max

Average memory usage per SQL statement for client since the last pool.
Sql Mem Client Max
cockroachdb_sql_mem_client_session_current

Current SQL session memory usage for client
Sql Mem Client Session Current
cockroachdb_sql_mem_client_session_max

Average memory usage per SQL session for client since last pool.
Sql Mem Client Session Max
cockroachdb_sql_mem_client_txn_current

Current SQL transaction memory usage for client
Sql Mem Client Txn Current
cockroachdb_sql_mem_client_txn_max

Average memory usage per SQL transaction for client since last pool.
Sql Mem Client Txn Max
cockroachdb_sql_mem_conns_current

Current SQL statement memory usage for conns
Sql Mem Conns Current
cockroachdb_sql_mem_conns_max

Average memory usage per SQL statement for conns since last pool.
Sql Mem Conns Max
cockroachdb_sql_mem_conns_session_current

Current SQL session memory usage for conns
Sql Mem Conns Session Current
cockroachdb_sql_mem_conns_session_max

Average memory usage per SQL session for conns since last pool.
Sql Mem Conns Session Max
cockroachdb_sql_mem_conns_txn_current

Current SQL transaction memory usage for conns
Sql Mem Conns Txn Current
cockroachdb_sql_mem_conns_txn_max

Average memory usage per SQL transaction for conns since last pool.
Sql Mem Conns Txn Max
cockroachdb_sql_mem_distsql_current

Current SQL statement memory usage for distsql
Sql Mem Distsql Current
cockroachdb_sql_mem_distsql_max

Average memory usage per SQL statement for distsql since last pool.
Sql Mem Distsql Max
cockroachdb_sql_mem_internal_current

Current sql statement memory usage for internal
Sql Mem Internal Current
cockroachdb_sql_mem_internal_max

Average memory usage per SQL statement for internal since last pool.
Sql Mem Internal Max
cockroachdb_sql_mem_internal_session_current

Current sql session memory usage for internal
Sql Mem Internal Session Current
cockroachdb_sql_mem_internal_session_max

Average memory usage per SQL session for internal since last pool.
Sql Mem Internal Session Max
cockroachdb_sql_mem_internal_txn_current

Current sql transaction memory usage for internal
Sql Mem Internal Txn Current
cockroachdb_sql_mem_internal_txn_max

Average memory usage per SQL transaction for internal since last pool
Sql Mem Internal Txn Max
cockroachdb_sql_misc_count

Number of other SQL statements
Sql Misc Countper second
cockroachdb_sql_query_count

Number of SQL queries
Sql Query Countper second
cockroachdb_sql_select_count

Number of SQL SELECT statements
Sql Select Countper second
cockroachdb_sql_service_latency

Average latency of SQL request execution since last pool
Sql Service Latencynanoseconds
cockroachdb_sql_txn_abort_count

Number of SQL transaction ABORT statements
Sql Txn Abort Countper second
cockroachdb_sql_txn_begin_count

Number of SQL transaction BEGIN statements
Sql Txn Begin Countper second
cockroachdb_sql_txn_commit_count

Number of SQL transaction COMMIT statements
Sql Txn Commit Countper second
cockroachdb_sql_txn_rollback_count

Number of SQL transaction ROLLBACK statements
Sql Txn Rollback Countper second
cockroachdb_sql_update_count

Number of SQL UPDATE statements
Sql Update Countper second
cockroachdb_sys_cgo_allocbytes

Current bytes of memory allocated by cgo
Sys Cgo Allocbytesbytes
cockroachdb_sys_cgo_totalbytes

Total bytes of memory allocated by cgo, but not released
Sys Cgo Totalbytesbytes
cockroachdb_sys_cgocalls

Total number of cgo calls
Sys Cgocalls
cockroachdb_sys_cpu_sys_ns

Total system CPU time
Sys Cpu Sys Nsnanoseconds
cockroachdb_sys_cpu_sys_percent

Current system CPU percentage
Sys Cpu Sys Percent
cockroachdb_sys_cpu_user_ns

Total user CPU time
Sys Cpu User Nsnanoseconds
cockroachdb_sys_cpu_user_percent

Current user CPU percentage
Sys Cpu User Percentpercent
cockroachdb_sys_fd_open

Process open file descriptors
Sys Fd Open
cockroachdb_sys_fd_softlimit

Process open FD soft limit
Sys Fd Softlimit
cockroachdb_sys_gc_count

Total number of GC runs
Sys Gc Count
cockroachdb_sys_gc_pause_ns

Total GC pause
Sys Gc Pause Nsnanoseconds
cockroachdb_sys_gc_pause_percent

Current GC pause percentage
Sys Gc Pause Percentpercent
cockroachdb_sys_go_allocbytes

Current bytes of memory allocated by go
Sys Go Allocbytesbytes
cockroachdb_sys_go_totalbytes

Total bytes of memory allocated by go, but not released
Sys Go Totalbytesbytes
cockroachdb_sys_goroutines

Current number of goroutines
Sys Goroutines
cockroachdb_sys_rss

Current process RSS
Sys Rss
cockroachdb_sys_uptime

Process uptime
Sys Uptimeseconds
cockroachdb_sysbytes

Number of bytes in system KV pairs
Sysbytesbytes
cockroachdb_syscount

Count of system KV pairs
Syscount
cockroachdb_timeseries_write_bytes

Total size of metric samples written to disk
Timeseries Write Bytesbytes / second
cockroachdb_timeseries_write_errors

Total errors encountered while attempting to write metrics to disk
Timeseries Write ErrorsErrors / second
cockroachdb_timeseries_write_samples

Total number of metric samples written to disk
Timeseries Write Samplesper second
cockroachdb_totalbytes

Total number of bytes taken up by keys and values including non-live data
TotalbytesBytes
cockroachdb_tscache_skl_read_pages

Number of pages in the read timestamp cache
Tscache Skl Read Pages
cockroachdb_tscache_skl_read_rotations

Number of page rotations in the read timestamp cache
Tscache Skl Read Rotationsper second
cockroachdb_tscache_skl_write_pages

Number of pages in the write timestamp cache
Tscache Skl Write Pages
cockroachdb_tscache_skl_write_rotations

Number of page rotations in the write timestamp cache
Tscache Skl Write Rotationsper second
cockroachdb_txn_abandons

Number of abandoned KV transactions
Txn Abandonsper second
cockroachdb_txn_aborts

Number of aborted KV transactions
Txn Abortsper second
cockroachdb_txn_autoretries

Number of automatic retries to avoid serializable restarts
Txn Autoretriesper second
cockroachdb_txn_commits

Number of committed KV transactions (including 1PC)
Txn Commitsper second
cockroachdb_txn_commits1PC

Number of committed one-phase KV transactions
Txn Commits1Pcper second
cockroachdb_txn_durations

Average KV transaction durations since last pool.
Txn Durations
cockroachdb_txn_restarts

Average Number of restarted KV transactions since last pool.
Txn Restarts
cockroachdb_txn_restarts_deleterange

Number of restarts due to a forwarded commit timestamp and a DeleteRange command
Txn Restarts Deleterangeper second
cockroachdb_txn_restarts_possiblereplay

Number of restarts due to possible replays of command batches at the storage layer
Txn Restarts Possiblereplayper second
cockroachdb_txn_restarts_serializable

Number of restarts due to a forwarded commit timestamp and isolation=SERIALIZABLE
Txn Restarts Serializableper second
cockroachdb_txn_restarts_writetooold

Number of restarts due to a concurrent writer committing first
Txn Restarts Writetoooldper second
cockroachdb_valbytes

Number of bytes taken up by values
Valbytesbytes
cockroachdb_valcount

Count of all values
Valcount