Re: running query - Mailing list pgsql-general

From pginfo
Subject Re: running query
Date
Msg-id 3DD513F5.5A943F90@t1.unisoftbg.com
Whole thread Raw
In response to running query  (pginfo <pginfo@t1.unisoftbg.com>)
Responses Re: running query  (Patrick Welche <prlw1@newn.cam.ac.uk>)
List pgsql-general
I am superuser.

Alvaro Herrera wrote:

> On Fri, Nov 15, 2002 at 12:10:57PM +0100, pginfo wrote:
>
> > I start  select * from pg_stat_activity;
> > And as result I see
> >   datid | datname | procpid | usesysid | usename  | current_query
> > -------+---------+---------+----------+----------+---------------
> >  16556 | mybase |    1162 |        2 | myuser  |
> >  16556 | mybase |    1163 |        2 | myuser  |
> >  16556 | mybase |    1164 |        2 | myuser  |
> >  16556 | mybase |    1165 |        2 | myuser  |
> >
> > I do not see the running tasks and I am sure that this tasks exist.
>
> You need to be superuser, AFAIU.
>
> --
> Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
> FOO MANE PADME HUM




pgsql-general by date:

Previous
From: afalanga@syracusenetworks.com (Andrew Falanga)
Date:
Subject: Installing PostgreSQL on HPUX 11i (with TCL) -- how does one do it
Next
From: mtooker@magma.ca (Mark Tooker)
Date:
Subject: psql question