CODEWITHSUNDEEP
monitoringinfluxdb
Stanko
Stanko

Reputation: 4475

Monitor resource usage of query in InfluxDB

I'm running a lot of queries in InfluxDB and I'm trying to diagnose which query or queries are the most resource intensive. I know I can use SHOW STATS or SHOW DIAGNOSTICS but that doesn't show any information for specific queries. How can I get more detailed information?

Upvotes: 1

Views: 106

Answers (1)

Steephen
Steephen

Reputation: 15824

You have multiple ways to attain the details of specific queries.

  • Explain: Parses and plans the query, and then prints a summary of estimated costs. More details are available.

  • Explain analyze: Executes the query and counts the actual costs during runtime.

As you mentioned in your question to monitor overall performance, other than SHOW STATS AND SHOW DAIGONOSTICS you can depend on _inernal database also. See here for more details.

Upvotes: 1

Related Questions