Re: Tutorial EXPLAIN for idiots?

A. Kretschmer wrote:

am  Fri, dem 07.09.2007, um 12:30:06 +0200 mailte Erwin Moller folgendes: 

Hi group,

Does anybody know of an tutorial for EXPLAIN for idiots like me?
(I am fairly confortable with Postgres, but never used EXPLAIN before.)

I need to optimize a few slow running queries, but I am not really 
getting it when reading:
http://www.postgresql.org/docs/8.1/interactive/performance-tips.html

A bit hard for starters. :-/

Any tips/sites?   

http://redivi.com/~bob/oscon2005_pgsql_pdf/OSCON_Explaining_Explain_Public.pdf


Andreas 

Thanks Hubert and Andreas!

Looks good.
That will keep me busy for a while. ;-)
Thanks.

Regards,
Erwin Moller

-- 



-------------------
Erwin Moller
Darwine BV

Groenendaal 25f
3011 SK Rotterdam
tel 010-2133996
-------------------