Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Very slow inner join query Unacceptable latency. - Mailing list pgsql-general

From Jaime Casanova
Subject Re: [PERFORM] Very slow inner join query Unacceptable latency.
Date
Msg-id CAJKUy5jjg9OQmkdXPP43p_yimUz+FGpsCUp=B0X9g0XiS=qGrg@mail.gmail.com
Whole thread Raw
In response to Very slow inner join query Unacceptable latency.  (<fburgess@radiantblue.com>)
List pgsql-general
Tree view 
On Tue, May 21, 2013 at 4:53 PM,  <fburgess@radiantblue.com> wrote:
> The SARS_ACTS table currently has 37,115,515 rows
>
> we have indexed: idx_sars_acts_acts_run_id ON SARS_ACTS USING btree
> (sars_run_id)
> we have pk constraint on the SARS_ACTS_RUN table; sars_acts_run_pkey PRIMARY
> KEY (id )
>
> serverdb=# explain select count(*) as y0_ from SARS_ACTS this_ inner join
> SARS_ACTS_RUN tr1_ on this_.SARS_RUN_ID=tr1_.ID where tr1_.ALGORITHM='SMAT';

can you please show us an EXPLAIN ANALYZE of this query (not only
EXPLAIN). please paste it in a file and attach it so it doesn't get
reformatted by the mail client.

what version of postgres is this?

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566         Cell: +593 987171157

pgsql-general by date:

Previous
From:
Date:
Subject: Very slow inner join query Unacceptable latency.
Next
From: John R Pierce
Date:
Subject: Re: [ODBC] ODBC constructs