Mercurial > gemma
changeset 4006:3dc2694557f1
Speed up time based filtering of gauge measurements and predictions
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 18 Jul 2019 19:57:10 +0200 |
parents | 5c7e797347a3 |
children | 74ae9be9dc69 |
files | schema/gemma.sql schema/updates/1003/01.add-indexes.sql schema/version.sql |
diffstat | 3 files changed, 10 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Thu Jul 18 19:49:56 2019 +0200 +++ b/schema/gemma.sql Thu Jul 18 19:57:10 2019 +0200 @@ -479,6 +479,8 @@ staging_done boolean NOT NULL DEFAULT false, UNIQUE (location, measure_date, staging_done) ) + CREATE INDEX gauge_measurements_measure_date + ON waterway.gauge_measurements (measure_date) CREATE TABLE gauge_predictions ( location isrs NOT NULL, @@ -500,6 +502,8 @@ source_organization varchar NOT NULL, -- "originator" from NtS response PRIMARY KEY (location, measure_date, date_issue) ) + CREATE INDEX gauge_predictions_measure_date + ON waterway.gauge_predictions (measure_date) CREATE TABLE waterway_axis ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/schema/updates/1003/01.add-indexes.sql Thu Jul 18 19:57:10 2019 +0200 @@ -0,0 +1,5 @@ +CREATE INDEX gauge_measurements_measure_date + ON waterway.gauge_measurements (measure_date); + +CREATE INDEX gauge_predictions_measure_date + ON waterway.gauge_predictions (measure_date)