CockroachDB Gossip I/O Statistics
Description
It monitors the crockroachdb gossip i/o parameters.Cockroachdb gossip i/o parameters : Cockroachdb Gossip Bytess Received,Cockroachdb Gossip Bytess Sent,Cockroachdb Gossip Connections Incoming,Cockroachdb Gossip Connections Outgoing,Cockroachdb Gossip Connections Refused,Cockroachdb Gossip Infos Received,Cockroachdb Gossip Infos Sent. Validated on cockroachdb v2.1.6.
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| CockroachDB Gossip I/O Statistics | cockroachdb.gossip.Bytess.sent | Cockroachdb Gossip Bytess Sent | Bytes | Number of sent gossip Bytess |
| cockroachdb.gossip.infos.received | Cockroachdb Gossip Infos Received | count | Number of received gossip Info objects | |
| cockroachdb.gossip.infos.sent | Cockroachdb Gossip Infos Sent | count | Number of sent gossip Info objects | |
| cockroachdb.gossip.connections.refused | Cockroachdb Gossip Connections Refused | count | Number of refused incoming gossip connections | |
| cockroachdb.gossip.connections.incoming | Cockroachdb Gossip Connections Incoming | count | Number of active incoming gossip connections | |
| cockroachdb.gossip.connections.outgoing | Cockroachdb Gossip Connections Outgoing | count | Number of active outgoing gossip connections | |
| cockroachdb.gossip.Bytess.received | Cockroachdb Gossip Bytess Received | Bytes | Number of received gossip Bytess |
CockroachDB Queue Statistics
Description
It monitors the cockroachdb queue parameters. Cockroachdb queue parameters : Cockroachdb Queue Consistency Pending,Cockroachdb Queue Consistency Process Failure,Cockroachdb Queue Consistency Processingnanos,Cockroachdb Queue Gc Pending,Cockroachdb Queue Gc Process Failure,Cockroachdb Queue Gc Processingnanos,Cockroachdb Queue Replicate Pending,Cockroachdb Queue Replicate Process Failure,Cockroachdb Queue Replicate Processingnanos,Cockroachdb Queue Split Pending,Cockroachdb Queue Split Process Failure,Cockroachdb Queue Split Processingnanos,Cockroachdb Queue Tsmaintenance Pending,Cockroachdb Queue Tsmaintenance Process Failure,Cockroachdb Queue Tsmaintenance Processingnanos. Validated on cockroachdb v2.1.6.
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| CockroachDB Queue Statistics | cockroachdb.queue.tsmaintenance.pending | Cockroachdb Queue Tsmaintenance Pending | count | Number of pending replicas in the time series maintenance queue. |
| cockroachdb.queue.gc.process.failure | Cockroachdb Queue Gc Process Failure | count | Number of replicas which failed processing in the GC queue. | |
| cockroachdb.queue.replicate.process.failure | Cockroachdb Queue Replicate Process Failure | count | Number of replicas which failed processing in the replicate queue. | |
| cockroachdb.queue.consistency.processingnanos | Cockroachdb Queue Consistency Processingnanos | s | Nanoseconds spent processing replicas in the consistency checker queue. | |
| cockroachdb.queue.consistency.pending | Cockroachdb Queue Consistency Pending | count | Number of pending replicas in the consistency checker queue. | |
| cockroachdb.queue.consistency.process.failure | Cockroachdb Queue Consistency Process Failure | count | Number of replicas which failed processing in the consistency checker queue. | |
| cockroachdb.queue.split.pending | Cockroachdb Queue Split Pending | count | Number of pending replicas in the split queue. | |
| cockroachdb.queue.gc.pending | Cockroachdb Queue Gc Pending | count | Number of pending replicas in the GC queue. | |
| cockroachdb.queue.gc.processingnanos | Cockroachdb Queue Gc Processingnanos | count | Nanoseconds spent processing replicas in the GC queue. | |
| cockroachdb.queue.split.processingnanos | Cockroachdb Queue Split Processingnanos | s | Nanoseconds spent processing replicas in the split queue. | |
| cockroachdb.queue.replicate.processingnanos | Cockroachdb Queue Replicate Processingnanos | s | Nanoseconds spent processing replicas in the replicate queue. | |
| cockroachdb.queue.tsmaintenance.processingnanos | Cockroachdb Queue Tsmaintenance Processingnanos | s | Nanoseconds spent processing replicas in the time series maintenance queue. | |
| cockroachdb.queue.split.process.failure | Cockroachdb Queue Split Process Failure | count | Number of replicas which failed processing in the split queue | |
| cockroachdb.queue.tsmaintenance.process.failure | Cockroachdb Queue Tsmaintenance Process Failure | count | Number of replicas which failed processing in the time series maintenance queue. | |
| cockroachdb.queue.replicate.pending | Cockroachdb Queue Replicate Pending | count | Number of pending replicas in the replicate queue |
CockroachDB Replica Statistics
Description
It monitors the cockroachdb replica parameters. Cockroachdb replica parameter : Cockroachdb Replicas Leaders,Cockroachdb Replicas Leaders Not_Leaseholders,Cockroachdb Replicas Leaseholders,Cockroachdb Replicas Quiescent,Cockroachdb Replicas Reserved,Cockroachdb Replicas Total. Validated on cockroachdb v2.1.6.
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| CockroachDB Replica Statistics | cockroachdb.replicas.leaders | Cockroachdb Replicas Leaders | count | Number of raft leaders |
| cockroachdb.replicas.total | Cockroachdb Replicas Total | count | Number of replicas | |
| cockroachdb.replicas.quiescent | Cockroachdb Replicas Quiescent | count | Number of quiesced replicas | |
| cockroachdb.replicas.leaseholders | Cockroachdb Replicas Leaseholders | count | Number of lease holders | |
| cockroachdb.replicas.leaders.not_leaseholders | Cockroachdb Replicas Leaders Not Leaseholders | count | Number of replicas that are Raft leaders whose range lease is held by another store | |
| cockroachdb.replicas.reserved | Cockroachdb Replicas Reserved | count | Number of replicas reserved for snapshots |
CockroachDB RocksDB Statistics
Description
It monitors the cockroachdb rocksdb parameters. Cockroachdb rocksdb parameters : Cockroachdb Rocksdb Block Cache Hits,Cockroachdb Rocksdb Block Cache Misses,Cockroachdb Rocksdb Block Cache Pinned Usage,Cockroachdb Rocksdb Block Cache Usage,Cockroachdb Rocksdb Read Amplification,Cockroachdb Rocksdb Table Readers Mem Estimate. Validated on cockroachdb v2.1.6.
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| CockroachDB RocksDB Statistics | cockroachdb.rocksdb.block.cache.usage | Cockroachdb Rocksdb Block Cache Usage | Bytes | Bytes used by the block cache |
| cockroachdb.rocksdb.table.readers.mem.estimate | Cockroachdb Rocksdb Table Readers Mem Estimate | Bytes | Memory used by index and filter blocks | |
| cockroachdb.rocksdb.block.cache.hits | Cockroachdb Rocksdb Block Cache Hits | count | Count of block cache hits | |
| cockroachdb.rocksdb.block.cache.misses | Cockroachdb Rocksdb Block Cache Misses | count | Count of block cache misses | |
| cockroachdb.rocksdb.read.amplification | Cockroachdb Rocksdb Read Amplification | count | Number of disk reads per query | |
| cockroachdb.rocksdb.block.cache.pinned.usage | Cockroachdb Rocksdb Block Cache Pinned Usage | Bytes | Bytes pinned by the block cache |
CockroachDB SQL Statistics
Description
It monitors the cockroachdb sql parameters. Cockroachdb sql parameters : Cockroachdb Sql Bytessin,Cockroachdb Sql Bytessout,Cockroachdb Sql Conns,Cockroachdb Sql Delete Count,Cockroachdb Sql Distsql Exec Latency,Cockroachdb Sql Distsql Flows Active,Cockroachdb Sql Distsql Queries Active,Cockroachdb Sql Distsql Service Latency,Cockroachdb Sql Exec Latency,Cockroachdb Sql Insert Count,Cockroachdb Sql Mem Admin Current,Cockroachdb Sql Mem Admin Session Current,Cockroachdb Sql Mem Admin Txn Current,Cockroachdb Sql Mem Conns Current,Cockroachdb Sql Mem Conns Session Current,Cockroachdb Sql Mem Conns Txn Current,Cockroachdb Sql Mem Distsql Current,Cockroachdb Sql Mem Internal Current,Cockroachdb Sql Mem Internal Session Current,Cockroachdb Sql Mem Internal Txn Current,Cockroachdb Sql Query Count,Cockroachdb Sql Select Count,Cockroachdb Sql Update Count. Validated on cockroachdb v2.1.6.
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| CockroachDB SQL Statistics | cockroachdb.sql.exec.latency | Cockroachdb Sql Exec Latency | s | Latency in nanoseconds of SQL statement execution. |
| cockroachdb.sql.distsql.flows.active | Cockroachdb Sql Distsql Flows Active | count | Number of distributed SQL flows currently active. | |
| cockroachdb.sql.mem.internal.session.current | Cockroachdb Sql Mem Internal Session Current | Bytes | Current sql session memory usage for internal. | |
| cockroachdb.sql.distsql.exec.latency | Cockroachdb Sql Distsql Exec Latency | s | Latency in nanoseconds of DistSQL statement execution. | |
| cockroachdb.sql.mem.admin.current | Cockroachdb Sql Mem Admin Current | Bytes | Current sql statement memory usage for admin. | |
| cockroachdb.sql.query.count | Cockroachdb Sql Query Count | count | Number of SQL queries. | |
| cockroachdb.sql.mem.internal.txn.current | Cockroachdb Sql Mem Internal Txn Current | Bytes | Current sql transaction memory usage for internal. | |
| cockroachdb.sql.mem.internal.current | Cockroachdb Sql Mem Internal Current | Bytes | Current sql statement memory usage for internal. | |
| cockroachdb.sql.conns | Cockroachdb Sql Conns | count | Number of active sql connections. | |
| cockroachdb.sql.mem.admin.txn.current | Cockroachdb Sql Mem Admin Txn Current | Bytes | Current sql transaction memory usage for admin. | |
| cockroachdb.sql.mem.conns.session.current | Cockroachdb Sql Mem Conns Session Current | Bytes | Current sql session memory usage for conns. | |
| cockroachdb.sql.mem.conns.current | Cockroachdb Sql Mem Conns Current | Bytes | Current sql statement memory usage for conns. | |
| cockroachdb.sql.select.count | Cockroachdb Sql Select Count | count | Number of SQL SELECT statements. | |
| cockroachdb.sql.mem.admin.session.current | Cockroachdb Sql Mem Admin Session Current | Bytes | Current sql session memory usage for admin. | |
| cockroachdb.sql.distsql.service.latency | Cockroachdb Sql Distsql Service Latency | s | Latency in nanoseconds of DistSQL request execution. | |
| cockroachdb.sql.distsql.queries.active | Cockroachdb Sql Distsql Queries Active | count | Number of distributed SQL queries currently active. | |
| cockroachdb.sql.delete.count | Cockroachdb Sql Delete Count | count | Number of SQL DELETE statements. | |
| cockroachdb.sql.update.count | Cockroachdb Sql Update Count | count | Number of SQL UPDATE statements. | |
| cockroachdb.sql.Bytessout | Cockroachdb Sql Bytessout | Bytes | Number of sql Bytess sent. | |
| cockroachdb.sql.mem.conns.txn.current | Cockroachdb Sql Mem Conns Txn Current | Bytes | Current sql transaction memory usage for conns. | |
| cockroachdb.sql.insert.count | Cockroachdb Sql Insert Count | count | Number of SQL INSERT statements. | |
| cockroachdb.sql.mem.distsql.current | Cockroachdb Sql Mem Distsql Current | Bytes | Current sql statement memory usage for distsql. | |
| cockroachdb.sql.Bytessin | Cockroachdb Sql Bytessin | Bytes | Number of sql Bytess received. |
CockroachDB System Performance and Statistics
Description
It monitors cockroachdb parameters,cockroachdb system parameters,cockroachdb liveness parameters. Cockroachdb liveness parameter : Cockroachdb Liveness Livenodes. Cockroachdb system parameters : Cockroachdb Sys Cgocalls,Cockroachdb Sys Cpu Sys Percent,Cockroachdb Sys Cpu User Ns,Cockroachdb Sys Cpu User Percent,Cockroachdb Sys Fd Open,Cockroachdb Sys Goroutines,Cockroachdb Sys Uptime,Cockroachdb Syscount. Cockroachdb parameters : Cockroachdb Total Capacity,Cockroachdb Capacity Available,Cockroachdb Capacity Used,Cockroachdb LiveBytess,Cockroachdb Livecount. Validated on cockroachdb v2.1.6.
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| CockroachDB Liveness Statistics | cockroachdb.liveness.livenodes | Cockroachdb Liveness Livenodes | count | Number of live nodes in the cluster (will be 0 if this node is not itself live). |
| CockroachDB Statistics | cockroachdb.livecount | Cockroachdb Livecount | count | Count of live keys. |
| cockroachdb.capacity.used | Cockroachdb Capacity Used | Bytes | Used storage capacity. | |
| cockroachdb.capacity.total | Cockroachdb Total Capacity | Bytes | Total storage capacity. | |
| cockroachdb.capacity.available | Cockroachdb Capacity Available | Bytes | Available storage capacity. | |
| cockroachdb.liveBytess | Cockroachdb LiveBytess | Bytes | Number of Bytess of live data (keys plus values). | |
| CockroachDB System Statistics | cockroachdb.sys.fd.open | Cockroachdb Sys Fd Open | count | Process open file descriptors. |
| cockroachdb.sys.cpu.user.percent | Cockroachdb Sys Cpu User Percent | % | Current user cpu percentage. | |
| cockroachdb.sys.cpu.user.ns | Cockroachdb Sys Cpu User Ns | s | Total user cpu time in nanoseconds. | |
| cockroachdb.sys.cgocalls | Cockroachdb Sys Cgocalls | count | Total number of cgo calls. | |
| cockroachdb.sys.goroutines | Cockroachdb Sys Goroutines | count | Current number of goroutines. | |
| cockroachdb.syscount | Cockroachdb Syscount | count | Count of system KV pairs. | |
| cockroachdb.sys.uptime | Cockroachdb Sys Uptime | s | Process uptime in seconds. | |
| cockroachdb.sys.cpu.sys.percent | Cockroachdb Sys Cpu Sys Percent | % | Current system cpu percentage. |
CockroachDB Transaction Statistics
Description
It monitors the cockroachdb transaction parameters. Cockroachdb transaction parameters: Cockroachdb Txn Aborts,Cockroachdb Txn Autoretries,Cockroachdb Txn Commits,Cockroachdb Txn Commits1Pc,Cockroachdb Txn Durations,Cockroachdb Txn Restarts. Validated on cockroachdb v2.1.6.
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| CockroachDB Transaction Statistics | cockroachdb.txn.commits1PC | Cockroachdb Txn Commits1Pc | count | Number of committed one-phase KV transactions. |
| cockroachdb.txn.durations | Cockroachdb Txn Durations | s | KV transaction durations in nanoseconds. | |
| cockroachdb.txn.commits | Cockroachdb Txn Commits | count | Number of committed KV transactions (including 1PC). | |
| cockroachdb.txn.aborts | Cockroachdb Txn Aborts | count | Number of aborted KV transactions. | |
| cockroachdb.txn.autoretries | Cockroachdb Txn Autoretries | count | Number of automatic retries to avoid serializable restarts. | |
| cockroachdb.txn.restarts | Cockroachdb Txn Restarts | count | Number of restarted KV transactions. |