Re: Procedural Code Profiling

Поиск
Список
Период
Сортировка
От Lewis Cunningham
Тема Re: Procedural Code Profiling
Дата
Msg-id 537429.62801.qm@web35606.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: Procedural Code Profiling  ("korry.douglas" <korry.douglas@enterprisedb.com>)
Список pgsql-general
--- "korry.douglas" <korry.douglas@enterprisedb.com> wrote:

>     execution count (number of times each statement is executed)
>     total execution time (how long did we spend executing each
> statement?)
>     longest execution time (how long did the slowest iteration
> take?)
>     number of scans (total number of sequential and indexed scans)
>     blocks fetched (for each statement)
>     blocks hit (blocks found in buffer pool) (for each statement)
>     tuples returned (for each statement)
>     tuples fetched (for each statement)
>     tuples inserted (for each statement)
>     tuples updated (for each statement)
>     tuples deleted (for each statement)
>

Sweet.  This is exactly what I was looking for.

Thanks,

LewisC



-----------------------------------------------------------
Lewis R Cunningham

An Expert's Guide to Oracle Technology
http://blogs.ittoolbox.com/oracle/guide/

LewisC's Random Thoughts
http://lewiscsrandomthoughts.blogspot.com/

EnterpriseDB: The Definitive Reference
http://tinyurl.com/39246e
----------------------------------------------------------

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

Предыдущее
От: "korry.douglas"
Дата:
Сообщение: Re: Procedural Code Profiling
Следующее
От: "Stuart"
Дата:
Сообщение: dbi and indexes