Re: Anyway to know which users are connected to postgres?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: elein(at)nextbus(dot)com
Cc: "Peter E(dot) Chen" <pchen3(at)jhmi(dot)edu>, "Postgres (General)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Anyway to know which users are connected to postgres?
Date: 2002-01-14 22:30:31
Message-ID: 19749.1011047431@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Elein <elein(at)nextbus(dot)com> writes:
>> In 7.2 there is a system view pg_stat_activity.

> This is very nice. I can't ever see the current query, however,
> even as postgres. Is this column just to tease us? I can
> see it could be a security issue.

You need to turn on query stats. See
http://developer.postgresql.org/docs/postgres/monitoring-stats.html

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2002-01-14 22:32:10 Re: Very large database
Previous Message Tom Lane 2002-01-14 22:28:35 Re: PSQL Core Dumps