Oscar Camuendo <oscar.dny86@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