Re:

From: Steve Midgley <science(at)misuse(dot)org>
To: Max Lipsky <maxlipsky(at)gmail(dot)com>
Cc: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: Re:
Date: 2016-06-03 00:28:05
Message-ID: CAJexoSLFee7j5RStaQRTGMkZUpDNZJD3gE51s8=fd-r-N-9zfw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

In order to answer questions like that, generally, it's super helpful if
you will include the "EXPLAIN" output for the query. It may also be useful
to share some simple DDL stuff so we can create the tables and data you're
using and try it out on our end.

In this specific case (without digging too much into this, and without the
info above) I'd guess there's an index missing and probably on the field "
realisation_category_id"

Steve

On Thu, Jun 2, 2016 at 2:31 PM, Max Lipsky <maxlipsky(at)gmail(dot)com> wrote:

> Hi All!
>
> Why is too much difference in time execution between these two queries:
>
>
> SELECT rc.id AS id, rc.name
> FROM realisation_category rc
> WHERE EXISTS (
> SELECT * FROM realisation r, post p WHERE (r.realisation_category_id =
> rc.id AND r.site_id = 1)
> OR (p.realisation_category_id = rc.id AND p.site_id = 1)
> )
> [2016-06-03 01:23:12] 35 row(s) retrieved starting from 1 in 14s 591ms
> (14s 612ms total)
>
>
>
> SELECT rc.id AS id, rc.name
> FROM realisation_category rc
> WHERE EXISTS (
> SELECT * FROM realisation r WHERE r.realisation_category_id = rc.id
> AND r.site_id = 1
> ) OR EXISTS (
> SELECT * FROM post p WHERE p.realisation_category_id = rc.id AND
> p.site_id = 1
> )
> [2016-06-03 01:25:25] 35 row(s) retrieved starting from 1 in 64ms (86ms
> total)
>
> Thanks
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://stream.boxwatch.ru/mailpref/pgsql-sql
>

In response to

  • at 2016-06-02 21:31:17 from Max Lipsky

Responses

  • Re: at 2016-06-03 01:24:53 from Max Lipsky
  • Re: at 2016-06-03 01:42:49 from Max Lipsky

Browse pgsql-sql by date

  From Date Subject
Next Message Max Lipsky 2016-06-03 01:24:53 Re:
Previous Message Max Lipsky 2016-06-02 21:31:17