Hi Fujii-san,
On Fri, Apr 03, 2020 at 02:28:27AM +0000, Fujii Masao wrote:
> Include information on buffer usage during planning phase, in EXPLAIN output.
>
> When BUFFERS option is enabled, EXPLAIN command includes the information
> on buffer usage during each plan node, in its output. In addition to that,
> this commit makes EXPLAIN command include also the information on
> buffer usage during planning phase, in its output. This feature makes it
> easier to discern the cases where lots of buffer access happen during
> planning.
prion did not like that:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=prion&dt=2020-04-03%2002%3A33%3A13
Here is the diff from test explain:
@@ -73,8 +73,9 @@
Seq Scan on int8_tbl i8 (cost=N.N..N.N rows=N width=N) (actual time=N.N..N.N rows=N loops=N)
Buffers: shared [read]
Planning Time: N.N ms
+ Buffers: shared [read]
Execution Time: N.N ms
-(4 rows)
+(5 rows)
Note that this animal uses -DRELCACHE_FORCE_RELEASE and
-DCATCACHE_FORCE_RELEASE.
--
Michael