Waiting for Postgres 16: Running EXPLAIN on any query (even with $1 parameters!)
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
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:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
EXPLAIN (GENERIC_PLAN): New in PostgreSQL 16
https://www.cybertec-postgresql.com/e...
Invent GENERIC_PLAN option for EXPLAIN
https://git.postgresql.org/gitweb/?p=...
EXPLAIN that parameterized statement in PostgreSQL!
https://www.cybertec-postgresql.com/e...
Waiting for Postgres 16: Buffer cache hit ratio and I/O times in pg_stat_io
https://pganalyze.com/blog/5mins-post...
Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io
https://pganalyze.com/blog/pg-stat-io
Vacuum Cost Limit and Parallel Aggregate improvements in Postgres 16
https://pganalyze.com/blog/5mins-post...
Postgres 16: Surviving without a superuser & reserved_connections
https://pganalyze.com/blog/5mins-post...
Using pgbench to load data faster, and the random_normal function in PG16
https://pganalyze.com/blog/5mins-post...
5mins of Postgres E35: How to run EXPLAIN on normalized queries from pg_stat_statements using plan_cache_mode
https://pganalyze.com/blog/5mins-post...
5mins of Postgres E34: Making the most of Parallel VACUUM and why SQL/JSON was pushed out to Postgres 16
https://pganalyze.com/blog/5mins-post...
5mins of Postgres E27: Waiting for Postgres 16 - Make subquery alias optional in FROM clause
https://pganalyze.com/blog/5mins-post...
pganalyze eBook: Finding the root cause of slow Postgres queries using EXPLAIN
https://pganalyze.com/ebooks/explain-...