Thread: Commands to browse current connections and processes

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

Ying Lu wrote:
> 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?

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.