Postgres Pro
Downloads
Home   >   mailing lists

Re: How to list what queries are running in postgres? - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: How to list what queries are running in postgres?
Date
Msg-id 40E1DCCD.5060907@bigfoot.com
Whole thread Raw
In response to How to list what queries are running in postgres?  ("P.A.M. van Dam " <pam@ramoth.xs4all.nl>)
Responses Re: How to list what queries are running in postgres?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
P.A.M. van Dam wrote:

> Hi!
>
> I'm looking for a command or method to find out what queries are
> currently being serviced by the database.

select * from pg_stat_activity;


Regards
Gaetano Mendola

pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Capacity Planning
Next
From: Jean-Denis Giguere
Date:
Subject: grant execute on many functions