Re: EXPLAIN BUFFERS and I/O timing accounting questions

From: Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: EXPLAIN BUFFERS and I/O timing accounting questions
Date: 2019-10-23 16:13:08
Message-ID: CAOtHd0DT5f49WnvDABH19Zk+K8Xbiv2zKjmh+23t=+7gROniwQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Geoff Winkless 2019-10-23 16:20:07 Re: Is this a bug ?
Previous Message David G. Johnston 2019-10-23 16:11:54 Re: Lookup Primary Key of Foreign Server's Table

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2019-10-23 16:38:49 WIP: expression evaluation improvements
Previous Message David G. Johnston 2019-10-23 16:06:33 Re: jsonb_set() strictness considered harmful to data