BFM4Patroni SQL Tuning Wizard Feature

SQL tuning (also called query optimization) is critically important in any database system — especially in large-scale or high-throughput environments. If sql queries is not well tuned, you can end up performance problems even your database could not perform activities.

SQL tuning also requires complex knowledge of sql , extracting , analyzing execution plan, and doing recommendations.

BFM4Patroni SQL Tuning Wizard is the killing feature that extracts execution plans, analyzes them and advises missing indexes. Also it shows a new execution plan if you create an index with the current sql execution plan. Index creation takes time and load on the database. BFM4Patroni uses hypopg extension which is used for hypothetical index. With Hypothetical index you do not need to create index to see if I create index what will be new plan. And one good thing is that SQL Tuning Wizard also creates index creation ddl script for you. You can create it by yourself, or you can use BFM4Patroni to create index for you.

You can call SQL Tuning Wizard on the Performance Insights or Active Sessions page of BFM4Patroni.

In the below you find a bad sql query running real time in Active Sessions page. Then you can easily call sql tuning wizard in real time by just one clik.

SQL Tuning Wizard Output on Active Session Browser Page

Also you can create advised index with one click like below.

Index Create option for SQL Tuning Wizard