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/