Message-ID: <5c66e825f5edca6ad9eb3e7eba587208c8f303fb.camel@cybertec.at>
Subject: Re: wait_event_type IO & wait_event CopyFileRead
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Naveen Kumar <naveenchowdaryon@gmail.com>, pgsql-admin
	 <pgsql-admin@postgresql.org>
Date: Tue, 27 Oct 2020 15:07:02 +0100
In-Reply-To: 
 <CADk76jrDg9fk82XW_y9J+qHiYtkfEXdwBfa25zw_cU6nf8=afQ@mail.gmail.com>
References: 
	<CADk76jrDg9fk82XW_y9J+qHiYtkfEXdwBfa25zw_cU6nf8=afQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.36.5 (3.36.5-1.fc32) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk

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