QueryAnalyzer is a GUI that is used to analyze your query in graph format. It is basically used to understand what is going on in the backend when you run a postgresql query. This helps us to get a better understanding of whether the query is optimized or not.
Requirements for this GUI are:
- You should have a PostgreSQL database.
- You should have Python 3.6+ version installed.
Steps to use the GUI:
- Fill in the data: hostname, username, database, and password for connection.
- Write your query in the query input box. If your query is correct syntax-wise, and the table/columns names are appropriate and present in your database, this will generate a graph about all the scans/execution/buckets/execution time/planning time.
- The graph is developed with the help of NetworkX and Matplotlib.pyplot with GUI interface Tkinter.
To see the implementation video, click on the following link: Video Link
To download the GUI app, click on the following link: Google Drive or use DownGit to download QueryAnalyzer.exe from the dist folder of this GitHub repo.