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

Sorry It's not in the contrib folder of PostgreSQL ... but you will find it on gborg.postgresql.org ! Regards, Le vendredi 25 Juin 2004 22:51, Hervé Piedvache a écrit : Let see in contrib/ the application pg_who ... you will see the process, the queries, and the CPU ... ;o) Regards, Le

[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 postgres instance?

Let see in contrib/ the application pg_who ... you will see the process, the queries, and the CPU ... ;o) Regards, Le vendredi 25 Juin 2004 21:37, P.A.M. van Dam a écrit : 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