Execution plan

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.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Execution plan

On Thu, Jul 22, 2010 at 10:10 PM, std pik wrote:
> Hi all..
> Can any one help me?
> I'd like to know how can we get the following information in
> PostgreSQL:
> Execution plan

explain
explain analyze

explain just shows the plan, explain analyze shows the plan, runs the
query, then shows the difference between the plan and actual
execution.

> 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.

Yeah, pgsql doesn't really track a lot of that stuff as well as
oracle. You can use pg_stat_* tables to get some idea, and running an
individual query while using tools like iostat, vmstat, htop, and more
can give you some idea of how it's working the system. Also the
pg_buffercache stuff (I think that's the name I'm away from my servers
right now)

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin