Hello,

In mysql, we use "show processlist" to see all current process. Could
someone let me know in PostgreSQL, what commands that we can check the
current connections and processes please?

Thanks a lot,
Ly



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Ying Lu wrote:[color=blue]
> Hello,
>
> In mysql, we use "show processlist" to see all current process. Could
> someone let me know in PostgreSQL, what commands that we can check the
> current connections and processes please?[/color]

SELECT * FROM pg_catalog.pg_stat_activity;

--
Mark Gibson <gibsonm |AT| cromwell |DOT| co |DOT| uk>
Web Developer & Database Admin
Cromwell Tools Ltd.
Leicester, England.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org