1 CREATE VIEW plain_relations_statistic_v AS
6 pg_relation_size(oid) / 8192 curpages
8 ORDER BY oid::regclass::text;
9 CREATE VIEW relations_locked_v AS
10 SELECT relid::regclass,
16 FROM dbms_stats._relation_stats_locked
18 CREATE VIEW relations_backup_v AS
26 FROM dbms_stats.relation_stats_backup
28 CREATE VIEW plain_columns_statistic_v AS
29 SELECT starelid::regclass, staattnum, stainherit,
30 stanullfrac, stawidth, stadistinct,
31 stakind1, stakind2, stakind3, stakind4, stakind5,
32 staop1, staop2, staop3, staop4, staop5,
33 stanumbers1, stanumbers2, stanumbers3, stanumbers4, stanumbers5,
34 stavalues1::text, stavalues2::text, stavalues3::text, stavalues4::text, stavalues5::text
36 ORDER BY starelid, staattnum, stainherit;
37 CREATE VIEW columns_locked_v AS
38 SELECT starelid::regclass, staattnum, attname, stainherit,
39 stanullfrac, stawidth, stadistinct,
40 stakind1, stakind2, stakind3, stakind4, stakind5,
41 staop1, staop2, staop3, staop4, staop5,
42 stanumbers1, stanumbers2, stanumbers3, stanumbers4, stanumbers5,
43 stavalues1, stavalues2, stavalues3, stavalues4, stavalues5
44 FROM dbms_stats._column_stats_locked c
46 ON (c.starelid = a.attrelid AND c.staattnum = a.attnum)
47 ORDER BY starelid, staattnum, stainherit;
48 CREATE VIEW columns_backup_v AS
50 starelid::regclass, staattnum, stainherit,
51 stanullfrac, stawidth, stadistinct,
52 stakind1, stakind2, stakind3, stakind4, stakind5,
53 staop1, staop2, staop3, staop4, staop5,
54 stanumbers1, stanumbers2, stanumbers3, stanumbers4, stanumbers5,
55 stavalues1, stavalues2, stavalues3, stavalues4, stavalues5
56 FROM dbms_stats.column_stats_backup
57 ORDER BY id, starelid, staattnum, stainherit;
58 CREATE TABLE dbms_stats.work (
59 nspname name NOT NULL,
60 relname name NOT NULL,
61 relpages int4 NOT NULL,
62 reltuples float4 NOT NULL,
63 relallvisible int4 NOT NULL,
64 curpages int4 NOT NULL,
65 last_analyze timestamp with time zone,
66 last_autoanalyze timestamp with time zone,
68 nspname_of_typename name,
90 stavalues1 dbms_stats.anyarray,
91 stavalues2 dbms_stats.anyarray,
92 stavalues3 dbms_stats.anyarray,
93 stavalues4 dbms_stats.anyarray
94 ,stavalues5 dbms_stats.anyarray
97 SELECT nspname, relname, relpages, reltuples, relallvisible,
98 curpages, attname, nspname_of_typename, typname, atttypmod,
99 stainherit, stanullfrac, stawidth, stadistinct,
100 stakind1, stakind2, stakind3, stakind4, stakind5,
101 staop1, staop2, staop3, staop4, staop5,
102 stanumbers1, stanumbers2, stanumbers3, stanumbers4, stanumbers5,
103 stavalues1, stavalues2, stavalues3, stavalues4, stavalues5
105 ORDER BY nspname, relname, attname, stainherit;