This page documents an earlier version of InfluxDB.
InfluxDB v2.4 is the latest stable version.
Covers InfluxDB error messages, their descriptions, and common resolutions.
This page addresses frequent sources of confusion and places where InfluxDB behaves in an unexpected way relative to other database systems. Where applicable, it links to outstanding issues on GitHub.
How do I include a single quote in a password? How can I identify my version of InfluxDB? Where can I find InfluxDB logs? What is the relationship between shard group durations and retention policies? Why aren’t data dropped after I’ve altered a retention policy?
With InfluxDB’s query management features, users are able to identify currently-running queries, kill queries that are overloading their system, and prevent and halt the execution of inefficient queries with several configuration settings.
SHOW QUERIES KILL QUERY Configuration Settings List currently-running queries with SHOW QUERIES SHOW QUERIES lists the query id, query text, relevant database, and duration of all currently-running queries on your InfluxDB instance.
Syntax: SHOW QUERIES Example: > SHOW QUERIES qid query database duration 37 SHOW QUERIES 100368u 36 SELECT mean(myfield) FROM mymeas mydb 3s Explanation of the output: qid The id number of the query.
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community!
We welcome and encourage your feedback and bug reports for InfluxDB and this documentation.
To find support, use the following resources:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.