Search Postgresql Archives

Log Query and Execution time

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Log Query and Execution time
From: "Luki Rustianto" <lukirus@xxxxxxxxx>
Date: Mon, 26 Mar 2007 15:45:07 +0700
Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=sm+V/sLXAtTM/LgcgK9QYQUU/HEauvbqLXK9qbD3T1YHVDy8IzrDzPnXC/6tg6CRWjZulk7/Et7KRHE+/PowsDLbTGa/7RkXGjcQXvPT8pUix8AY7w341XTNvNg3bHe/RqJKfztX5e+ppDvcC76SFrdjfux5cRERJSuHot9Jr/I=

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Log Query and Execution time
  - From: A. Kretschmer

Prev by Date: Server memory and efficientcy
Next by Date: Re: Log Query and Execution time
Previous by thread: Server memory and efficientcy
Next by thread: Re: Log Query and Execution time
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux