How do I discover consistency level performance?

Before changing the consistency level on read and write operations, discover how your CQL statements are performing using the cqlsh TRACING command. Using cqlsh, you can vary the consistency level and trace read and write operations. The tracing output includes latency times for the operations.

The CQL documentation includes an example comparing consistency levels.