Uploaded image for project: 'DataStax Java Driver for Apache Cassandra'
  1. DataStax Java Driver for Apache Cassandra
  2. JAVA-646

Slow Query Logger

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.10
    • Component/s: None
    • Labels:

      Description

      It would be great if there was a way to log if a Cassandra query takes longer then a configured length of time.

      E.g.

      if (timeTakenMs >= slowQueryThresholdMs) {
   LOGGER.warn("Query took longer than configured threshold. Query: {}, time taken ms: {}, threshold ms: {}", query, timeTakenMs, slowQueryThresholdMs);
} else {
   LOGGER.debug("Query executed. Query: {}, time taken ms: {}", query, timeTakenMs);
}

      The problem with doing this outside of the driver is that it may include any retries or connections.

        Attachments

          Issue links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. JAVA-115 BoundStatement.toString() should include the parameters along with the PS String

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

            Activity

              People

              • Assignee:
                alexandre.dutra Alexandre Dutra
                Reporter:
                barmybuckle Adam Dougal
              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: