[PERFORM] How can one see what queries are running withing a postgres instance?

Hi! I'd like to know if there is a way to see what queries are running within a certain postgres instance and how much resources (cpu/memory) etc. they are using. Right now it's impossible to see what is happening within postgres when it's binaries are using 100% CPU. In Sybase there is a comman

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

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!