Lists: | pgsql-performance |
---|
From: | std pik <stdpik(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Cc: | khld(dot)faroug(at)gmail(dot)com |
Subject: | Execution Plan |
Date: | 2010-07-23 04:06:00 |
Message-ID: | aca90f67-13b2-4e9e-acea-df248c265c00@x21g2000yqa.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-performance |
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.
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From: | Rodrigo E(dot) De León Plicet <rdeleonp(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-08-04 03:29:57 |
Message-ID: | AANLkTikqwpUiXgd2xFtSQ+WCDqWoKCU6AKuLmf=_bvYS@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-performance |
On Thu, Jul 22, 2010 at 11:06 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
> 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.
Check out pgstatspack:
http://blogs.sun.com/glennf/entry/pgstatspack_getting_at_postgres_performance
http://pgfoundry.org/projects/pgstatspack/