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, ?
Try this 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
