How to read the execution Plan

Started by akp geekalmost 16 years ago5 messagesgeneral
Jump to latest
#1akp geek
akpgeek@gmail.com

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

#2Ben
bench@silentmedia.com
In reply to: akp geek (#1)
Re: How to read the execution Plan

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

#3Jaime Casanova
jcasanov@systemguards.com.ec
In reply to: akp geek (#1)
Re: How to read the execution Plan

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

#4Scott Marlowe
scott.marlowe@gmail.com
In reply to: akp geek (#1)
Re: How to read the execution Plan

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/

#5akp geek
akpgeek@gmail.com
In reply to: Ben (#2)
Re: How to read the execution Plan

thanks a lot. I am going thru it

Regards

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

Show quoted text

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