Hello 2010/7/23 std pik <std...@gmail.com>: > 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. >
It is depend on version of PostgreSQL that you use. In 9.0 you can EXPLAIN explain (analyze true, buffers true, costs true) select * from pg_tables; other useful info are in table pg_stat_user_tables, pg_stat_user_indexes But for example CPU consumption you can see never - PostgreSQL uses little bit different methods. Regards Pavel Stehule maybe you searching some like http://pgfouine.projects.postgresql.org/ > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
