Question on pg_stat_io showing zero reads/writes for I/O workers

From: Shardul Borhade <shardul(at)dbtune(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Question on pg_stat_io showing zero reads/writes for I/O workers
Date: 2025-10-31 08:17:22
Message-ID: CA+xwDujmUnm_vbojvvRz87tuwTA90CZrC8HGor99Nv9RtJERRg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Xuneng Zhou 2025-10-31 09:40:55 Re: Question on pg_stat_io showing zero reads/writes for I/O workers
Previous Message OMPRAKASH SAHU 2025-10-31 07:47:48 Re: WAL replay is too slow on secondary server

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2025-10-31 08:56:25 Re: Fully documenting the design of nbtree row comparison scan keys
Previous Message Fabrice Chapuis 2025-10-31 08:15:57 Re: Issue with logical replication slot during switchover