Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

jordanp98 avatar image
jordanp98 asked ·

Is it possible to extract slow queries report from OpsCenter ?

Team, I am able to get details of slow queries from opscenter but i want to extract report in csv format or i want to share report over the email so that i can get data without login into opscenter ui. But i didnt find any way for doing the same could you please guide how can i do the same

opscenterslow query logging
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

It's not possible to do it from OpsCenter but you an export them directly from the CQL table dse_perf.node_slow_log as documented in Collecting slow queries.

Depending on how much data is in the table, you might need to use the DSBulk's unload command to export the data out.

If you need assistance or have follow up questions, please log a ticket with DataStax Support. Cheers!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.