just a question: have you tried to trace the connection? It may reveal some additional information, may not. [pg_trace() pg_untrace()] ----- Original Message ----- From: "Scott Weikart" <ScottW@xxxxxxxxxxxx> To: <pgsql-php@xxxxxxxxxxxxxx> Cc: "Scott Weikart" <scottw@xxxxxxxxxxxx> Sent: Sunday, March 03, 2002 12:25 AM Subject: Re: [PHP] resource logging to optimize DBMS queries: how match access_log to pg log? | Responding to my own email... | | 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? | | 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. | | However, I would still like to know the answer to this problem: | | > 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? | | -scott | | ---------------------------(end of broadcast)--------------------------- | TIP 3: if posting/reading through Usenet, please send an appropriate | subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your | message can get through to the mailing list cleanly
