Postgres Pro
Downloads
Home   >   mailing lists

Re: How can one see what queries are running withing a - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: How can one see what queries are running withing a
Date
Msg-id 40DD3AA8.3040708@familyhealth.com.au
Whole thread Raw
In response to Re: How can one see what queries are running withing a postgres instance?  (Hervé Piedvache <footcow@noos.fr>)
Responses Re: How can one see what queries are running withing a  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How can one see what queries are running withing a  ("P.A.M. van Dam " <pam@ramoth.xs4all.nl>)
List pgsql-performance
Tree view 
>>Let see in contrib/ the application pg_who ... you will see the process,
>>the queries, and the CPU ... ;o)

Even easier:

SELECT * FROM pg_stat_activity;

As a superuser.

Chris

pgsql-performance by date:

Previous
From: Chris Cheston
Date:
Subject: Re: postgres 7.4 at 100%
Next
From: Doug McNaught
Date:
Subject: Re: postgres 7.4 at 100%