question

jordanp98 avatar image
jordanp98 asked Erick Ramirez answered

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

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

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