News for hackers. Stuff that matters.

A comment on Show HN: pg_flame – flamegraph visualizations of PostgreSQL query plans. Parent comment

Re:Show HN: pg_flame – flamegraph visualizations of PostgreS... by hans_castorp on Monday October 28, 2019 @03:04AM (#21374868)
I never understood the obsession with the graphical display of execution plans (neither in Postgres nor in Oracle).

I find the text output much more useful and detailed then any graphical display. Especially when generated with "explain (analyze, buffers, timing) ..." and "track_io_timing" turned on.

[ Parent | on HN ]
Re:Show HN: pg_flame – flamegraph visualizations of PostgreS... by ldng on Monday October 28, 2019 @03:59AM (#21375067)
Well different mind work differently. Some are more receptive to visuals. I don't understand why some people refuse to acknowledge that.
[ Parent | on HN ]
Re:Show HN: pg_flame – flamegraph visualizations of PostgreS... by mgartner on Monday October 28, 2019 @11:28AM (#21377811)
I think the text display is great too! I built pg_flame mostly to help understand the relative timing of each step. Your brain can compare the size of each bar in a flamegraph virtually instantly, while comparing a bunch of actual time numbers scattered throughout the text output takes some time.

tldr; use both as needed

[ Parent | on HN ]