Re: [PERFORMANCE] Performance index and table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oscar Camuendo <oscar(dot)dny86(at)hotmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORMANCE] Performance index and table
Date: 2016-07-22 14:29:30
Message-ID: 21333.1469197770@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim Nasby 2016-07-23 01:57:07 Re: Seeing execution plan of foreign key constraint check?
Previous Message Oscar Camuendo 2016-07-22 13:34:55 [PERFORMANCE] Performance index and table