Mercurial > gemma
changeset 5255:256ebbeb1252 new-fwa
Fix FWA performance: match bottleneck validity with measure date.
author | wilde@azure1.rgb.intevation.de |
---|---|
date | Wed, 13 May 2020 11:13:15 +0200 |
parents | 09ec6a748fca |
children | ed62f138528a 680be197844d |
files | pkg/controllers/fwa.go |
diffstat | 1 files changed, 1 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/pkg/controllers/fwa.go Wed May 13 10:39:36 2020 +0200 +++ b/pkg/controllers/fwa.go Wed May 13 11:13:15 2020 +0200 @@ -80,6 +80,7 @@ JOIN waterway.bottlenecks bn ON fa.bottleneck_id = bn.bottleneck_id WHERE + bn.validity @> efa.measure_date AND bn.bottleneck_id = $1 AND efa.level_of_service = $2 AND efa.measure_type = 'Measured' AND