Обсуждение: Run-time partition pruning and EXPLAIN [ANALYZE]

Поиск
Список
Период
Сортировка

Run-time partition pruning and EXPLAIN [ANALYZE]

От
Bruce Momjian
Дата:
I attended a Postgres 11 feature talk by Daniel Westermann at the Swiss
PGDay about the features in Postgres 11.  He showed that EXPLAIN does
not show run-time partition pruning, only EXPLAIN ANALYZE does;  see
slides 32-34 at 
https://www.pgday.ch/common/slides/2018_westermann_WhatWeAlreadyKnowAboutPostgreSQL11.pdf.

I might be obvious once you see it, but it wasn't obvious to me before
this.  I don't see this documented.  I think we should.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +