CREATE TABLE IF NOT EXISTS pgss_prev_1m (
    dbid OID,
    userid OID,
    queryid BIGINT,
    query TEXT,
    calls BIGINT,
    total_exec_time DOUBLE PRECISION,
    PRIMARY KEY (dbid, userid, queryid)
);

CREATE TABLE IF NOT EXISTS pgss_prev_5m (
    dbid OID,
    userid OID,
    queryid BIGINT,
    query TEXT,
    calls BIGINT,
    total_exec_time DOUBLE PRECISION,
    PRIMARY KEY (dbid, userid, queryid)
);

CREATE TABLE IF NOT EXISTS pgss_prev_15m (
    dbid OID,
    userid OID,
    queryid BIGINT,
    query TEXT,
    calls BIGINT,
    total_exec_time DOUBLE PRECISION,
    PRIMARY KEY (dbid, userid, queryid)
);

CREATE TABLE IF NOT EXISTS pgss_prev_1h (
    dbid OID,
    userid OID,
    queryid BIGINT,
    query TEXT,
    calls BIGINT,
    total_exec_time DOUBLE PRECISION,
    PRIMARY KEY (dbid, userid, queryid)
);
CREATE TABLE IF NOT EXISTS pgss_cur_1m (
    query TEXT,
    delta_calls BIGINT,
    delta_time DOUBLE PRECISION,
    avg_time NUMERIC(10, 3)
);

CREATE TABLE IF NOT EXISTS pgss_cur_5m (
    query TEXT,
    delta_calls BIGINT,
    delta_time DOUBLE PRECISION,
    avg_time NUMERIC(10, 3)
);

CREATE TABLE IF NOT EXISTS pgss_cur_15m (
    query TEXT,
    delta_calls BIGINT,
    delta_time DOUBLE PRECISION,
    avg_time NUMERIC(10, 3)
);

CREATE TABLE IF NOT EXISTS pgss_cur_1h (
    query TEXT,
    delta_calls BIGINT,
    delta_time DOUBLE PRECISION,
    avg_time NUMERIC(10, 3)
);