From 06949d200647db753f0d40c1948ed0c75a2d8b43 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Tue, 6 Oct 2020 12:17:41 +0200 Subject: [PATCH 1/1] added index on pn --- create.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/create.sql b/create.sql index dcc48a6..593cfcc 100644 --- a/create.sql +++ b/create.sql @@ -1,4 +1,4 @@ -drop table zc; +--drop table zc; create table zc ( time timestamp with time zone default now(), PN integer not null, @@ -13,5 +13,7 @@ create table zc ( _id serial ); +create index zc_pn on zc(pn) ; + create user grafana password 'readonly' ; grant select on zc to grafana ; -- 2.20.1