Troubleshoot queries

Troubleshoot SQL and InfluxQL queries that return unexpected results.

• Why doesn’t my query return data?
• Optimize slow or expensive queries

Why doesn’t my query return data?

If a query doesn’t return any data, it might be due to the following:

• Your data falls outside the time range (or other conditions) in the query–for example, the InfluxQL SHOW TAG VALUES command uses a default time range of 1 day.
• The query (InfluxDB server) timed out.
• The query client timed out.

If a query times out or returns an error, it might be due to the following:

• a bad request
• a server or network problem
• it queries too much data

Understand Arrow Flight responses and error messages for queries.

Optimize slow or expensive queries

If a query is slow or uses too many compute resources, limit the amount of data that it queries.

See how to optimize queries and use tools to view runtime metrics, identify bottlenecks, and debug queries.