| From: | Keith <keith(at)keithf4(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-09 20:33:52 |
| Message-ID: | CAHw75vsi=suDrGO1CgUsKA8D_nrhYthojcc2+iZ_3frBUyUy9g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Frequent postgresql blogger, depesz, did a great series on understanding
the query planner. It helped me a lot
http://www.depesz.com/?s=explaining+the+unexplainable
On Wed, Jul 9, 2014 at 4: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)?
>
>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2014-07-10 15:13:43 | Re: How to practice on EXPLAIN/optimizing queries/constructing indices |
| Previous Message | Magnus Persson | 2014-07-09 20:24:31 | How to practice on EXPLAIN/optimizing queries/constructing indices |