Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: A Guy Named Ryan <aguynamedryan(at)gmail(dot)com>
Cc: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query
Date: 2020-05-18 19:17:59
Message-ID: CAFj8pRCEXjXoxDVXAqNE2qqkEHWM+=ZWHg9qo=soJf0vbK9Y3w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi

It looks so in slow plan is some strange relations between subselects - the
slow plan looks like plan for correlated subquery, and it should be slow.

Minimally you miss a index on column

jtemp1c37l3b_baseline_windows_after_inclusion.uuid

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message A Guy Named Ryan 2020-05-18 20:49:39 Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query
Previous Message A Guy Named Ryan 2020-05-18 18:42:09 Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query