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,
97 stavalues1 dbms_stats.anyarray,
98 stavalues2 dbms_stats.anyarray,
99 stavalues3 dbms_stats.anyarray,
100 stavalues4 dbms_stats.anyarray
101 ,stavalues5 dbms_stats.anyarray
103 CREATE VIEW work_v AS
104 SELECT nspname, relname, relpages, reltuples, relallvisible,
105 curpages, attname, nspname_of_typename, typname, atttypmod,
106 stainherit, stanullfrac, stawidth, stadistinct,
107 stakind1, stakind2, stakind3, stakind4, stakind5,
108 staop1, staop2, staop3, staop4, staop5,
109 stanumbers1, stanumbers2, stanumbers3, stanumbers4, stanumbers5,
110 stavalues1, stavalues2, stavalues3, stavalues4, stavalues5
112 ORDER BY nspname, relname, attname, stainherit;