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 mu

[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] postgres 7.4 at 100%

Chris Cheston wrote: Hi all, I was running Postgres 7.3 and it was running at about 15% with my application. On Postgres 7.4 on another box, it was running at 100%... People are going to need more information. Are you talking about CPU/disk IO/memory? My settings are default on both boxes I think

[PERFORM] postgres 7.4 at 100%

Hi all, I was running Postgres 7.3 and it was running at about 15% with my application. On Postgres 7.4 on another box, it was running at 100%... My settings are default on both boxes I think. There are only about 20 inserts per second, which is really low. Anyone have any ideas as to something