Postgres new extension party: pg_stat_plans

Lukas from pganalyze has been working on a new extension called pg_stat_plans to capture plan statistics inside Postgres. Similar to how pg_stat_statements tracks queries, the new extension goes one level deeper and tracks query plan use over time. The extension builds on new Postgres 18 features to allow low-overhead capturing of these statistics for all queries executed on a database, in a way that existing extensions weren't able to do. Lukas is going to talk about pg_stat_plans, how it works, how it compares to auto_explain, and what you can get from monitoring query plans over time.