Tutorial EXPLAIN for idiots? - Mailing list pgsql-general

From Erwin Moller
Subject Tutorial EXPLAIN for idiots?
Date
Msg-id 46E1282E.8040508@darwine.nl
Whole thread Raw
Responses Re: Tutorial EXPLAIN for idiots?
Re: Tutorial EXPLAIN for idiots?
List pgsql-general
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?

TIA

Regards,
Erwin

--



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

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


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Type cast text to int4
Next
From: "Sergey Konoplev"
Date:
Subject: Case insensitivity problem