| blob | 6946b2ec163c75b1e5396b444eb8e15a7c6583fd |
1 VACUUM;
2 --
3 -- sanity check, if we don't have indices the test will take years to
4 -- complete. But skip TOAST relations (since they will have varying
5 -- names depending on the current OID counter) as well as temp tables
6 -- of other backends (to avoid timing-dependent behavior).
7 --
8 SELECT relname, relhasindex
9 FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = relnamespace
10 WHERE relkind = 'r' AND (nspname ~ '^pg_temp_') IS NOT TRUE
11 ORDER BY relname;
12 relname | relhasindex
13 -------------------------+-------------
14 a | f
15 a_star | f
16 abstime_tbl | f
17 aggtest | f
18 array_index_op_test | t
19 array_op_test | f
20 b | f
21 b_star | f
22 box_tbl | f
23 bprime | f
24 bt_f8_heap | t
25 bt_i4_heap | t
26 bt_name_heap | t
27 bt_txt_heap | t
28 c | f
29 c_star | f
30 char_tbl | f
31 check2_tbl | f
32 check_tbl | f
33 circle_tbl | t
34 city | f
35 copy_tbl | f
36 d | f
37 d_star | f
38 date_tbl | f
39 default_tbl | f
40 defaultexpr_tbl | f
41 dept | f
42 e_star | f
43 emp | f
44 equipment_r | f
45 f_star | f
46 fast_emp4000 | t
47 float4_tbl | f
48 float8_tbl | f
49 func_index_heap | t
50 hash_f8_heap | t
51 hash_i4_heap | t
52 hash_name_heap | t
53 hash_txt_heap | t
54 hobbies_r | f
55 ihighway | t
56 inet_tbl | f
57 inhe | f
58 inhf | f
59 inhx | t
60 insert_tbl | f
61 int2_tbl | f
62 int4_tbl | f
63 int8_tbl | f
64 interval_tbl | f
65 iportaltest | f
66 log_table | f
67 lseg_tbl | f
68 main_table | f
69 money_data | f
70 num_data | f
71 num_exp_add | t
72 num_exp_div | t
73 num_exp_ln | t
74 num_exp_log10 | t
75 num_exp_mul | t
76 num_exp_power_10_ln | t
77 num_exp_sqrt | t
78 num_exp_sub | t
79 num_input_test | f
80 num_result | f
81 onek | t
82 onek2 | t
83 path_tbl | f
84 person | f
85 pg_aggregate | t
86 pg_am | t
87 pg_amop | t
88 pg_amproc | t
89 pg_attrdef | t
90 pg_attribute | t
91 pg_auth_members | t
92 pg_authid | t
93 pg_autovacuum | t
94 pg_cast | t
95 pg_class | t
96 pg_constraint | t
97 pg_conversion | t
98 pg_database | t
99 pg_depend | t
100 pg_description | t
101 pg_enum | t
102 pg_index | t
103 pg_inherits | t
104 pg_language | t
105 pg_largeobject | t
106 pg_listener | f
107 pg_namespace | t
108 pg_opclass | t
109 pg_operator | t
110 pg_opfamily | t
111 pg_pltemplate | t
112 pg_proc | t
113 pg_rewrite | t
114 pg_shdepend | t
115 pg_shdescription | t
116 pg_statistic | t
117 pg_tablespace | t
118 pg_trigger | t
119 pg_ts_config | t
120 pg_ts_config_map | t
121 pg_ts_dict | t
122 pg_ts_parser | t
123 pg_ts_template | t
124 pg_type | t
125 point_tbl | f
126 polygon_tbl | t
127 ramp | f
128 real_city | f
129 reltime_tbl | f
130 road | t
131 shighway | t
132 slow_emp4000 | f
133 sql_features | f
134 sql_implementation_info | f
135 sql_languages | f
136 sql_packages | f
137 sql_parts | f
138 sql_sizing | f
139 sql_sizing_profiles | f
140 stud_emp | f
141 student | f
142 tenk1 | t
143 tenk2 | t
144 test_tsvector | f
145 text_tbl | f
146 time_tbl | f
147 timestamp_tbl | f
148 timestamptz_tbl | f
149 timetz_tbl | f
150 tinterval_tbl | f
151 varchar_tbl | f
152 (138 rows)
154 --
155 -- another sanity check: every system catalog that has OIDs should have
156 -- a unique index on OID. This ensures that the OIDs will be unique,
157 -- even after the OID counter wraps around.
158 -- We exclude non-system tables from the check by looking at nspname.
159 --
160 SELECT relname, nspname
161 FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = relnamespace
162 WHERE relhasoids
163 AND ((nspname ~ '^pg_') IS NOT FALSE)
164 AND NOT EXISTS (SELECT 1 FROM pg_index i WHERE indrelid = c.oid
165 AND indkey[0] = -2 AND indnatts = 1 AND indisunique);
166 relname | nspname
167 ---------+---------
168 (0 rows)