From: | "Ivan Zolotukhin" <ivan(dot)zolotukhin(at)gmail(dot)com> |
---|---|
To: | "Ruben Rubio Rey" <ruben(at)rentalia(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: SQL CPU time usage |
Date: | 2006-05-18 16:01:16 |
Message-ID: | 751e56400605180901g6a7854e9s6b21c27347b500e6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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 <ruben(at)rentalia(dot)com> wrote:
> Hi,
>
> 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 SQL1 is executed 1 time, so really
> SQL2 consumes more CPU time.
>
> Is there any way to know this?
> I have think that logging all SQLs and then cheking it is a way to do it
> ... any other idea?
>
> Thanks in advance
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Byers | 2006-05-18 16:41:23 | Re: why is bitmap index chosen for this query? |
Previous Message | Steinar H. Gunderson | 2006-05-18 15:59:06 | Re: why is bitmap index chosen for this query? |