Обсуждение: How to read the execution Plan

Поиск
Список
Период
Сортировка

How to read the execution Plan

От
akp geek
Дата:
Hi all -

        I would request, If any one has document on how to read and interpret the postgres execution plan, can you please share it?

Regards

Re: How to read the execution Plan

От
Ben Chobot
Дата:
On Apr 22, 2010, at 5:43 AM, akp geek wrote:

> Hi all -
>
>         I would request, If any one has document on how to read and interpret the postgres execution plan, can you
pleaseshare it? 

http://wiki.postgresql.org/wiki/Using_EXPLAIN

Re: How to read the execution Plan

От
Jaime Casanova
Дата:
On Thu, Apr 22, 2010 at 7:43 AM, akp geek <akpgeek@gmail.com> wrote:
> Hi all -
>         I would request, If any one has document on how to read and
> interpret the postgres execution plan, can you please share it?

http://wiki.postgresql.org/wiki/Introduction_to_VACUUM%2C_ANALYZE%2C_EXPLAIN%2C_and_COUNT
http://wiki.postgresql.org/wiki/Using_EXPLAIN


--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

Re: How to read the execution Plan

От
Scott Marlowe
Дата:
On Thu, Apr 22, 2010 at 6:43 AM, akp geek <akpgeek@gmail.com> wrote:
> Hi all -
>         I would request, If any one has document on how to read and
> interpret the postgres execution plan, can you please share it?
> Regards

start here:

http://explain.depesz.com/

Re: How to read the execution Plan

От
akp geek
Дата:
thanks a  lot. I am going thru it

Regards

On Thu, Apr 22, 2010 at 10:56 AM, Ben Chobot <bench@silentmedia.com> wrote:
On Apr 22, 2010, at 5:43 AM, akp geek wrote:

> Hi all -
>
>         I would request, If any one has document on how to read and interpret the postgres execution plan, can you please share it?

http://wiki.postgresql.org/wiki/Using_EXPLAIN