How do I discover consistency level performance?
Before changing the consistency level on read and write operations, discover how your CQL commands are performing using the TRACING command in CQL.
Using cqlsh, you can vary the consistency level and trace read and write operations.
The tracing output includes latency times for the operations.
For more information, see TRACING and Cassandra driver logs.