---
title: Troubleshoot and optimize queries
description: Troubleshoot errors and optimize performance for SQL and InfluxQL queries in InfluxDB. Use observability tools to view query execution and metrics.
url: https://docs.influxdata.com/influxdb3/cloud-dedicated/query-data/troubleshoot-and-optimize/
estimated_tokens: 659
product: InfluxDB Cloud Dedicated
version: cloud-dedicated
---

# Troubleshoot and optimize queries

Troubleshoot errors and optimize performance for SQL and InfluxQL queries in InfluxDB Cloud Dedicated. Use observability tools to view query execution and metrics.

### [Optimize queries](/influxdb3/cloud-dedicated/query-data/troubleshoot-and-optimize/optimize-queries/)

Optimize queries to improve performance and reduce their memory and compute (CPU) requirements in InfluxDB. Learn how to use observability tools to analyze query execution and view metrics.

### [Troubleshoot queries](/influxdb3/cloud-dedicated/query-data/troubleshoot-and-optimize/troubleshoot/)

Troubleshoot SQL and InfluxQL queries in InfluxDB.

### [Query timeout best practices](/influxdb3/cloud-dedicated/query-data/troubleshoot-and-optimize/query-timeout-best-practices/)

Learn how to set appropriate query timeouts to balance performance and resource protection.

### [View the query log](/influxdb3/cloud-dedicated/query-data/troubleshoot-and-optimize/query-log/)

View and analyze queries executed on your cluster using the Admin UI Query History or by querying the \_internal database with influxctl.

### [Analyze a query plan](/influxdb3/cloud-dedicated/query-data/troubleshoot-and-optimize/analyze-query-plan/)

Learn how to read and analyze a query plan to understand how a query is executed and find performance bottlenecks.

### [Retrieve system information for a query](/influxdb3/cloud-dedicated/query-data/troubleshoot-and-optimize/system-information/)

Learn how to use the system.queries debug feature to retrieve system information for a query in InfluxDB Cloud Dedicated.

### [Understand and troubleshoot Flight responses](/influxdb3/cloud-dedicated/query-data/troubleshoot-and-optimize/flight-responses/)

Understand responses and troubleshoot errors encountered when querying InfluxDB with Flight+gRPC and Arrow Flight clients.

#### Related

-   [Query data with SQL](/influxdb3/cloud-dedicated/query-data/sql/)
-   [Query data with InfluxQL](/influxdb3/cloud-dedicated/query-data/influxql/)