Re: base directory size getting increased

Hi,

Is there any way to check which temporary file is being used by which query.

Any query/ view to check it, could you share or suggest ?

Is there any way to be safe while deleting such files.

Regards
Atul

On Monday, June 7, 2021, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:

> On Mon, 2021-06-07 at 17:48 +0530, Atul Kumar wrote:
> > initially pgsql_tmp size was 87 GB and after execution of query it was
> > started increasinng beyond 87GBs so yes, pgsql_tmp directory size is
> > getting increased while exporting data into csv file.
> >
> > But once I rolled back the query, pgsql_tmp directory it was back to
> > 87 GBs so please help me in telling how do I clean that 87GB of space
> > of pgsql_tmp directory.
>
> The files in that directory will always be cleaned up when the
> query that uses the temporary files is done.
> The backend process ID of the query is part of the temporary file name.
>
> It could be that such files are left behind after a crash.
> If you are sure that the don't belong to a running query (for example,
> if their modification timestamp is old), you can delete them.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>