I’ve just released pg_plan_inspector that is a framework to monitor and improve the performance of PostgreSQL using Machine Learning methods.
One movie is worth a thousand words. Watch this movie.
The movie demonstrates that a tool provided by this framework shows the progress of a running query.
This is a POC model, and the primary purposes of this framework are:
- To implement an external module that monitors the state of the running queries.
- To show that the PostgreSQL optimizer can be improved from providing feedback on the analysis of the executed plans.
To achieve these purposes, I am currently developing two modules: pg_query_plan and plan_analyzer.
The development of this framework has just begun.
Try this if you are interested.