Re: running query

Hi,
I did it.
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.

Regards.


=?iso-8859-15?q?Herv=E9=20Piedvache?= wrote:

> Look at contrib folder in the postgresql distribution then pg_monitor
>
> Regards,
>
> Le Vendredi 15 Novembre 2002 11:53, pginfo a écrit :
> > Hi,
> > How can I see all the currently running queryes?
> >
> > thanks.
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
> --
> Hervé Piedvache
>
> Elma Ingénierie Informatique
> 6 rue du Faubourg Saint-Honoré
> F-75008 - Paris - France
> Tel. 33-144949901
> fax. 33-144949902
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)