Collect performance diagnostic information

[robert-s-lee]

Exalate commented:

Collect crdb_internal.node_statement_statistics from all nodes.

cockroach node status --format tsv --insecure | tail -n +2 | while read id host other; do cockroach sql --format tsv --url postgres://root@$host?sslmode=disable -e "select crdb_internal.cluster_id(), now(),* from crdb_internal.node_statement_statistics;"; done > node_statement_statistics.tsv

Collect Range Usage Info

Download 4 scripts. Additional context on the scripts is available.

curl http://localhost:8080/_status/raft > ranges
python hottest_nodes.py ranges > hottest_nodes.txt
python hottest_ranges.py ranges > hottest_ranges.txt
python tables_per_node.py ranges > tables_per_node.txt

Jira Issue: DOC-184

[robert-s-lee]

node status

cockroach sql --format tsv --url postgres://[email protected]?sslmode=disable -e "select * from crdb_internal.kv_node_status;" > node_status

[jseldess]

We have closed this issue because it is more than 3 years
old. If this issue is still relevant, please add a comment and re-open
the issue. Thank you for your contribution to CockroachDB docs!