| 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
| 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 |
| 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 |