dalibo / pev2

Postgres Explain Visualizer 2
https://explain.dalibo.com
PostgreSQL License
2.62k stars 128 forks source link

Filters are not visible enough #293

Closed Krysztophe closed 3 years ago

Krysztophe commented 4 years ago

When looking at https://explain.dalibo.com/plan/8UD, you do NOT see quickly than 2 seq scans are filtered, or that the hash join at the top if filtered too. This information is hidden in the Misc tab.

This is very important as filters are the 1st criterion to choose how to begin a plan.

Suggestions :

pgiraud commented 3 years ago

I've just push commits that fix this issue. I've taken your first suggestion into account. This means that when there are rows removed by the filter a grey funnel icon appears. In cases where the execution time of the node is also significant, the funnel icon appears with a color as before.

The hovering tooltip now tells the user the percentage of rows removed.

Krysztophe commented 2 years ago

Nice ! :+1: (Yes, I 'm a bit late)