Jan Kristof Nidzwetzki: pg_plan_alternatives: Tracing PostgreSQL’s Query Plan Alternatives using eBPF

Jan Kristof Nidzwetzki: pg_plan_alternatives: Tracing PostgreSQL’s Query Plan Alternatives using eBPF

PostgreSQL uses a cost-based optimizer (CBO) to determine the best execution plan for a given query. The optimizer considers multiple alternative plans during the planning phase. Using the EXPLAIN command, a user can only inspect the chosen plan, but not the …

PostgreSQL uses a cost-based optimizer (CBO) to determine the best execution plan for a given query. The optimizer considers multiple alternative plans during the planning phase. Using the EXPLAIN co… [+21923 chars]