search

AlexTatiyants / pev

Postgres Explain Visualizer
MIT License
2.77k stars 192 forks source link

"Never executed" plan nodes #49

Open md5 opened 5 years ago

md5 commented 5 years ago

When Postgres decides not to execute a portion of a query plan, the textual query plan will say "never executed" and the "Actual Loops" count will be zero in the JSON output. Would it be possible to visually indicate these nodes in PEV?

My first instinct would be to have these nodes displayed as partially transparent, but maybe a "never executed" badge/label or a different visual treatment would work better.

pgiraud commented 5 years ago

@md5 As mentioned in a different issue here, I recently worked on a fork of PEV (due to its inactivity). See https://github.com/dalibo/pev2

Never executed node are highlighted. Try "Example 1" in sample plans.