public inbox for [email protected]
help / color / mirror / Atom feedFrom: Shardul Borhade <[email protected]>
To: [email protected]
Subject: Question on pg_stat_io showing zero reads/writes for I/O workers
Date: Fri, 31 Oct 2025 09:17:22 +0100
Message-ID: <CA+xwDujmUnm_vbojvvRz87tuwTA90CZrC8HGor99Nv9RtJERRg@mail.gmail.com> (raw)
Hi team,
I’m running into an issue with pg_stat_io. When I run the following query:
SELECT backend_type, reads, writes, read_time
FROM pg_stat_io
WHERE backend_type LIKE '%io%';
I consistently get:
backend_type | reads | writes | read_time
--------------+-------+--------+-----------
io worker | 0 | 0 | 0
io worker | 0 | 0 | 0
io worker | 0 | 0 | 0
io worker | 0 | 0 | 0
io worker | 0 | 0 | 0
io worker | 0 | 0 | 0
io worker | | 0 |
io worker | 0 | 0 | 0
(8 rows)
I tried running a heavy sequential scan on a 55 GB table as well as a
bitmap heap scan, but the reads and writes columns still show zero.
However, I can clearly observe performance differences when I tune the
io_workers configuration, so I believe they are active.
Am I missing something here? Could someone please help me understand why
the stats aren’t being reflected in pg_stat_io? Do I need to enable any
other server parameter to log this information?
Thanks and regards,
Shardul B
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Question on pg_stat_io showing zero reads/writes for I/O workers
In-Reply-To: <CA+xwDujmUnm_vbojvvRz87tuwTA90CZrC8HGor99Nv9RtJERRg@mail.gmail.com>
* 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