50 lines
1.5 KiB
SQL
50 lines
1.5 KiB
SQL
|
|
CREATE SCHEMA benchrunner;
|
|
|
|
|
|
CREATE TABLE benchrunner.bench_runs (
|
|
tenant text NOT NULL,
|
|
ts timestamp NOT NULL,
|
|
status text NOT NULL,
|
|
PRIMARY KEY (tenant, ts)
|
|
);
|
|
|
|
|
|
CREATE TABLE benchrunner.bench_metrics_bench1 (
|
|
tenant text NOT NULL,
|
|
ts timestamp NOT NULL,
|
|
prio_fees int8 NOT NULL,
|
|
txs_sent int8 NOT NULL,
|
|
txs_confirmed int8 NOT NULL,
|
|
txs_un_confirmed int8 NOT NULL,
|
|
average_confirmation_time_ms real NOT NULL,
|
|
metric_json jsonb NOT NULL,
|
|
PRIMARY KEY (tenant, ts)
|
|
);
|
|
|
|
|
|
CREATE TABLE benchrunner.bench_metrics_confirmation_rate (
|
|
tenant text NOT NULL,
|
|
ts timestamp NOT NULL,
|
|
prio_fees int8 NOT NULL,
|
|
txs_sent int8 NOT NULL,
|
|
txs_confirmed int8 NOT NULL,
|
|
txs_un_confirmed int8 NOT NULL,
|
|
average_confirmation_time_ms real NOT NULL,
|
|
average_slot_confirmation_time_ms real NOT NULL,
|
|
metric_json jsonb NOT NULL,
|
|
PRIMARY KEY (tenant, ts)
|
|
);
|
|
|
|
|
|
GRANT USAGE ON SCHEMA benchrunner TO r_benchrunner;
|
|
GRANT USAGE ON SCHEMA benchrunner TO ro_benchrunner;
|
|
|
|
GRANT SELECT, INSERT, UPDATE ON ALL TABLES IN SCHEMA benchrunner TO r_benchrunner;
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA benchrunner GRANT SELECT, INSERT, UPDATE ON TABLES TO r_benchrunner;
|
|
|
|
GRANT SELECT ON ALL TABLES IN SCHEMA benchrunner TO ro_benchrunner;
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA benchrunner GRANT SELECT ON TABLES TO ro_benchrunner;
|
|
|
|
ALTER TABLE benchrunner.bench_metrics RENAME TO bench_metrics_bench1;
|