Re: Procedural Code Profiling - Mailing list pgsql-general

From Lewis Cunningham
Subject Re: Procedural Code Profiling
Date
Msg-id 537429.62801.qm@web35606.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Procedural Code Profiling  ("korry.douglas" <korry.douglas@enterprisedb.com>)
List 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 by date:

Previous
From: "korry.douglas"
Date:
Subject: Re: Procedural Code Profiling
Next
From: "Stuart"
Date:
Subject: dbi and indexes