dalibo / explain.dalibo.com

PEV2 Flask service. Visualizing and understanding PostgreSQL EXPLAIN plans made easy.
PostgreSQL License
40 stars 15 forks source link

Plan optimizations #5

Open pgiraud opened 2 years ago

pgiraud commented 2 years ago

Inspired from Despesz

It would be nice to offer the users the ability to link plans. A "add optimization" could be added to let users add a new plan linked to a first one.

The idea would be to add a "add optimization" on the interface. Then a new form would be created with a hidden input referencing the id of the previous plan. In the database, there would be a new "optimization_for" column.

In the future PEV2 could even show the difference graphically. See https://github.com/dalibo/pev2/issues/377