Oscar Camuendo <oscar(dot)dny86(at)hotmail(dot)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