Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
Дата
Msg-id CAKAnmm+QQP-dTkjsDVbEcphrdXqCTq-ALTCMUwPaYWZmqUp=NQ@mail.gmail.com
обсуждение исходный текст
Ответ на Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE  (Nikolay Samokhvalov <samokhvalov@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
On Wed, Nov 20, 2024 at 1:26 AM Guillaume Lelarge <guillaume@lelarge.info> wrote:
OK, but I'm not sure which example I should pick to add dirtied and written shared buffers. It looks kinda artificial. Should I choose one randomly?

It will be artificial, but I think that's ok: anyone running it on their own will be getting different numbers anyway. I was looking at the "14.1.2 EXPLAIN ANALYZE" section in perform.sgml. Here's some actual numbers I got with some playing around with concurrent updates:

         Recheck Cond: (unique1 < 10)
         Heap Blocks: exact=5
         Buffers: shared hit=2 read=5 written=4
...
 Planning:
   Buffers: shared hit=289 dirtied=9

Cheers,
Greg

В списке pgsql-hackers по дате отправления: