Thread: Information Extract

I'd like to know how can we get the following information in
PostgreSQL 8.4:
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.

Please don't ever post the same question to multiple lists like you've
done here with this one again.  The suggested practice for the
postgresql.org lists is to try the most appropriate list with a
question, then consider asking on another list only if you haven't
gotten any responses after a day or two.  Posting to multiple ones at
once will annoy those of us who are subscribed to all of them, which
actually makes it less likely you'll get a good answer to your question.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us