SQL CPU time usage

Поиск
Список
Период
Сортировка
От Ruben Rubio Rey
Тема SQL CPU time usage
Дата
Msg-id 446B3F6A.9070205@rentalia.com
обсуждение исходный текст
Ответы Re: SQL CPU time usage  (john_oshea@wordbank.com)
Re: SQL CPU time usage  ("Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jignesh K. Shah"
Дата:
Сообщение: Re: Pgsql (and mysql) benchmark on T2000/Solaris and some
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: IMMUTABLE?