CPU utilization 92% on only 1 node out of 3 nodes.

We are facing high CPU utilization > 90% on only 1 node out of 3 nodes. When we see ranges on feed table, We see all the lease_holder values showing node 2 only.

root@10.10.10.11> show ranges from table feed_table;
start_key | end_key | range_id | range_size_mb | lease_holder | lease_holder_locality | replicas | replica_localities
------------±--------±---------±--------------±-------------±----------------------±---------±--------------------
NULL | /31233 | 120 | 9.027797 | 2 | | {2,3,5} | {"","",""}
/31233 | /32459 | 2552 | 0.353437 | 2 | | {2,3,5} | {"","",""}
/32459 | /36448 | 2553 | 0.854735 | 2 | | {2,3,5} | {"","",""}
/36448 | /45524 | 2542 | 2.061251 | 2 | | {2,3,5} | {"","",""}
/45524 | /46464 | 2561 | 0.220324 | 2 | | {2,3,5} | {"","",""}
/46464 | /50308 | 2559 | 0.831816 | 2 | | {2,3,5} | {"","",""}
/50308 | /52884 | 2563 | 0.567012 | 2 | | {2,3,5} | {"","",""}
/52884 | /53354 | 2588 | 0.115755 | 2 | | {2,3,5} | {"","",""}
/53354 | /55505 | 2554 | 0.510124 | 2 | | {2,3,5} | {"","",""}
/55505 | /56762 | 2589 | 0.725592 | 2 | | {2,3,5} | {"","",""}
/56762 | /56973 | 2565 | 0.039846 | 2 | | {2,3,5} | {"","",""}
/56973 | /58700 | 2546 | 0.326137 | 2 | | {2,3,5} | {"","",""}
/58700 | /60166 | 2536 | 0.276885 | 2 | | {2,3,5} | {"","",""}
/60166 | /60895 | 2482 | 0.137679 | 5 | | {2,3,5} | {"","",""}
/60895 | /79357 | 2433 | 10.262563 | 5 | | {2,3,5} | {"","",""}
/79357 | /95099 | 2525 | 10.748949 | 5 | | {2,3,5} | {"","",""}
/95099 | /129935 | 1188 | 20.860712 | 2 | | {2,3,5} | {"","",""}
/129935 | /150022 | 1190 | 17.0866 | 2 | | {2,3,5} | {"","",""}
/150022 | /174746 | 1192 | 19.269669 | 2 | | {2,3,5} | {"","",""}
/174746 | /219044 | 2413 | 23.301776 | 5 | | {2,3,5} | {"","",""}
/219044 | NULL | 2468 | 6.180811 | 2 | | {2,3,5} | {"","",""}

Can you please guide us on priority?

thanks

My guess is that you’re using a sequential primary key. Have a look at Scaling CockroachDB key generation… uuid, serial, and sequences – Glenn Fawcett's Database blog or Choosing Index Keys for CockroachDB.