[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

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