From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Naveen Kumar <naveenchowdaryon@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: wait_event_type IO & wait_event CopyFileRead
Date: Tue, 27 Oct 2020 15:07:02 +0100
Message-ID: <5c66e825f5edca6ad9eb3e7eba587208c8f303fb.camel@cybertec.at> (raw)
In-Reply-To: <CADk76jrDg9fk82XW_y9J+qHiYtkfEXdwBfa25zw_cU6nf8=afQ@mail.gmail.com>
References: <CADk76jrDg9fk82XW_y9J+qHiYtkfEXdwBfa25zw_cU6nf8=afQ@mail.gmail.com>
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
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: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, naveenchowdaryon@gmail.com
Subject: Re: wait_event_type IO & wait_event CopyFileRead
In-Reply-To: <5c66e825f5edca6ad9eb3e7eba587208c8f303fb.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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