Search Postgresql Archives

Re: EXPLAIN BUFFERS and I/O timing accounting questions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: EXPLAIN BUFFERS and I/O timing accounting questions
From: Maciek Sakrejda <m.sakrejda@xxxxxxxxx>
Date: Wed, 23 Oct 2019 09:13:08 -0700
In-reply-to: <CAOtHd0AjLpmE1gZ35czZcGVyoje5vg+OTSRuvnL6TT7tT_BzwA@mail.gmail.com>
References: <CAOtHd0AjLpmE1gZ35czZcGVyoje5vg+OTSRuvnL6TT7tT_BzwA@mail.gmail.com>

Also, I noticed that in this plan, the root (again, an Aggregate) has 0 Temp Read Blocks, but two of its children (two of the ModifyTable nodes) have non-zero Temp Read Blocks. Again, this contradicts the documentation, as these costs are stated to be cumulative. Any ideas?

Thanks,

Maciek

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- EXPLAIN BUFFERS and I/O timing accounting questions
  - From: Maciek Sakrejda

Prev by Date: Re: Lookup Primary Key of Foreign Server's Table
Next by Date: Re: Is this a bug ?
Previous by thread: EXPLAIN BUFFERS and I/O timing accounting questions
Next by thread: Re: EXPLAIN BUFFERS and I/O timing accounting questions
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux