pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedwait_event_type IO & wait_event CopyFileRead
2+ messages / 2 participants
[nested] [flat]
* wait_event_type IO & wait_event CopyFileRead
@ 2020-10-27 11:57 Naveen Kumar <naveenchowdaryon@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Naveen Kumar @ 2020-10-27 11:57 UTC (permalink / raw)
To: pgsql-admin
Hello experts,
I can see my query in wait_event_type *IO*, wait_event *CopyFileRead
*in pg_stat_activity,
Its been running from 4 hours, Can anyone help me understand to
wait_event_type *IO*, wait_event *CopyFileRead, *how to proceed with my
query execution.
Thanks,
Naveen
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: wait_event_type IO & wait_event CopyFileRead
@ 2020-10-27 14:07 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Naveen Kumar <naveenchowdaryon@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2020-10-27 14:07 UTC (permalink / raw)
To: Naveen Kumar <naveenchowdaryon@gmail.com>; pgsql-admin
On Tue, 2020-10-27 at 17:27 +0530, Naveen Kumar wrote:
> I can see my query in wait_event_type IO, wait_event CopyFileRead in pg_stat_activity,
> Its been running from 4 hours, Can anyone help me understand to wait_event_type IO,
> wait_event CopyFileRead, how to proceed with my query execution.
That means that PostgreSQL is reading a file that it wants to copy to
another file, and it it waits for the read operation to finish.
If you are stuck on this for a long time, perhaps you have a file on a
networked file system, and the network connection went bad.
It is hard to say more without knowing what your query is and where the
file resides.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-10-27 14:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-10-27 11:57 wait_event_type IO & wait_event CopyFileRead Naveen Kumar <naveenchowdaryon@gmail.com>
2020-10-27 14:07 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox