Скачать с ютуб Waiting for Postgres 17: Improved EXPLAIN for SubPlan nodes в хорошем качестве

Waiting for Postgres 17: Improved EXPLAIN for SubPlan nodes

Find the article on our blog here: https://pganalyze.com/blog/5mins-post... In E108 of "5mins of Postgres" we discuss a recently committed change to the Postgres 17 development branch that improves how EXPLAIN represents SubPlan and InitPlan nodes. We compare the output with 16, and discuss the background of how a subplan can result from a sub-SELECT, and when it results in a regular JOIN instead. 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: Improve EXPLAIN's display of SubPlan nodes and output parameters - Postgres commit by Tom Lane https://git.postgresql.org/gitweb/?p=... Using EXPLAIN - Postgres documentation for Postgres 17 development branch https://www.postgresql.org/docs/devel... Regression test setup - Postgres source code https://github.com/postgres/postgres/... Regression test "onek" table data - Postgres source code https://github.com/postgres/postgres/... Regression test "tenk" table data - Postgres source code https://github.com/postgres/postgres/...