Which range which nodes?

Hi Team,

Could you please guide me on how to find the RANGE and replicas?

1 How to find leaseholders for ranges?
2 which range which nodes?
3 How to listed per single node ranges.

Total Replicas Raft Leaders Total Ranges
node1 479 158 218
node2 479 166 123
node3 479 155 138
479 479


Hi Raj,

You can run “SHOW RANGES FROM DATABASE <db_name>;”. It will show you which nodes each range is on and which one is the leaseholder.


1 Like

Hi Jim,

Thanks for the reply and also we got the result from > select * from crdb_internal.ranges order by database_name;