X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DEB85D1B19F for ; Sat, 26 Jun 2004 04:27:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73969-02 for ; Sat, 26 Jun 2004 07:27:17 +0000 (GMT) Received: from mx.noos.fr (pm-mx3.mgn.net [195.46.220.211]) by svr1.postgresql.org (Postfix) with ESMTP id 680F8D1B1B3 for ; Sat, 26 Jun 2004 04:27:13 -0300 (ADT) Received: from noos.fr (pm-mnet2.mgn.net [195.46.220.219]) by mx.noos.fr (Postfix) with SMTP id 1FC7526B54; Sat, 26 Jun 2004 09:27:14 +0200 (MEST) X-Mailbox-Line: From footcow@noos.fr Sat Jun 26 09:27:13 2004 Received: from e115.dhcp212-198-145.noos.fr (e115.dhcp212-198-145.noos.fr [212.198.145.115]) by pm-mnet2.mgn.net with ESMTP; Sat, 26 Jun 2004 09:27:13 (MEST) From: =?iso-8859-15?q?Herv=E9_Piedvache?= To: pgsql-performance@postgresql.org Subject: Re: How can one see what queries are running withing a postgres instance? Date: Sat, 26 Jun 2004 09:27:12 +0200 User-Agent: KMail/1.6.2 Cc: pam@pmg.xs4all.nl References: <1088192269.6490.3.camel@localhost> <200406252251.09228.footcow@noos.fr> In-Reply-To: <200406252251.09228.footcow@noos.fr> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Message-Id: <200406260927.12812.footcow@noos.fr> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_NJABL, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200406/258 X-Sequence-Number: 7316 Sorry It's not in the contrib folder of PostgreSQL ... but you will find it= on=20 gborg.postgresql.org ! Regards, Le vendredi 25 Juin 2004 22:51, Herv=E9 Piedvache a =E9crit : > 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 =E9crit : > > 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 command which let's you view what 'processes' are > > running within the server and how much cpu (according to Sybase) they > > are using. It also provides you with a stored procedure to kill off some > > bad behaving queries. How can one do this within postgres? > > > > Thanks in advance! > > > > Best regards, > > > > Pascal > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster --=20 Bill Footcow