Search Postgresql Archives

Re: a JOIN to a VIEW seems slow

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: a JOIN to a VIEW seems slow
From: "Frank Millman" <frank@xxxxxxxxxxxx>
Date: Fri, 22 Sep 2017 07:34:55 +0200
Importance: Normal
In-reply-to: <CAHyXU0zZu27q40RpFCB1oyJH+DsHf3uNXBPYzY=kY5-AqHL8Sg@mail.gmail.com>
References: <1925252F16BF4B0BA1F2AB53F5CD8817@FrankLaptop> <CAHyXU0wQC_vHnpV6=_XcCU73pKeMDXYQVMjtN-t2QRVQeM7V6Q@mail.gmail.com> <393F2F0FE0ED41EAA6553E69B1159B9A@FrankLaptop> <CAHyXU0zZu27q40RpFCB1oyJH+DsHf3uNXBPYzY=kY5-AqHL8Sg@mail.gmail.com>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Re: a JOIN to a VIEW seems slow
  - From: Frank Millman
- Re: a JOIN to a VIEW seems slow
  - From: Merlin Moncure
- Re: a JOIN to a VIEW seems slow
  - From: Frank Millman
- Re: a JOIN to a VIEW seems slow
  - From: Merlin Moncure

Prev by Date: Re: Dynamic use of RAISE with USING to generate and catch non-hardcoded custom exceptions
Next by Date: Question about SELECT statements with subselects
Previous by thread: Re: a JOIN to a VIEW seems slow
Next by thread: Re: a JOIN to a VIEW seems slow
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux