Oh, another point of attack. Always test your queries under just \timing. You can wrap up like this:
\timing select count(*) from (subselect goes here); I've been on a few machines where the cost of explain analyze itself threw the timing way off. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general