Received: from pompom.freestart.hu (pompom.freestart.hu [213.197.64.6]) by postgresql.org (Postfix) with ESMTP id 71CCA474E44 for ; Sun, 3 Mar 2002 05:31:27 -0500 (EST) Received: from line-81-132.dial.freestart.hu ([213.197.81.132] helo=jaguar) by freestart.hu with smtp (Freestart relay 1 (FS-Lin)) id 16hTCk-0004yc-00 for ; Sun, 03 Mar 2002 11:27:03 +0100 Message-ID: <002d01c1c29e$c6bed120$01fdfea9@jaguar> Reply-To: "Papp Gyozo" From: "Papp Gyozo" To: References: <02030118361905.01861@sandino.dnsalias.org> <02030215254105.03865@sandino.dnsalias.org> Subject: Re: resource logging to optimize DBMS queries: how match access_log to pg log? Date: Sun, 3 Mar 2002 11:32:19 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Scanner: exiscan by Freestart X-Archive-Number: 200203/3 X-Sequence-Number: 972 just a question:=20 have you tried to trace the connection?=20 It may reveal some additional information, may not. [pg_trace() pg_untrace()] ----- Original Message -----=20 From: "Scott Weikart" To: Cc: "Scott Weikart" Sent: Sunday, March 03, 2002 12:25 AM Subject: Re: [PHP] resource logging to optimize DBMS queries: how match acc= ess_log to pg log? | Responding to my own email... |=20 | On Friday 01 March 2002 6:36 pm, Scott Weikart wrote: | > But, how can I match the PHP log with the PID of the database | > connection? Is there an SQL command I can run to find out my | > connections PID, or some other identifier that I can put in | > PostgreSQL's log? |=20 | I just figured out the obvious solution to my first problem: don't | rely on the PostgreSQL log, instead have the PHP application log the | queries itself. |=20 | However, I would still like to know the answer to this problem: |=20 | > Also, is there a query I can run that will quantify the amount of | > resources that PostgreSQL had to use to satisfy all the queries made | > during the connection? |=20 | -scott |=20 | ---------------------------(end of broadcast)--------------------------- | TIP 3: if posting/reading through Usenet, please send an appropriate | subscribe-nomail command to majordomo@postgresql.org so that your | message can get through to the mailing list cleanly