agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Max Lipsky <maxlipsky@gmail.com>
To: Steve Midgley <science@misuse.org>
Cc: postgres list <pgsql-sql@postgresql.org>
Subject: Re:
Date: Fri, 3 Jun 2016 04:42:49 +0300
Message-ID: <7FBA5CC1-157B-476F-980B-686824D477F6@gmail.com> (raw)
In-Reply-To: <CAJexoSLFee7j5RStaQRTGMkZUpDNZJD3gE51s8=fd-r-N-9zfw@mail.gmail.com>
References: <6C9B51CF-C8D0-416A-986D-AE1615A01909@gmail.com>
<CAJexoSLFee7j5RStaQRTGMkZUpDNZJD3gE51s8=fd-r-N-9zfw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
Sorry, I send broken link
New link >> https://www.dropbox.com/s/8g3tkrikeap89q9/text.zip?dl=0 <https://www.dropbox.com/s/8g3tkrikeap89q9/text.zip?dl=0;
> On 03 Jun 2016, at 03:28, Steve Midgley <science@misuse.org> wrote:
>
> 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@gmail.com <mailto:maxlipsky@gmail.com>> wrote:
> Hi All!
>
> Why is too much difference in time execution between these two queries:
>
>
> SELECT rc.id <http://rc.id/; AS id, rc.name <http://rc.name/;
> FROM realisation_category rc
> WHERE EXISTS (
> SELECT * FROM realisation r, post p WHERE (r.realisation_category_id = rc.id <http://rc.id/; AND r.site_id = 1)
> OR (p.realisation_category_id = rc.id <http://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 <http://rc.id/; AS id, rc.name <http://rc.name/;
> FROM realisation_category rc
> WHERE EXISTS (
> SELECT * FROM realisation r WHERE r.realisation_category_id = rc.id <http://rc.id/; AND r.site_id = 1
> ) OR EXISTS (
> SELECT * FROM post p WHERE p.realisation_category_id = rc.id <http://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@postgresql.org <mailto:pgsql-sql@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql <http://www.postgresql.org/mailpref/pgsql-sql;
>
view thread (5+ messages) latest in thread
Message-ID: <7FBA5CC1-157B-476F-980B-686824D477F6@gmail.com>
Permalink: ../7FBA5CC1-157B-476F-980B-686824D477F6@gmail.com/
Also on: postgresql.org/message-id/7FBA5CC1-157B-476F-980B-686824D477F6@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maxlipsky@gmail.com, science@misuse.org
Subject: Re:
In-Reply-To: <7FBA5CC1-157B-476F-980B-686824D477F6@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox