From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
---|---|
To: | Freddie Burgess <fburgess(at)radiantblue(dot)com> |
Cc: | psql performance list <pgsql-performance(at)postgresql(dot)org>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Very slow inner join query Unacceptable latency. |
Date: | 2013-05-21 21:59:56 |
Message-ID: | CAJKUy5jjg9OQmkdXPP43p_yimUz+FGpsCUp=B0X9g0XiS=qGrg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
On Tue, May 21, 2013 at 4:53 PM, <fburgess(at)radiantblue(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2013-05-21 22:17:36 | Re: [ODBC] ODBC constructs |
Previous Message | fburgess | 2013-05-21 21:53:45 | Very slow inner join query Unacceptable latency. |
From | Date | Subject | |
---|---|---|---|
Next Message | Samuel Stearns | 2013-05-21 23:16:58 | Advice on tuning slow query |
Previous Message | fburgess | 2013-05-21 21:53:45 | Very slow inner join query Unacceptable latency. |