pg_flame

A flamegraph generator for Postgres EXPLAIN ANALYZE output. The pg_flame program reads a JSON query plan from standard input and writes the flamegraph HTML to standard output. Therefore you can pipe and direct input and output however you desire. Flamegraphs were invented by Brendan Gregg to visualize CPU consumption per code-path of profiled software. They are useful visualization tools in many types of performance investigations. Flamegraphs have been used to visualize Oracle database query plans and query executions, proving useful for debugging slow database queries. Pg_flame is an extension of that work for Postgres query plans. It generates a visual hierarchy of query plans. This visualization identifies the relative time of each part of a query plan.