From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
---|---|
To: | Magnus Persson <magnus(dot)e(dot)persson(at)gmail(dot)com> |
Cc: | PgSQL Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: How to practice on EXPLAIN/optimizing queries/constructing indices |
Date: | 2014-07-10 15:13:43 |
Message-ID: | CAL_0b1s5aX940zSWL+87jj=xHSvvV2eP8MwMuorREe2kjEAQfA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, Jul 9, 2014 at 1:24 PM, Magnus Persson
<magnus(dot)e(dot)persson(at)gmail(dot)com> wrote:
> 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)?
There is a good set of articles by depesz that will give you some understanding:
http://www.depesz.com/2013/04/16/explaining-the-unexplainable/
http://www.depesz.com/2013/04/27/explaining-the-unexplainable-part-2/
http://www.depesz.com/2013/04/27/explaining-the-unexplainable-part-3/
http://www.depesz.com/2013/04/27/explaining-the-unexplainable-part-4/
http://www.depesz.com/2013/04/27/explaining-the-unexplainable-part-5/
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979
gray(dot)ru(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | j. z. | 2014-07-11 13:38:39 | user aggregate with exception handling |
Previous Message | Keith | 2014-07-09 20:33:52 | Re: How to practice on EXPLAIN/optimizing queries/constructing indices |