PostgreSQL's Explain Analyze Made Readable

Post by Izkata » Fri, Feb 22, 2019, 6:59 PM UTC

magicalhippo wrote: post #47

Izkata wrote: post #44

Earlier quoted context omitted.

That actually runs the query, so in GP's situation where it isn't returning, that won't either.

At least in my experience, things being slow is almost always due to a table scan rather than using an index. Just the estimates (ie not actually running the query) should give clues as to which table it scans, and the predicates gives hints as to which index would have helped. Not always easy fix though, sometimes what you're asking for just isn't possible to index in a nice way. Just the other day me and a colleagu…