How to practice on EXPLAIN/optimizing queries/constructing indices

From: Magnus Persson <magnus(dot)e(dot)persson(at)gmail(dot)com>
To: PgSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: How to practice on EXPLAIN/optimizing queries/constructing indices
Date: 2014-07-09 20:24:31
Message-ID: 53BDA4FF.4010301@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

So I found https://wiki.postgresql.org/wiki/Using_EXPLAIN but still I
feel there should be more to it.
What methods can I use to actually get better at spotting issues with a
query? How can I go from looking at a fancy EXPLAIN graph produced by
PgAdmin and realize what the problem is (if there is one)?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Keith 2014-07-09 20:33:52 Re: How to practice on EXPLAIN/optimizing queries/constructing indices
Previous Message Tom Lane 2014-07-08 14:04:36 Re: collation from an external file