Tutorial EXPLAIN for idiots?

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
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

On Fri, Sep 07, 2007 at 12:30:06PM +0200, Erwin Moller wrote:

Any tips/sites?

check this:

http://www.postgresql.org/communityfiles/13.sxi

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

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