4 * No.16-1 export_plain_stats-9.2.sql.sample
8 DELETE FROM dbms_stats._column_stats_locked;
9 DELETE FROM dbms_stats._relation_stats_locked;
10 SELECT dbms_stats.lock_database_stats();
11 UPDATE dbms_stats._relation_stats_locked
12 SET (relpages, reltuples, relallvisible, curpages) = (0,0,0,0);
13 UPDATE dbms_stats._column_stats_locked SET
14 stanullfrac = -staattnum,
15 stawidth = -staattnum,
16 stadistinct = -staattnum,
27 stanumbers1 = ARRAY[-staattnum,22],
28 stanumbers2 = ARRAY[-staattnum,23],
29 stanumbers3 = ARRAY[-staattnum,24],
30 stanumbers4 = ARRAY[-staattnum,21],
31 stanumbers5 = ARRAY[-staattnum,25],
32 stavalues1 = stavalues3,
33 stavalues2 = stavalues2,
34 stavalues3 = stavalues1,
35 stavalues4 = stavalues4,
36 stavalues5 = stavalues5;
37 \i export_plain_stats-9.2.sql.sample
38 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
40 TRUNCATE dbms_stats.work;
42 \! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
43 \i export_plain_stats-9.2.sql.sample_test
44 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
46 TRUNCATE dbms_stats.work;
47 \! rm export_plain_stats-9.2.sql.sample_test
49 \! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
50 \i export_plain_stats-9.2.sql.sample_test
51 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
53 TRUNCATE dbms_stats.work;
54 \! rm export_plain_stats-9.2.sql.sample_test
56 \! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
57 \i export_plain_stats-9.2.sql.sample_test
58 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
60 TRUNCATE dbms_stats.work;
61 \! rm export_plain_stats-9.2.sql.sample_test
63 \! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
64 \i export_plain_stats-9.2.sql.sample_test
65 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
67 TRUNCATE dbms_stats.work;
68 \! rm export_plain_stats-9.2.sql.sample_test
70 \! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
71 \i export_plain_stats-9.2.sql.sample_test
72 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
74 TRUNCATE dbms_stats.work;
75 \! rm export_plain_stats-9.2.sql.sample_test
77 \! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
78 \i export_plain_stats-9.2.sql.sample_test
79 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
81 TRUNCATE dbms_stats.work;
82 \! rm export_plain_stats-9.2.sql.sample_test
84 \! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
85 \i export_plain_stats-9.2.sql.sample_test
86 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
88 TRUNCATE dbms_stats.work;
89 \! rm export_plain_stats-9.2.sql.sample_test
91 \! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
92 \i export_plain_stats-9.2.sql.sample_test
93 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
95 TRUNCATE dbms_stats.work;
96 \! rm export_plain_stats-9.2.sql.sample_test
98 \! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
99 \i export_plain_stats-9.2.sql.sample_test
100 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
101 SELECT * FROM work_v;
102 TRUNCATE dbms_stats.work;
103 \! rm export_plain_stats-9.2.sql.sample_test
105 \! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
106 \i export_plain_stats-9.2.sql.sample_test
107 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
108 SELECT * FROM work_v;
109 TRUNCATE dbms_stats.work;
110 \! rm export_plain_stats-9.2.sql.sample_test
113 * No.16-2 export_effective_stats-9.2.sql.sample
117 SELECT dbms_stats.lock_database_stats();
118 UPDATE dbms_stats._relation_stats_locked
119 SET (relpages, reltuples, relallvisible, curpages) = (NULL, NULL, NULL, NULL);
120 UPDATE dbms_stats._column_stats_locked
121 SET (stanullfrac, stawidth, stadistinct,
122 stakind1, stakind2, stakind3, stakind4, stakind5,
123 staop1, staop2, staop3, staop4, staop5,
124 stanumbers1, stanumbers2, stanumbers3, stanumbers4, stanumbers5,
125 stavalues1, stavalues2, stavalues3, stavalues4, stavalues5)
127 NULL, NULL, NULL, NULL, NULL,
128 NULL, NULL, NULL, NULL, NULL,
129 NULL, NULL, NULL, NULL, NULL,
130 NULL, NULL, NULL, NULL, NULL)
131 WHERE starelid = 's0.st0'::regclass;
132 \i export_effective_stats-9.2.sql.sample
133 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
134 SELECT * FROM work_v;
135 TRUNCATE dbms_stats.work;
137 \! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
138 \i export_effective_stats-9.2.sql.sample_test
139 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
140 SELECT * FROM work_v;
141 \! rm export_effective_stats-9.2.sql.sample_test
142 TRUNCATE dbms_stats.work;
144 \! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
145 \i export_effective_stats-9.2.sql.sample_test
146 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
147 SELECT * FROM work_v;
148 \! rm export_effective_stats-9.2.sql.sample_test
149 TRUNCATE dbms_stats.work;
151 \! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
152 \i export_effective_stats-9.2.sql.sample_test
153 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
154 SELECT * FROM work_v;
155 \! rm export_effective_stats-9.2.sql.sample_test
156 TRUNCATE dbms_stats.work;
158 \! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
159 \i export_effective_stats-9.2.sql.sample_test
160 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
161 SELECT * FROM work_v;
162 \! rm export_effective_stats-9.2.sql.sample_test
163 TRUNCATE dbms_stats.work;
165 \! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
166 \i export_effective_stats-9.2.sql.sample_test
167 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
168 SELECT * FROM work_v;
169 \! rm export_effective_stats-9.2.sql.sample_test
170 TRUNCATE dbms_stats.work;
172 \! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
173 \i export_effective_stats-9.2.sql.sample_test
174 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
175 SELECT * FROM work_v;
176 \! rm export_effective_stats-9.2.sql.sample_test
177 TRUNCATE dbms_stats.work;
179 \! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
180 \i export_effective_stats-9.2.sql.sample_test
181 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
182 SELECT * FROM work_v;
183 \! rm export_effective_stats-9.2.sql.sample_test
184 TRUNCATE dbms_stats.work;
186 \! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
187 \i export_effective_stats-9.2.sql.sample_test
188 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
189 SELECT * FROM work_v;
190 \! rm export_effective_stats-9.2.sql.sample_test
191 TRUNCATE dbms_stats.work;
193 \! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
194 \i export_effective_stats-9.2.sql.sample_test
195 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
196 SELECT * FROM work_v;
197 \! rm export_effective_stats-9.2.sql.sample_test
198 TRUNCATE dbms_stats.work;
200 \! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
201 \i export_effective_stats-9.2.sql.sample_test
202 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
203 SELECT * FROM work_v;
204 \! rm export_effective_stats-9.2.sql.sample_test
205 TRUNCATE dbms_stats.work;
208 * Stab function dbms_stats.import
210 ALTER FUNCTION dbms_stats.import(
215 ) RENAME TO truth_import;
216 CREATE FUNCTION dbms_stats.import(
224 RAISE NOTICE 'arguments are "%", "%", "%", "%"', $1, $2, $3, $4;
230 * No.17-1 dbms_stats.import_database_stats(src)
233 SELECT dbms_stats.import_database_stats('@abs_srcdir@/export_stats.dmp');
236 * No.17-2 dbms_stats.import_schema_stats(schemaname, src)
239 SELECT dbms_stats.import_schema_stats('s0', '@abs_srcdir@/export_stats.dmp');
242 * No.17-3 dbms_stats.import_table_stats(relid, src)
245 SELECT dbms_stats.import_table_stats('s0.st0', '@abs_srcdir@/export_stats.dmp');
248 * No.17-4 dbms_stats.import_table_stats(schemaname, tablename, src)
251 SELECT dbms_stats.import_table_stats('s0', 'st0', '@abs_srcdir@/export_stats.dmp');
254 * No.17-5 dbms_stats.import_column_stats (relid, attname, src)
257 SELECT dbms_stats.import_column_stats('s0.st0', 'id', '@abs_srcdir@/export_stats.dmp');
260 * No.17-6 dbms_stats.import_column_stats (schemaname, tablename, attname, src)
263 SELECT dbms_stats.import_column_stats('s0', 'st0', 'id','@abs_srcdir@/export_stats.dmp');
266 * Delete stab function dbms_stats.import
268 DROP FUNCTION dbms_stats.import(
274 ALTER FUNCTION dbms_stats.truth_import(