QueryFlow, is a query visualization tool that provides insights into common problems in your SQL query. QueryFlow visualizes the query execution using the Sankey diagram, a technique that allows one to illustrate complex processes, with a focus on a single aspect or resource that you want to highlight. This allow to tackle the following problems:
- Identifying missing records.
- Identifying Ineffective operations.
- Identifying duplications in a query.
- Comparing optimizer planned metrics to actual metrics.
- Identifying performance bottlenecks in a single query.
- Identifying performance bottlenecks in multiple queries.
Currently QueryFlow support the following databases/data-engines:
-
Athena
-
PostgreSQL
-
Documentation: https://eyaltrabelsi.github.io/query-flow
-
Free software: MIT
The best way to install query-flow is:
$ pip install query-flow
In case you want to use another way go to the installation page.