David Blewett <david@xxxxxxxxxxxxxxxx> writes: > On Thu, May 7, 2009 at 6:44 PM, Tom Lane <tgl@xxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
