From: | "David Parker" <dparker(at)tazznetworks(dot)com> |
---|---|
To: | "Michael Fuhr" <mike(at)fuhr(dot)org>, "Bruno Wolff III" <bruno(at)wolff(dot)to>, "postgres general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: SQL call to get pid of current connection |
Date: | 2005-06-03 01:43:20 |
Message-ID: | 07FDEE0ED7455A48AC42AC2070EDFF7C746B97@corpsrv2.tazznetworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
That certainly looks like it! Thanks!
- DAP
>-----Original Message-----
>From: Michael Fuhr [mailto:mike(at)fuhr(dot)org]
>Sent: Thursday, June 02, 2005 8:47 PM
>To: Bruno Wolff III; David Parker; postgres general
>Subject: Re: [GENERAL] SQL call to get pid of current connection
>
>On Thu, Jun 02, 2005 at 05:02:14PM -0500, Bruno Wolff III wrote:
>> On Thu, Jun 02, 2005 at 17:04:22 -0400,
>> David Parker <dparker(at)tazznetworks(dot)com> wrote:
>> > Is there a function call that will return the pid of the postgres
>> > process associated with the current client connection?
>>
>> I thought I remembered seeing one, but I looked through the
>> development docs and didn't see a function or a GUC variable
>with that information.
>
>Are you looking for pg_backend_pid()? It's documented in the
>"Statistics Collector" section of the "Monitoring Database Activity"
>chapter; it's been around since 7.3:
>
>http://www.postgresql.org/docs/7.3/interactive/release-7-3.html
>http://www.postgresql.org/docs/7.3/interactive/monitoring-stats.html
>http://www.postgresql.org/docs/7.4/interactive/monitoring-stats.html
>http://www.postgresql.org/docs/8.0/interactive/monitoring-stats.html
>
>--
>Michael Fuhr
>http://www.fuhr.org/~mfuhr/
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tino Wildenhain | 2005-06-03 05:44:14 | Re: PostgreSQL vs. InnoDB performance |
Previous Message | Tom Lane | 2005-06-03 01:03:12 | Re: SQL call to get pid of current connection |