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:

  1. To implement an external module that monitors the state of the running queries.
  2. 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.

Figure 1:

The development of this framework has just begun.

Try this if you are interested.