Skip site navigation (1) Skip section navigation (2)

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

From: "P(dot)A(dot)M(dot) van Dam " <pam(at)ramoth(dot)xs4all(dot)nl>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Herv? Piedvache <footcow(at)noos(dot)fr>,pgsql-performance(at)postgresql(dot)org
Subject: Re: How can one see what queries are running withing a
Date: 2004-06-27 17:25:20
Message-ID: 20040627172520.GA3038@pmg.xs4all.nl (view raw or flat)
Thread:
Lists: pgsql-performance
On Sat, Jun 26, 2004 at 04:58:16PM +0800, Christopher Kings-Lynne wrote:
> 
> >>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.

Thanks!

That works as needed!

Best regards,

	Pascal

> 
> Chris
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>               http://www.postgresql.org/docs/faqs/FAQ.html

In response to

pgsql-performance by date

Next:From: JimDate: 2004-06-28 00:37:33
Subject: SQL stupid query plan... terrible performance !
Previous:From: Christopher Kings-LynneDate: 2004-06-27 05:33:25
Subject: Re: postgres 7.4 at 100%

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group