Oscar Camuendo <oscar.dn...@hotmail.com> writes: > I'm working on Postgresql 9.5.3 and executed a query which takes 5 or 7 > seconds and it should not take more than 0.30 milliseconds, the query is:
Have you ANALYZEd your tables lately? Some of these estimated row counts seem awfully far off for no very good reason. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance