Log Query and Execution time

From: "Luki Rustianto" <lukirus(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Log Query and Execution time
Date: 2007-03-26 08:45:07
Message-ID: a87d9f3a0703260145u169c1f9bjfc4988d8f5695f9d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

Is there is a way to log every SQL query on potgresql server and also
their execution time?
I need to find which query that eat CPU resource. Applications
connected to this server are from PHP and VB client.

Thanx.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-03-26 08:59:21 Re: Log Query and Execution time
Previous Message amrit angsusingh 2007-03-26 02:39:08 Server memory and efficientcy