Обсуждение: wait_event_type IO & wait_event CopyFileRead

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