HN Hall of Fame Weekly email

Pev: Postgres ‘Explain’ Visualizer (2016)

Screenshot of tatiyants.com captured 2026-07-20
Page preview · captured 2026-07-20

Resurfaced independently across 3 calendar years, with breakout response in 2 of them.

submissions
5
submitters
4
observed span
2016–2023
peak thread · 48 comments
612 pts
latest 20+ return · 2017-07-23
612 pts

Submission timeline

2007–2026

One slot for every year since HN launched. Height is that year's peak points; orange marks a 100+ point or 50+ comment breakout. Select a bar to open its strongest thread.

First comments on top threads

HN comment order

I needed a version that ran on the command line so I made one here: https://github.com/simon-engledew/gocmdpev

Wow, wonderful work! As an additional information about already existing execution plan visualisation tools: Depesz has written the classical PostgreSQL Execution Plan Visualiser years ago. http://explain.depesz.com/ Of cause it is not so nicely pretty as the one from Tatiyants, but I use it now and then and it became a standard explain visualisation tool for many PostgreSQL users. The table format from http://explain.depesz.com/ is very useful and one can understand a lot of details about your execution plan…

valgog·251-point thread·

The first top-level comment from each of the four biggest threads, in HN’s own order. Excerpts are shortened; open a comment for full context.

Breakout years
2

100+ points or 50+ comments

Total points
878

reference only — not used in Hall rules or ranking

Total comments
64

reference only — not used in Hall rules or ranking

Every submission

DateTitle as submittedByPointsComments
2016-01-19Postgres Query Plan Visualizationatatiyan10
2016-01-23Postgres Query Plan VisualizationFirst breakoutareski25116
2017-07-12Pev: Postgres ‘Explain’ Visualizerinsulanian50
2017-07-23Pev: Postgres ‘Explain’ Visualizer (2016)Best thread · Latest 20+ point returninsulanian61248
2023-05-17Postgres query plan visualisation (2016)OJFord90