2010/7/23 std pik <stdpik(at)gmail(dot)com>:
> Hi all..
> Can any one help me?
> I'd like to know how can we get the following information in
> 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.
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
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.
maybe you searching some like http://pgfouine.projects.postgresql.org/
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-performance by date
|Next:||From: Torsten Zühlsdorff||Date: 2010-07-23 09:22:18|
|Subject: Re: Using more tha one index per table|
|Previous:||From: std pik||Date: 2010-07-23 04:06:00|
|Subject: Execution Plan|