Mercurial > gemma

comparison pkg/controllers/fwa.go @ 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 878d52d95e37
children ed62f138528a
comparison
equal deleted inserted replaced
5254:09ec6a748fca 5255:256ebbeb1252
78 JOIN waterway.fairway_availability fa 78 JOIN waterway.fairway_availability fa
79 ON efa.fairway_availability_id = fa.id 79 ON efa.fairway_availability_id = fa.id
80 JOIN waterway.bottlenecks bn 80 JOIN waterway.bottlenecks bn
81 ON fa.bottleneck_id = bn.bottleneck_id 81 ON fa.bottleneck_id = bn.bottleneck_id
82 WHERE 82 WHERE
83 bn.validity @> efa.measure_date AND
83 bn.bottleneck_id = $1 AND 84 bn.bottleneck_id = $1 AND
84 efa.level_of_service = $2 AND 85 efa.level_of_service = $2 AND
85 efa.measure_type = 'Measured' AND 86 efa.measure_type = 'Measured' AND
86 (efa.available_depth_value IS NOT NULL OR 87 (efa.available_depth_value IS NOT NULL OR
87 efa.available_width_value IS NOT NULL) AND 88 efa.available_width_value IS NOT NULL) AND