Home > mailing lists

Re: EXPLAIN BUFFERS and I/O timing accounting questions - Mailing list pgsql-general

From	Maciek Sakrejda
Subject	Re: EXPLAIN BUFFERS and I/O timing accounting questions
Date	October 23, 2019 19:13:08
Msg-id	CAOtHd0DT5f49WnvDABH19Zk+K8Xbiv2zKjmh+23t=+7gROniwQ@mail.gmail.com Whole thread Raw
In response to	EXPLAIN BUFFERS and I/O timing accounting questions (Maciek Sakrejda <m.sakrejda@gmail.com>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: "David G. Johnston"
Date: 23 October 2019, 19:11:54
Subject: Re: Lookup Primary Key of Foreign Server's Table

From: Geoff Winkless
Date: 23 October 2019, 19:20:07
Subject: Re: Is this a bug ?

Re: EXPLAIN BUFFERS and I/O timing accounting questions - Mailing list pgsql-general

Previous

Next