QueryFlow

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

• GitHub: https://github.com/eyaltrabelsi/query-flow

• PyPI: https://pypi.org/project/query-flow/

• Free software: MIT

Installing

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.