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.