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 NameMetric NameMetric Display NameUnitDescription
CockroachDB Gossip I/O Statisticscockroachdb.gossip.Bytess.sentCockroachdb Gossip Bytess SentBytesNumber of sent gossip Bytess
cockroachdb.gossip.infos.receivedCockroachdb Gossip Infos ReceivedcountNumber of received gossip Info objects
cockroachdb.gossip.infos.sentCockroachdb Gossip Infos SentcountNumber of sent gossip Info objects
cockroachdb.gossip.connections.refusedCockroachdb Gossip Connections RefusedcountNumber of refused incoming gossip connections
cockroachdb.gossip.connections.incomingCockroachdb Gossip Connections IncomingcountNumber of active incoming gossip connections
cockroachdb.gossip.connections.outgoingCockroachdb Gossip Connections OutgoingcountNumber of active outgoing gossip connections
cockroachdb.gossip.Bytess.receivedCockroachdb Gossip Bytess ReceivedBytesNumber 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 NameMetric NameMetric Display NameUnitDescription
CockroachDB Queue Statisticscockroachdb.queue.tsmaintenance.pendingCockroachdb Queue Tsmaintenance PendingcountNumber of pending replicas in the time series maintenance queue.
cockroachdb.queue.gc.process.failureCockroachdb Queue Gc Process FailurecountNumber of replicas which failed processing in the GC queue.
cockroachdb.queue.replicate.process.failureCockroachdb Queue Replicate Process FailurecountNumber of replicas which failed processing in the replicate queue.
cockroachdb.queue.consistency.processingnanosCockroachdb Queue Consistency ProcessingnanossNanoseconds spent processing replicas in the consistency checker queue.
cockroachdb.queue.consistency.pendingCockroachdb Queue Consistency PendingcountNumber of pending replicas in the consistency checker queue.
cockroachdb.queue.consistency.process.failureCockroachdb Queue Consistency Process FailurecountNumber of replicas which failed processing in the consistency checker queue.
cockroachdb.queue.split.pendingCockroachdb Queue Split PendingcountNumber of pending replicas in the split queue.
cockroachdb.queue.gc.pendingCockroachdb Queue Gc PendingcountNumber of pending replicas in the GC queue.
cockroachdb.queue.gc.processingnanosCockroachdb Queue Gc ProcessingnanoscountNanoseconds spent processing replicas in the GC queue.
cockroachdb.queue.split.processingnanosCockroachdb Queue Split ProcessingnanossNanoseconds spent processing replicas in the split queue.
cockroachdb.queue.replicate.processingnanosCockroachdb Queue Replicate ProcessingnanossNanoseconds spent processing replicas in the replicate queue.
cockroachdb.queue.tsmaintenance.processingnanosCockroachdb Queue Tsmaintenance ProcessingnanossNanoseconds spent processing replicas in the time series maintenance queue.
cockroachdb.queue.split.process.failureCockroachdb Queue Split Process FailurecountNumber of replicas which failed processing in the split queue
cockroachdb.queue.tsmaintenance.process.failureCockroachdb Queue Tsmaintenance Process FailurecountNumber of replicas which failed processing in the time series maintenance queue.
cockroachdb.queue.replicate.pendingCockroachdb Queue Replicate PendingcountNumber 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 NameMetric NameMetric Display NameUnitDescription
CockroachDB Replica Statisticscockroachdb.replicas.leadersCockroachdb Replicas LeaderscountNumber of raft leaders
cockroachdb.replicas.totalCockroachdb Replicas TotalcountNumber of replicas
cockroachdb.replicas.quiescentCockroachdb Replicas QuiescentcountNumber of quiesced replicas
cockroachdb.replicas.leaseholdersCockroachdb Replicas LeaseholderscountNumber of lease holders
cockroachdb.replicas.leaders.not_leaseholdersCockroachdb Replicas Leaders Not LeaseholderscountNumber of replicas that are Raft leaders whose range lease is held by another store
cockroachdb.replicas.reservedCockroachdb Replicas ReservedcountNumber 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 NameMetric NameMetric Display NameUnitDescription
CockroachDB RocksDB Statisticscockroachdb.rocksdb.block.cache.usageCockroachdb Rocksdb Block Cache UsageBytesBytes used by the block cache
cockroachdb.rocksdb.table.readers.mem.estimateCockroachdb Rocksdb Table Readers Mem EstimateBytesMemory used by index and filter blocks
cockroachdb.rocksdb.block.cache.hitsCockroachdb Rocksdb Block Cache HitscountCount of block cache hits
cockroachdb.rocksdb.block.cache.missesCockroachdb Rocksdb Block Cache MissescountCount of block cache misses
cockroachdb.rocksdb.read.amplificationCockroachdb Rocksdb Read AmplificationcountNumber of disk reads per query
cockroachdb.rocksdb.block.cache.pinned.usageCockroachdb Rocksdb Block Cache Pinned UsageBytesBytes 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 NameMetric NameMetric Display NameUnitDescription
CockroachDB SQL Statisticscockroachdb.sql.exec.latencyCockroachdb Sql Exec LatencysLatency in nanoseconds of SQL statement execution.
cockroachdb.sql.distsql.flows.activeCockroachdb Sql Distsql Flows ActivecountNumber of distributed SQL flows currently active.
cockroachdb.sql.mem.internal.session.currentCockroachdb Sql Mem Internal Session CurrentBytesCurrent sql session memory usage for internal.
cockroachdb.sql.distsql.exec.latencyCockroachdb Sql Distsql Exec LatencysLatency in nanoseconds of DistSQL statement execution.
cockroachdb.sql.mem.admin.currentCockroachdb Sql Mem Admin CurrentBytesCurrent sql statement memory usage for admin.
cockroachdb.sql.query.countCockroachdb Sql Query CountcountNumber of SQL queries.
cockroachdb.sql.mem.internal.txn.currentCockroachdb Sql Mem Internal Txn CurrentBytesCurrent sql transaction memory usage for internal.
cockroachdb.sql.mem.internal.currentCockroachdb Sql Mem Internal CurrentBytesCurrent sql statement memory usage for internal.
cockroachdb.sql.connsCockroachdb Sql ConnscountNumber of active sql connections.
cockroachdb.sql.mem.admin.txn.currentCockroachdb Sql Mem Admin Txn CurrentBytesCurrent sql transaction memory usage for admin.
cockroachdb.sql.mem.conns.session.currentCockroachdb Sql Mem Conns Session CurrentBytesCurrent sql session memory usage for conns.
cockroachdb.sql.mem.conns.currentCockroachdb Sql Mem Conns CurrentBytesCurrent sql statement memory usage for conns.
cockroachdb.sql.select.countCockroachdb Sql Select CountcountNumber of SQL SELECT statements.
cockroachdb.sql.mem.admin.session.currentCockroachdb Sql Mem Admin Session CurrentBytesCurrent sql session memory usage for admin.
cockroachdb.sql.distsql.service.latencyCockroachdb Sql Distsql Service LatencysLatency in nanoseconds of DistSQL request execution.
cockroachdb.sql.distsql.queries.activeCockroachdb Sql Distsql Queries ActivecountNumber of distributed SQL queries currently active.
cockroachdb.sql.delete.countCockroachdb Sql Delete CountcountNumber of SQL DELETE statements.
cockroachdb.sql.update.countCockroachdb Sql Update CountcountNumber of SQL UPDATE statements.
cockroachdb.sql.BytessoutCockroachdb Sql BytessoutBytesNumber of sql Bytess sent.
cockroachdb.sql.mem.conns.txn.currentCockroachdb Sql Mem Conns Txn CurrentBytesCurrent sql transaction memory usage for conns.
cockroachdb.sql.insert.countCockroachdb Sql Insert CountcountNumber of SQL INSERT statements.
cockroachdb.sql.mem.distsql.currentCockroachdb Sql Mem Distsql CurrentBytesCurrent sql statement memory usage for distsql.
cockroachdb.sql.BytessinCockroachdb Sql BytessinBytesNumber 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 NameMetric NameMetric Display NameUnitDescription
CockroachDB Liveness Statisticscockroachdb.liveness.livenodesCockroachdb Liveness LivenodescountNumber of live nodes in the cluster (will be 0 if this node is not itself live).
CockroachDB Statisticscockroachdb.livecountCockroachdb LivecountcountCount of live keys.
cockroachdb.capacity.usedCockroachdb Capacity UsedBytesUsed storage capacity.
cockroachdb.capacity.totalCockroachdb Total CapacityBytesTotal storage capacity.
cockroachdb.capacity.availableCockroachdb Capacity AvailableBytesAvailable storage capacity.
cockroachdb.liveBytessCockroachdb LiveBytessBytesNumber of Bytess of live data (keys plus values).
CockroachDB System Statisticscockroachdb.sys.fd.openCockroachdb Sys Fd OpencountProcess open file descriptors.
cockroachdb.sys.cpu.user.percentCockroachdb Sys Cpu User Percent%Current user cpu percentage.
cockroachdb.sys.cpu.user.nsCockroachdb Sys Cpu User NssTotal user cpu time in nanoseconds.
cockroachdb.sys.cgocallsCockroachdb Sys CgocallscountTotal number of cgo calls.
cockroachdb.sys.goroutinesCockroachdb Sys GoroutinescountCurrent number of goroutines.
cockroachdb.syscountCockroachdb SyscountcountCount of system KV pairs.
cockroachdb.sys.uptimeCockroachdb Sys UptimesProcess uptime in seconds.
cockroachdb.sys.cpu.sys.percentCockroachdb 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 NameMetric NameMetric Display NameUnitDescription
CockroachDB Transaction Statisticscockroachdb.txn.commits1PCCockroachdb Txn Commits1PccountNumber of committed one-phase KV transactions.
cockroachdb.txn.durationsCockroachdb Txn DurationssKV transaction durations in nanoseconds.
cockroachdb.txn.commitsCockroachdb Txn CommitscountNumber of committed KV transactions (including 1PC).
cockroachdb.txn.abortsCockroachdb Txn AbortscountNumber of aborted KV transactions.
cockroachdb.txn.autoretriesCockroachdb Txn AutoretriescountNumber of automatic retries to avoid serializable restarts.
cockroachdb.txn.restartsCockroachdb Txn RestartscountNumber of restarted KV transactions.