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

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

 



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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux