Re: a JOIN to a VIEW seems slow

From: "Frank Millman" <frank(at)chagford(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: a JOIN to a VIEW seems slow
Date: 2017-09-22 05:34:55
Message-ID: 12793B74FBAA448C9F62B8D4CCCA895C@FrankLaptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Thu, Sep 21, 2017 at 3:54 PM, Merlin Moncure wrote:

> Something is not adding up here. Can you EXPLAIN ANALYZE the 26 minute
> query?

Here it is -

https://explain.depesz.com/s/cwm

Frank

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Miloslav Semler 2017-09-22 06:03:02 Question about SELECT statements with subselects
Previous Message Pavel Stehule 2017-09-22 05:09:50 Re: Dynamic use of RAISE with USING to generate and catch non-hardcoded custom exceptions