On Thu, Jul 22, 2010 at 10:10 PM, std pik <stdpik@xxxxxxxxx> 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) -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
