Join us

pg_plan_alternatives: Tracing PostgreSQL’s Query Plan Alternatives using eBPF

pg_plan_alternatives: Tracing PostgreSQL’s Query Plan Alternatives using eBPF

The tracer hooks PostgreSQL's optimizer via eBPF. It captures every alternative plan path with cost estimates and flags the chosen plan.

A kernel-space eBPF program reads planner structs using DWARF-derived offsets. A user-space collector gathers the data and a visualizer renders plan graphs.

eBPF probes plus DWARF offsets surface ephemeral plan alternatives. Engineers can see the plans the optimizer considered and rejected. Less or no guessing. That changes how teams inspect optimizer behavior.


Give a Pawfive to this post!


Only registered users can post comments. Please, login or signup.

Start writing about what excites you in tech — connect with developers, grow your voice, and get rewarded.

Join other developers and claim your FAUN.dev() account now!

Avatar

Kaptain #Kubernetes

FAUN.dev()

@kaptain
Kubernetes Weekly Newsletter, Kaptain. Curated Kubernetes news, tutorials, tools and more!
Developer Influence
7

Influence

1

Total Hits

130

Posts