pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
wait_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>
  2020-10-27 14:07 ` Re: wait_event_type IO & wait_event CopyFileRead Laurenz Albe <laurenz.albe@cybertec.at>
  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 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>
  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