Re: How can one see what queries are running withing a

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hervé Piedvache <footcow(at)noos(dot)fr>
Cc: pgsql-performance(at)postgresql(dot)org, pam(at)pmg(dot)xs4all(dot)nl
Subject: Re: How can one see what queries are running withing a
Date: 2004-06-26 08:58:16
Message-ID: 40DD3AA8.3040708@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


>>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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Doug McNaught 2004-06-26 13:32:08 Re: postgres 7.4 at 100%
Previous Message Chris Cheston 2004-06-26 08:08:57 Re: postgres 7.4 at 100%