agora inbox for pgsql-committers@postgresql.org  
help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add EXPLAIN (IO) instrumentation for SeqScan
Date: Tue, 07 Apr 2026 21:07:37 +0000
Message-ID: <E1wADe4-003S8t-3C@gemulon.postgresql.org> (raw)

Add EXPLAIN (IO) instrumentation for SeqScan

Adds support for EXPLAIN (IO) instrumentation for sequential scans. This
requires adding shared instrumentation, using the separate DSM approach
introduced by dd78e69cfc33.

Author: Tomas Vondra <tomas@vondra.me>
Reviewed-by: Melanie Plageman <melanieplageman@gmail.com>
Reviewed-by: Lukas Fittl <lukas@fittl.com>
Reviewed-by: Andres Freund <andres@anarazel.de>
Discussion: https://postgr.es/m/flat/a177a6dd-240b-455a-8f25-aca0b1c08c6e%40vondra.me

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/3b1117d6e2e47d86cdbd978b79434c630cb0ef52

Modified Files
--------------
src/backend/commands/explain.c         |  25 +++++++
src/backend/executor/execParallel.c    |  11 +++
src/backend/executor/nodeSeqscan.c     | 133 ++++++++++++++++++++++++++++++---
src/include/executor/instrument_node.h |  19 +++++
src/include/executor/nodeSeqscan.h     |   9 +++
src/include/nodes/execnodes.h          |   1 +
src/test/regress/expected/explain.out  |  18 ++++-
src/test/regress/sql/explain.sql       |   4 +-
src/tools/pgindent/typedefs.list       |   2 +
9 files changed, 209 insertions(+), 13 deletions(-)



view thread (2+ messages)  latest in thread

Message-ID: <E1wADe4-003S8t-3C@gemulon.postgresql.org>
Permalink:  ../E1wADe4-003S8t-3C@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1wADe4-003S8t-3C@gemulon.postgresql.org

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: tomas.vondra@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Add EXPLAIN (IO) instrumentation for SeqScan
  In-Reply-To: <E1wADe4-003S8t-3C@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox