ashok raj escribió:
> 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, ?
select backendid, pg_stat_get_backend_pid(backendid) as pid
from pg_stat_get_backend_idset() as backendid;
Look for backendid=48.
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-admin by date
|Next:||From: Rafael Domiciano||Date: 2009-03-31 16:04:15|
|Subject: Vacuum Full|
|Previous:||From: Tom Lane||Date: 2009-03-31 14:24:28|
|Subject: Re: PG Patch |