Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4F475633D58 for ; Tue, 31 Mar 2009 11:07:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68971-03 for ; Tue, 31 Mar 2009 11:07:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id D9049634603 for ; Tue, 31 Mar 2009 11:07:40 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n2VE7c3J009043; Tue, 31 Mar 2009 10:07:38 -0400 (EDT) To: ashok raj cc: pgsql-admin@postgresql.org Subject: Re: procpid for temp schema In-reply-to: <399c75c20903310100q2dfb449cn3f501a58144baf4c@mail.gmail.com> References: <399c75c20903310100q2dfb449cn3f501a58144baf4c@mail.gmail.com> Comments: In-reply-to ashok raj message dated "Tue, 31 Mar 2009 13:30:42 +0530" Date: Tue, 31 Mar 2009 10:07:38 -0400 Message-ID: <9042.1238508458@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/263 X-Sequence-Number: 31763 ashok raj writes: > is there a way that we could find which procpid or connection that > has created a particular temporary schema (pg_temp_*) ?. In 8.3 and up, the number in the pg_temp_N schema name is the same as the first component of the virtualxids that that session uses. Not sure how much help that is to you, but if the session is actively doing anything you should be able to identify its number by watching pg_locks. regards, tom lane