procpid for temp schema - Mailing list pgsql-admin

From ashok raj
Subject procpid for temp schema
Date
Msg-id 399c75c20903310100q2dfb449cn3f501a58144baf4c@mail.gmail.com
Whole thread Raw
Responses Re: procpid for temp schema  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: procpid for temp schema  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
Hi ,

         is there a way that we could find which procpid or connection that has created a particular temporary  schema (pg_temp_*) ?.

         In one of our db a temporary schema (pg_temp_48) was using more than 200GB of disk space  and how to find the connection which has created the temp schema,  ? 

--
Regards,
Ashokraj


pgsql-admin by date:

Previous
From: toni hernández
Date:
Subject: Re: copy command and column attribute
Next
From: "Marc Abbott"
Date:
Subject: PG Patch