chriscasano
chriscasano
I started writing out some of the queries for this. Not sure if we want to automate with SQL or REST API but here's a start. -- Node Status (should...
Here's an update on the under replicated ranges query from here: https://github.com/cockroachdb/cockroach/issues/51304 SELECT sum((metrics->>'ranges.underreplicated')::DECIMAL)::INT8 AS ranges_underreplicated FROM crdb_internal.kv_store_status JOIN crdb_internal.gossip_liveness USING (node_id) WHERE NOT decommissioning;