public inbox for [email protected]
help / color / mirror / Atom feedFrom: James Pang <[email protected]>
To: [email protected]
Subject: many sessions waiting DataFileRead and extend
Date: Wed, 25 Jun 2025 11:15:08 +0800
Message-ID: <CAHgTRfdDkiX5bLRCYhrP18kFJjcvs1eHvL+jUtX1Ep-Y3=cFVg@mail.gmail.com> (raw)
pgv14, RHEL8, xfs , we suddenly see tens of sessions waiting on
"DataFileRead" and "extend", it last about 2 seconds(based on
pg_stat_activity query) , during the waiting time, "%sys" cpu increased to
80% , but from "iostat" , no high iops and io read/write latency increased
either.
many sessions were running same "DELETE FROM xxxx" in parallel waiting
on "extend" and "DataFileRead", there are triggers in this table "After
delete" to insert/delete other tables in the tigger.
time wait_event
count(sessions)
2025-06-24 18:00:11.687245+00 | DataFileFlush | 1
2025-06-24 18:00:11.687245+00 | DataFileWrite | 1
2025-06-24 18:00:11.687245+00 | PgSleep | 1
2025-06-24 18:00:11.687245+00 | DataFileExtend | 7
2025-06-24 18:00:11.687245+00 | ProcArrayGroupUpdate | 1
2025-06-24 18:00:11.687245+00 | WALWrite | 5
2025-06-24 18:00:11.687245+00 | extend | 55
2025-06-24 18:00:11.687245+00 | DataFileRead | 45
2025-06-24 18:00:11.687245+00 | DataFilePrefetch | 2
Thanks,
James
view thread (14+ messages) latest in thread
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: many sessions waiting DataFileRead and extend
In-Reply-To: <CAHgTRfdDkiX5bLRCYhrP18kFJjcvs1eHvL+jUtX1Ep-Y3=cFVg@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