Re: running query

Not sure: maybe

set stats_command_string=on;

?

Cheers,

Patrick

On Fri, Nov 15, 2002 at 04:34:13PM +0100, pginfo wrote:
> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster