pg_flame: Flamegraph Generator for PostgreSQL Query Plans
pg_flame is a powerful tool designed to convert PostgreSQL `EXPLAIN ANALYZE` output into interactive flamegraphs, enabling developers and database administrators to visualize and analyze query performance. By providing a clear visual hierarchy of execution plans, pg_flame helps identify bottlenecks and optimize database queries effectively.
Features
Generates flamegraphs from PostgreSQL `EXPLAIN ANALYZE` JSON output.
Supports multiple installation methods including Homebrew, pre-compiled binaries, Docker, and source compilation.
Allows piping of query plan JSON for streamlined input and output operations.
Visualizes CPU consumption and execution time for each part of a query plan.
Enhances debugging of slow database queries with intuitive graphical representation.