Re: Execution Plan - Mailing list pgsql-performance

On Thu, Jul 22, 2010 at 11:06 PM, std pik <stdpik@gmail.com> wrote:
> Hi all..
> Can any one help me?
> I'd like to know how can we get the following information in
> PostgreSQL:
> Execution plan
> The I/O physical reads and logical reads, CPU consumption, number of
> DB block used, and any other information relevant to performance.
> Taking into consideration that these information could be extracted
> from Oracle by AWR, TKPROF, ...etc.
> Thanks.

Check out pgstatspack:

http://blogs.sun.com/glennf/entry/pgstatspack_getting_at_postgres_performance
http://pgfoundry.org/projects/pgstatspack/