1 CREATE VIEW plain_relations_statistic_v AS
5 pg_relation_size(oid) / 8192 curpages
7 ORDER BY oid::regclass::text;
8 CREATE VIEW relations_locked_v AS
9 SELECT relid::regclass,
14 FROM dbms_stats._relation_stats_locked
16 CREATE VIEW relations_backup_v AS
23 FROM dbms_stats.relation_stats_backup
25 CREATE VIEW plain_columns_statistic_v AS
26 SELECT starelid::regclass, staattnum, stainherit,
27 stanullfrac, stawidth, stadistinct,
28 stakind1, stakind2, stakind3, stakind4,
29 staop1, staop2, staop3, staop4,
30 stanumbers1, stanumbers2, stanumbers3, stanumbers4,
31 stavalues1::text, stavalues2::text, stavalues3::text, stavalues4::text
33 ORDER BY starelid, staattnum, stainherit;
34 CREATE VIEW columns_locked_v AS
35 SELECT starelid::regclass, staattnum, attname, stainherit,
36 stanullfrac, stawidth, stadistinct,
37 stakind1, stakind2, stakind3, stakind4,
38 staop1, staop2, staop3, staop4,
39 stanumbers1, stanumbers2, stanumbers3, stanumbers4,
40 stavalues1, stavalues2, stavalues3, stavalues4
41 FROM dbms_stats._column_stats_locked c
43 ON (c.starelid = a.attrelid AND c.staattnum = a.attnum)
44 ORDER BY starelid, staattnum, stainherit;
45 CREATE VIEW columns_backup_v AS
47 starelid::regclass, staattnum, stainherit,
48 stanullfrac, stawidth, stadistinct,
49 stakind1, stakind2, stakind3, stakind4,
50 staop1, staop2, staop3, staop4,
51 stanumbers1, stanumbers2, stanumbers3, stanumbers4,
52 stavalues1, stavalues2, stavalues3, stavalues4
53 FROM dbms_stats.column_stats_backup
54 ORDER BY id, starelid, staattnum, stainherit;
55 CREATE TABLE dbms_stats.work (
56 nspname name NOT NULL,
57 relname name NOT NULL,
58 relpages int4 NOT NULL,
59 reltuples float4 NOT NULL,
60 curpages int4 NOT NULL,
61 last_analyze timestamp with time zone,
62 last_autoanalyze timestamp with time zone,
64 nspname_of_typename name,
83 stavalues1 dbms_stats.anyarray,
84 stavalues2 dbms_stats.anyarray,
85 stavalues3 dbms_stats.anyarray,
86 stavalues4 dbms_stats.anyarray
89 SELECT nspname, relname, relpages, reltuples,
90 curpages, attname, nspname_of_typename, typname, atttypmod,
91 stainherit, stanullfrac, stawidth, stadistinct,
92 stakind1, stakind2, stakind3, stakind4,
93 staop1, staop2, staop3, staop4,
94 stanumbers1, stanumbers2, stanumbers3, stanumbers4,
95 stavalues1, stavalues2, stavalues3, stavalues4
97 ORDER BY nspname, relname, attname, stainherit;