| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to>, David Parker <dparker(at)tazznetworks(dot)com>, postgres general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SQL call to get pid of current connection |
| Date: | 2005-06-03 00:47:12 |
| Message-ID: | 20050603004712.GA15829@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Greg Sabino Mullane | 2005-06-03 00:57:02 | Re: PostgreSQL vs. InnoDB performance |
| Previous Message | Tom Lane | 2005-06-03 00:32:00 | Re: PostgreSQL vs. InnoDB performance |