Re: Execution plan

On Thu, Jul 22, 2010 at 10:10 PM, std pik <stdpik(at)gmail(dot)com> 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 <your query here>
explain analyze <your query here>

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)