Getting the count of Cassandra table records
Extract the estimated number of records in a Cassandra cluster to verify that the data model is correct, or to troubleshoot slow response times.
To obtain the estimated number of records, in the nodetool utility, run the
nodetool cfstatscommand.Using theFor more information, see the Apache Cassandra documentation.
select count(*)command often produces a timeout exception when trying to extract a table record count.
- Pega alerts for Cassandra
Determine the causes of performance issues in your application and learn how to resolve them by analyzing Cassandra-related alert messages.
- Troubleshooting Cassandra
Identify the root cause of degraded performance by completing corresponding monitoring activities. Learn about the most commonly encountered Cassandra issues and how to address them.