Tutorial EXPLAIN for idiots?

From: Erwin Moller <erwin(at)darwine(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Tutorial EXPLAIN for idiots?
Date: 2007-09-07 10:30:06
Message-ID: 46E1282E.8040508@darwine.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
-------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2007-09-07 10:44:23 Case insensitivity problem
Previous Message Martijn van Oosterhout 2007-09-07 10:29:54 Re: Type cast text to int4