Waiting for Postgres 16: Running EXPLAIN on any query (even with $1 parameters!)

In episode 65 of “5mins of Postgres” we're talking about explaining generic plans in Postgres 16. We're looking at generic plans vs. custom plans, the benefits of generic plans and the limitations of EXPLAIN (GENERIC_PLAN).

*Learn more about pganalyze:*

*Check out the pganalyze library for eBooks, webinars, and more:*

📑 *What we have discussed in this episode of 5mins of Postgres:*

*EXPLAIN (GENERIC_PLAN): New in PostgreSQL 16*

*Invent GENERIC_PLAN option for EXPLAIN*

*EXPLAIN that parameterized statement in PostgreSQL!*

*Waiting for Postgres 16: Buffer cache hit ratio and I/O times in pg_stat_io*

*Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io*

*Vacuum Cost Limit and Parallel Aggregate improvements in Postgres 16*

*Postgres 16: Surviving without a superuser & reserved_connections*

*Using pgbench to load data faster, and the random_normal function in PG16*

*5mins of Postgres E35: How to run EXPLAIN on normalized queries from pg_stat_statements using plan_cache_mode*

*5mins of Postgres E34: Making the most of Parallel VACUUM and why SQL/JSON was pushed out to Postgres 16*

*5mins of Postgres E27: Waiting for Postgres 16 - Make subquery alias optional in FROM clause*

*pganalyze eBook: Finding the root cause of slow Postgres queries using EXPLAIN*