On Thu, Jul 22, 2010 at 11:06 PM, std pik <std...@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/ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
