Don't count zero-filled buffers as 'read' in EXPLAIN.
authorThomas Munro <tmunro@postgresql.org>
Tue, 27 Nov 2018 22:42:32 +0000 (11:42 +1300)
committerThomas Munro <tmunro@postgresql.org>
Tue, 27 Nov 2018 22:58:10 +0000 (11:58 +1300)
commitd67dae036bd71afd2be7a2fafd7bc1ef38bfcdd1
tree51ee94a5a4a611c99ea1bab58223fec2223a6a74
parent471a7af585b123a8c00416eabbec927f6701583d
Don't count zero-filled buffers as 'read' in EXPLAIN.

If you extend a relation, it should count as a block written, not
read (we write a zero-filled block).  If you ask for a zero-filled
buffer, it shouldn't be counted as read or written.

Later we might consider counting zero-filled buffers with a separate
counter, if they become more common due to future work.

Author: Thomas Munro
Reviewed-by: Haribabu Kommi, Kyotaro Horiguchi, David Rowley
Discussion: https://postgr.es/m/CAEepm%3D3JytB3KPpvSwXzkY%2Bdwc5zC8P8Lk7Nedkoci81_0E9rA%40mail.gmail.com
src/backend/storage/buffer/bufmgr.c