Re: Anyway to know which users are connected to postgres? - Mailing list pgsql-general

From Tom Lane
Subject Re: Anyway to know which users are connected to postgres?
Date
Msg-id 19749.1011047431@sss.pgh.pa.us
Whole thread Raw
In response to Re: Anyway to know which users are connected to postgres?  (Elein <elein@nextbus.com>)
List pgsql-general
Elein <elein@nextbus.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

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Very large database
Next
From: "Jeffrey W. Baker"
Date:
Subject: 7.2b4: faster to dump and reload than to vacuum full