David Blewett <david(at)dawninglight(dot)net> writes:
> On Thu, May 7, 2009 at 6:44 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Look into pg_stats for the rows concerning the columns used in the
>> query's WHERE and JOIN/ON clauses.
> Okay, here you go:
> http://rafb.net/p/20y8Oh72.html
I got some time to poke into this, but didn't get very far --- the
joins that seem to be the main problem involve
canvas_textresponse.submission_id which you didn't include stats for.
regards, tom lane