You may also try PgFouine (http://pgfouine.projects.postgresql.org/)
for log analysis, I found it very useful in similar situation.
On 5/17/06, Ruben Rubio Rey <[EMAIL PROTECTED]> wrote:
Hi,
I have a web page, that executes several SQLs.
So, I would like to know witch one of those SQLs consum
[EMAIL PROTECTED] wrote:
On 17 May 2006, at 16:21, Ruben Rubio Rey wrote:
I have a web page, that executes several SQLs.
So, I would like to know witch one of those SQLs consumes more CPU.
For example,
I have SQL1 that is executed in 1.2 secs and a SQL2 that is executed
in 200 ms.
But SQL
On 17 May 2006, at 16:21, Ruben Rubio Rey wrote:
I have a web page, that executes several SQLs.
So, I would like to know witch one of those SQLs consumes more CPU.
For example,
I have SQL1 that is executed in 1.2 secs and a SQL2 that is
executed in 200 ms.
But SQL2 is executed 25 times and
