Home > mailing lists

Re: [GENERAL] a JOIN to a VIEW seems slow - Mailing list pgsql-general

From	Frank Millman
Subject	Re: [GENERAL] a JOIN to a VIEW seems slow
Date	October 2, 2017 12:32:34
Msg-id	0AB90B6E3C9C4A7C82CE4615C048A482@FrankLaptop Whole thread Raw
In response to	[GENERAL] a JOIN to a VIEW seems slow ("Frank Millman" <frank@chagford.com>)
Responses	Re: [GENERAL] a JOIN to a VIEW seems slow (Jan de Visser <jan@de-visser.net>) Re: [GENERAL] a JOIN to a VIEW seems slow (Alban Hertroys <haramrae@gmail.com>)
List	pgsql-general

From: Frank Millman

Sent: Friday, September 22, 2017 7:34 AM

To: pgsql-general@postgresql.org

Subject: Re: a JOIN to a VIEW seems slow

On Fri, Sep 22, 2017 at 7:34 AM, Frank Millman wrote:

>

>

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

>

Just checking – is this under investigation, or is this thread considered closed?

Frank

pgsql-general by date:

Previous

From: Clifford Snow
Date: 02 October 2017, 04:20:28
Subject: Re: [GENERAL] time series data

Next

From: Guyren Howe
Date: 02 October 2017, 20:00:45
Subject: [GENERAL] Setting search_path ignored