| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Naveen Kumar <naveenchowdaryon(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: wait_event_type IO & wait_event CopyFileRead |
| Date: | 2020-10-27 14:07:02 |
| Message-ID: | 5c66e825f5edca6ad9eb3e7eba587208c8f303fb.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2020-10-27 14:10:50 | Re: free(): invalid pointer , when to dumping data to a new server |
| Previous Message | Naveen Kumar | 2020-10-27 11:57:16 | wait_event_type IO & wait_event CopyFileRead |