Re: Commands to browse current connections and processes

From: Mark Gibson <gibsonm(at)cromwell(dot)co(dot)uk>
To: Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Commands to browse current connections and processes
Date: 2004-10-06 15:09:22
Message-ID: c4365539f13874dfccd5c87da00c750341640ac4@cromwell.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-06 15:10:30 Re: Cache lookup failed for relation, when trying to DROP TABLE.
Previous Message Mike Nolan 2004-10-06 15:06:00 Re: two digit years in inserts