Mercurial > gemma

changeset 5255:256ebbeb1252 new-fwa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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