Oscar Camuendo <oscar.dny86@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
