Skip site navigation (1) Skip section navigation (2)

Re: Execution Plan

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: std pik <stdpik(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, khld(dot)faroug(at)gmail(dot)com
Subject: Re: Execution Plan
Date: 2010-07-23 07:43:27
Message-ID: AANLkTimsh0P6e-5KgZkbsU3M-AZzq-fmREJMajnP-xBq@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hello

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

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
pg_tables;

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.

Regards

Pavel Stehule

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:
> http://www.postgresql.org/mailpref/pgsql-performance
>

In response to

pgsql-performance by date

Next:From: Torsten ZühlsdorffDate: 2010-07-23 09:22:18
Subject: Re: Using more tha one index per table
Previous:From: std pikDate: 2010-07-23 04:06:00
Subject: Execution Plan

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group