summaryrefslogtreecommitdiff
path: root/maintenance/postgres/archives/patch-profiling.sql
blob: 1c4dce4e28dbe21b2473861fdbb78582ad57f724 (plain)
1
2
3
4
5
6
7
CREATE TABLE profiling (
  pf_count   INTEGER         NOT NULL DEFAULT 0,
  pf_time    NUMERIC(18,10)  NOT NULL DEFAULT 0,
  pf_name    TEXT            NOT NULL,
  pf_server  TEXT            NULL
);
CREATE UNIQUE INDEX pf_name_server ON profiling (pf_name, pf_server);