Hello
2010/7/23 std pik <stdpik@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
>