CockroachDB

v0.1.2

Investigate a CockroachDB cluster over the `cockroach` CLI — node liveness / store capacity, under-replicated & unavailable ranges, running queries / sessions / transactions, contention & locks, jobs, statement statistics, table sizes, and cluster settings — plus a few gated operators (cancel a query / session / job, pause / resume a job, decommission / recommission a node). Reads are SQL against crdb_internal / SHOW statements; mutators use SQL or `cockroach node`.

23 allowed by default 2 need approval 1 denied by default

Pack ID

cockroach

Vendor

emisar

linux

Actions

Required binaries. Install these on the host before relying on the pack — an action that calls a missing one fails at run time.


              cockroach

Install

emisar pack install validates the pack and verifies its content hash before copying it into /etc/emisar/packs. The --hash below pins the install to the exact bytes on this page — a tampered copy is rejected. After install, reload the runner; it re-reads the catalog and advertises every action.

content hash: sha256:3e35471ca174a81481cf72251d04e60a8dc2006415d5413198d3d811dcce1959

on the runner host

sudo emisar pack install cockroach \
  --hash sha256:3e35471ca174a81481cf72251d04e60a8dc2006415d5413198d3d811dcce1959 \
  --dest /etc/emisar/packs

# Reload so the runner re-reads the catalog:
sudo systemctl reload emisar

Actions 26 total

View on GitHub

cockroach.cancel_job exec medium

Cancel a job (CANCEL JOB)
cockroach.cancel_query exec medium

Cancel a running query (CANCEL QUERY)
cockroach.cancel_session exec medium

Cancel a session (CANCEL SESSION)
cockroach.cluster_queries exec low

Show running queries cluster-wide
cockroach.cluster_sessions exec low

Show open sessions cluster-wide
cockroach.cluster_settings exec low

Show cluster settings
cockroach.cluster_transactions exec low

Show open transactions cluster-wide
cockroach.contention_events exec low

Show who is blocking whom (contention events)
cockroach.contention_leaderboard exec low

Show most-contended objects
cockroach.databases exec low

List databases (SHOW DATABASES)
cockroach.jobs exec low

Show recent / running jobs
cockroach.locks exec low

Show contended locks (lock table)
cockroach.node_decommission exec high

Decommission a node (cockroach node decommission)
cockroach.node_liveness exec low

Show node liveness / draining / decommissioning
cockroach.node_recommission exec high

Recommission a node (cockroach node recommission)
cockroach.node_status exec low

Show node status (liveness, ranges, decommission, disk)
cockroach.node_status_one exec low

Show status for one node
cockroach.pause_job exec medium

Pause a job (PAUSE JOB)
cockroach.replication_constraints exec low

Show replication constraint violations
cockroach.replication_stats exec low

Show under-replicated / unavailable range counts
cockroach.resume_job exec medium

Resume a paused job (RESUME JOB)
cockroach.set_cluster_setting exec critical

Set a cluster setting (SET CLUSTER SETTING)
cockroach.statement_stats exec low

Show top statement fingerprints by exec count
cockroach.store_status exec low

Show per-store disk capacity / range counts
cockroach.table_ranges exec low

Show range count + size for one table
cockroach.table_row_counts exec low

Show estimated row counts per table

← Back to registry

Pack reference Publish your own →