1 CREATE MATERIALIZED VIEW s0.smv0 AS
8 CREATE VIEW plain_relations_statistic_v AS
13 pg_relation_size(oid) / 8192 curpages
15 ORDER BY oid::regclass::text;
16 CREATE VIEW relations_locked_v AS
17 SELECT relid::regclass,
23 FROM dbms_stats.relation_stats_locked
25 CREATE VIEW relations_backup_v AS
33 FROM dbms_stats.relation_stats_backup
35 CREATE VIEW plain_columns_statistic_v AS
36 SELECT starelid::regclass, staattnum, stainherit,
37 stanullfrac, stawidth, stadistinct,
38 stakind1, stakind2, stakind3, stakind4, stakind5,
39 staop1, staop2, staop3, staop4, staop5,
40 stanumbers1, stanumbers2, stanumbers3, stanumbers4, stanumbers5,
41 stavalues1::text, stavalues2::text, stavalues3::text, stavalues4::text, stavalues5::text
43 ORDER BY starelid, staattnum, stainherit;
44 CREATE VIEW columns_locked_v AS
45 SELECT starelid::regclass, staattnum, attname, stainherit,
46 stanullfrac, stawidth, stadistinct,
47 stakind1, stakind2, stakind3, stakind4, stakind5,
48 staop1, staop2, staop3, staop4, staop5,
49 stanumbers1, stanumbers2, stanumbers3, stanumbers4, stanumbers5,
50 stavalues1, stavalues2, stavalues3, stavalues4, stavalues5
51 FROM dbms_stats.column_stats_locked c
53 ON (c.starelid = a.attrelid AND c.staattnum = a.attnum)
54 ORDER BY starelid, staattnum, stainherit;
55 CREATE VIEW columns_backup_v AS
57 starelid::regclass, staattnum, stainherit,
58 stanullfrac, stawidth, stadistinct,
59 stakind1, stakind2, stakind3, stakind4, stakind5,
60 staop1, staop2, staop3, staop4, staop5,
61 stanumbers1, stanumbers2, stanumbers3, stanumbers4, stanumbers5,
62 stavalues1, stavalues2, stavalues3, stavalues4, stavalues5
63 FROM dbms_stats.column_stats_backup
64 ORDER BY id, starelid, staattnum, stainherit;
65 CREATE TABLE dbms_stats.work (
66 nspname name NOT NULL,
67 relname name NOT NULL,
68 relpages int4 NOT NULL,
69 reltuples float4 NOT NULL,
70 relallvisible int4 NOT NULL,
71 curpages int4 NOT NULL,
72 last_analyze timestamp with time zone,
73 last_autoanalyze timestamp with time zone,
75 nspname_of_typename name,
100 stanumbers4 float4[],
101 stanumbers5 float4[],
102 stavalues1 dbms_stats.anyarray,
103 stavalues2 dbms_stats.anyarray,
104 stavalues3 dbms_stats.anyarray,
105 stavalues4 dbms_stats.anyarray
106 ,stavalues5 dbms_stats.anyarray
107 ) WITH (autovacuum_enabled = 'false');
108 CREATE VIEW work_v AS
109 SELECT nspname, relname, relpages, reltuples, relallvisible,
110 curpages, attname, nspname_of_typename, typname, atttypmod,
111 stainherit, stanullfrac, stawidth, stadistinct,
112 stakind1, stakind2, stakind3, stakind4, stakind5,
113 staop1, staop2, staop3, staop4, staop5,
114 stanumbers1, stanumbers2, stanumbers3, stanumbers4, stanumbers5,
115 stavalues1, stavalues2, stavalues3, stavalues4, stavalues5
117 ORDER BY nspname, relname, attname, stainherit;