# Query Plan Analyzer

> The Query Plan Analyzer (QPA) is a troubleshooting tool that helps data administrators to better understand the SQL query and to identify M2M relationships within the query.

*Source: https://docs.sisense.com/main/SisenseLinux/qpa-overview.htm*

---

Last updated: June 11, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

Examining SQL can be difficult and requires considerable time and effort to extract crucial information, especially when identifying [Many-to-Many (M2M)](https://docs.sisense.com/main/SisenseLinux/data-model-building-practices.md#TableRelationships) relationships within the SQL. The SQL's [logical plan](https://drill.apache.org/docs/query-plans/#:~:text=A logical plan is a,to create the logical plan.) separates the query into entities such as SELECT, INNER JOIN, FILTER, and AGGREGATE, aiding in comprehending the SQL structure and identifying M2M associations. The Query Plan Analyzer (QPA) is a troubleshooting tool that helps data administrators to better understand the SQL query and to identify M2M relationships within the query. Both Live and ElastiCube models are supported by the QPA. The QPA returns a graph such as the following, which represents the logical plan of the query.

![QPA graph](https://docs.sisense.com/main/Resources/Images/QPA-graph2.png)