I don’t think there is any old connection connected as there is no process I found from pg_stat_activity.
Is there any other way to trace out such sessions.
Regards
Atul
On Monday, June 7, 2021, Ravi Krishna <ravikrishna3@xxxxxxxxxx> 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.
>
Ideally applications which creates temp table should drop it when no longer needed.
When not dropped, they get dropped automatically when the session which created
them terminates. Looks like in your case both are not happening.
Which is the oldest session still shown as connected?
