On Wed, Mar 23, 2011 at 1:12 PM, Josh Berkus <josh@xxxxxxxxxxxx> wrote: > AFAICT, what's happening in this query is that PostgreSQL's statistics > on the device_nodes and several other tables are slightly out of date > (as in 5% of the table). What about some manner of query feedback mechanism ( along the lines of what explain analyze yields ) to track "stats staleness" in general? Probably, I misunderstand the costs of executing explain analyze. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance