3 * No.2-1 table definitions.
6 \d dbms_stats.backup_history
8 \d dbms_stats.column_stats_backup
10 \d dbms_stats._column_stats_locked
12 \d dbms_stats.relation_stats_backup
14 \d dbms_stats._relation_stats_locked
17 * No.2-2 view definitions.
20 \dS+ dbms_stats.column_stats_effective
22 \dS+ dbms_stats.relation_stats_effective
26 \dS+ dbms_stats.column_stats_locked
28 \dS+ dbms_stats.relation_stats_locked
31 * No.2-4 dbms_stats.anyarray
34 SELECT n.nspname, t.typname, t.typlen, t.typbyval, t.typtype,
35 t.typcategory, t.typispreferred, t.typisdefined, t.typdelim,
36 t.typrelid, t.typelem, t.typinput, t.typoutput, t.typreceive,
37 t.typsend, t.typmodin, t.typmodout, t.typanalyze, t.typalign,
38 t.typstorage, t.typnotnull, t.typbasetype, t.typtypmod, t.typndims,
39 t.typcollation, t.typdefaultbin, t.typdefault, t.typacl
40 FROM pg_type t, pg_namespace n
41 WHERE t.typnamespace = n.oid
42 AND n.nspname = 'dbms_stats'
43 AND t.typname = 'anyarray';
46 * No.5-1 dbms_stats.merge
48 UPDATE pg_statistic SET
49 stanullfrac = staattnum,
51 stadistinct = staattnum,
62 stanumbers1 = ARRAY[staattnum,4],
63 stanumbers2 = ARRAY[staattnum,1],
64 stanumbers3 = ARRAY[staattnum,2],
65 stanumbers4 = ARRAY[staattnum,3],
66 stanumbers5 = ARRAY[staattnum,5],
67 stavalues2 = array_cat(stavalues1,stavalues1),
68 stavalues3 = array_cat(array_cat(stavalues1,stavalues1),stavalues1),
69 stavalues4 = array_cat(array_cat(array_cat(stavalues1,stavalues1),stavalues1),stavalues1)
70 ,stavalues5 = array_cat(array_cat(array_cat(array_cat(stavalues1,stavalues1),stavalues1),stavalues1),stavalues1)
71 WHERE starelid = 'st0'::regclass;
72 SELECT dbms_stats.lock_table_stats('st0');
73 UPDATE dbms_stats._column_stats_locked SET
75 stanullfrac = -staattnum,
76 stawidth = -staattnum,
77 stadistinct = -staattnum,
88 stanumbers1 = ARRAY[-staattnum,22],
89 stanumbers2 = ARRAY[-staattnum,23],
90 stanumbers3 = ARRAY[-staattnum,24],
91 stanumbers4 = ARRAY[-staattnum,21],
92 stanumbers5 = ARRAY[-staattnum,25],
93 stavalues1 = stavalues3,
94 stavalues2 = stavalues2,
95 stavalues3 = stavalues1,
96 stavalues4 = stavalues4
97 ,stavalues5 = stavalues5
101 * Driver function dbms_stats.merge1
103 CREATE FUNCTION dbms_stats.merge1(
104 lhs dbms_stats._column_stats_locked,
105 rhs pg_catalog.pg_statistic
107 '$libdir/pg_dbms_stats', 'dbms_stats_merge'
110 SELECT * FROM columns_locked_v
111 WHERE starelid = 'st0'::regclass;
112 SELECT * FROM plain_columns_statistic_v
113 WHERE starelid = 'st0'::regclass;
115 SET client_min_messages TO LOG;
118 SELECT (m.merge).starelid::regclass,
120 (m.merge).stainherit,
121 (m.merge).stanullfrac,
123 (m.merge).stadistinct,
134 (m.merge).stanumbers1,
135 (m.merge).stanumbers2,
136 (m.merge).stanumbers3,
137 (m.merge).stanumbers4,
138 (m.merge).stanumbers5,
139 (m.merge).stavalues1,
140 (m.merge).stavalues2,
141 (m.merge).stavalues3,
143 ,(m.merge).stavalues5
144 FROM (SELECT dbms_stats.merge(NULL, s)
146 WHERE starelid = 'st0'::regclass
147 AND staattnum = '1'::int2) m;
150 SELECT (m.merge).starelid::regclass,
152 (m.merge).stainherit,
153 (m.merge).stanullfrac,
155 (m.merge).stadistinct,
166 (m.merge).stanumbers1,
167 (m.merge).stanumbers2,
168 (m.merge).stanumbers3,
169 (m.merge).stanumbers4,
170 (m.merge).stanumbers5,
171 (m.merge).stavalues1,
172 (m.merge).stavalues2,
173 (m.merge).stavalues3,
175 ,(m.merge).stavalues5
176 FROM (SELECT dbms_stats.merge(v, NULL)
177 FROM dbms_stats._column_stats_locked v
178 WHERE starelid = 'st0'::regclass
179 AND staattnum = '2'::int2) m;
182 SELECT dbms_stats.merge(NULL, NULL);
185 SELECT (m.merge).starelid::regclass,
187 (m.merge).stainherit,
188 (m.merge).stanullfrac,
190 (m.merge).stadistinct,
201 (m.merge).stanumbers1,
202 (m.merge).stanumbers2,
203 (m.merge).stanumbers3,
204 (m.merge).stanumbers4,
205 (m.merge).stanumbers5,
206 (m.merge).stavalues1,
207 (m.merge).stavalues2,
208 (m.merge).stavalues3,
210 ,(m.merge).stavalues5
211 FROM (SELECT dbms_stats.merge(v, s)
212 FROM dbms_stats._column_stats_locked v,
214 WHERE v.starelid = 'st0'::regclass
215 AND v.staattnum = '2'::int2
216 AND s.starelid = 'st0'::regclass
217 AND s.staattnum = '1'::int2) m;
220 SELECT (m.merge).starelid::regclass,
222 (m.merge).stainherit,
223 (m.merge).stanullfrac,
225 (m.merge).stadistinct,
236 (m.merge).stanumbers1,
237 (m.merge).stanumbers2,
238 (m.merge).stanumbers3,
239 (m.merge).stanumbers4,
240 (m.merge).stanumbers5,
241 (m.merge).stavalues1,
242 (m.merge).stavalues2,
243 (m.merge).stavalues3,
245 ,(m.merge).stavalues5
246 FROM (SELECT dbms_stats.merge(v, s)
247 FROM dbms_stats._column_stats_locked v,
249 WHERE v.starelid = 'st0'::regclass
250 AND v.staattnum = '2'::int2
251 AND s.starelid = 'st0'::regclass
252 AND s.staattnum = '1'::int2) m;
255 SELECT dbms_stats.merge1(v, s)
256 FROM dbms_stats._column_stats_locked v,
258 WHERE v.starelid = 'st0'::regclass
259 AND v.staattnum = '2'::int2
260 AND s.starelid = 'st0'::regclass
261 AND s.staattnum = '1'::int2;
264 SELECT dbms_stats.merge(NULL, (
265 s.starelid::regclass, s.staattnum, s.stainherit,
266 s.stanullfrac, s.stawidth, s.stadistinct,
267 s.stakind1, s.stakind2, s.stakind3, s.stakind4,
269 s.staop1, s.staop2, s.staop3,
271 NULL, s.stanumbers1, s.stanumbers2, s.stanumbers3, s.stanumbers4,
273 s.stavalues1, s.stavalues2, s.stavalues3, s.stavalues4
277 WHERE s.starelid = 'st0'::regclass
278 AND s.staattnum = '1'::int2;
281 SELECT (m.merge).starelid::regclass,
283 (m.merge).stainherit,
284 (m.merge).stanullfrac,
286 (m.merge).stadistinct,
297 (m.merge).stanumbers1,
298 (m.merge).stanumbers2,
299 (m.merge).stanumbers3,
300 (m.merge).stanumbers4,
301 (m.merge).stanumbers5,
302 (m.merge).stavalues1,
303 (m.merge).stavalues2,
304 (m.merge).stavalues3,
306 ,(m.merge).stavalues5
307 FROM (SELECT dbms_stats.merge(NULL, (
308 s.starelid::regclass, s.staattnum, s.stainherit,
309 s.stanullfrac, s.stawidth, s.stadistinct,
310 s.stakind1, s.stakind2, s.stakind3, s.stakind4,
312 s.staop1, s.staop2, s.staop3, s.staop4,
314 NULL, s.stanumbers2, s.stanumbers3, s.stanumbers4,
316 s.stavalues1, s.stavalues2, s.stavalues3, s.stavalues4
320 WHERE s.starelid = 'st0'::regclass
321 AND s.staattnum = '1'::int2) m;
324 SELECT dbms_stats.merge((
325 v.starelid::regclass, v.staattnum, v.stainherit,
326 v.stanullfrac, v.stawidth, v.stadistinct,
327 v.stakind1, v.stakind2, v.stakind3, v.stakind4,
329 v.staop1, v.staop2, v.staop3,
331 NULL, v.stanumbers1, v.stanumbers2, v.stanumbers3, v.stanumbers4,
333 v.stavalues1, v.stavalues2, v.stavalues3, v.stavalues4
336 FROM dbms_stats._column_stats_locked v
337 WHERE v.starelid = 'st0'::regclass
338 AND v.staattnum = '2'::int2;
341 SELECT (m.merge).starelid::regclass,
343 (m.merge).stainherit,
344 (m.merge).stanullfrac,
346 (m.merge).stadistinct,
357 (m.merge).stanumbers1,
358 (m.merge).stanumbers2,
359 (m.merge).stanumbers3,
360 (m.merge).stanumbers4,
361 (m.merge).stanumbers5,
362 (m.merge).stavalues1,
363 (m.merge).stavalues2,
364 (m.merge).stavalues3,
366 ,(m.merge).stavalues5
367 FROM (SELECT dbms_stats.merge((
368 v.starelid::regclass, v.staattnum, v.stainherit,
369 v.stanullfrac, v.stawidth, v.stadistinct,
370 v.stakind1, v.stakind2, v.stakind3, v.stakind4,
372 v.staop1, v.staop2, v.staop3, v.staop4,
374 NULL, v.stanumbers2, v.stanumbers3, v.stanumbers4,
376 v.stavalues1, v.stavalues2, v.stavalues3, v.stavalues4
379 FROM dbms_stats._column_stats_locked v
380 WHERE v.starelid = 'st0'::regclass
381 AND v.staattnum = '2'::int2) m;
384 SELECT dbms_stats.merge((
385 v.starelid::regclass, v.staattnum, v.stainherit,
386 v.stanullfrac, v.stawidth, v.stadistinct,
387 v.stakind1, v.stakind2, v.stakind3, v.stakind4,
389 v.staop1, v.staop2, v.staop3,
391 NULL, v.stanumbers1, v.stanumbers2, v.stanumbers3, v.stanumbers4,
393 v.stavalues1, v.stavalues2, v.stavalues3, v.stavalues4
396 s.starelid::regclass, s.staattnum, s.stainherit,
397 s.stanullfrac, s.stawidth, s.stadistinct,
398 s.stakind1, s.stakind2, s.stakind3, s.stakind4,
400 s.staop1, s.staop2, s.staop3,
402 NULL, s.stanumbers1, s.stanumbers2, s.stanumbers3, s.stanumbers4,
404 s.stavalues1, s.stavalues2, s.stavalues3, s.stavalues4
407 FROM dbms_stats._column_stats_locked v,
409 WHERE v.starelid = 'st0'::regclass
410 AND v.staattnum = '2'::int2
411 AND s.starelid = 'st0'::regclass
412 AND s.staattnum = '1'::int2;
415 SELECT (m.merge).starelid::regclass,
417 (m.merge).stainherit,
418 (m.merge).stanullfrac,
420 (m.merge).stadistinct,
431 (m.merge).stanumbers1,
432 (m.merge).stanumbers2,
433 (m.merge).stanumbers3,
434 (m.merge).stanumbers4,
435 (m.merge).stanumbers5,
436 (m.merge).stavalues1,
437 (m.merge).stavalues2,
438 (m.merge).stavalues3,
440 ,(m.merge).stavalues5
441 FROM (SELECT dbms_stats.merge((
442 v.starelid::regclass, v.staattnum, v.stainherit,
443 v.stanullfrac, v.stawidth, v.stadistinct,
444 v.stakind1, v.stakind2, v.stakind3, v.stakind4,
446 v.staop1, v.staop2, v.staop3, v.staop4,
448 NULL, v.stanumbers2, v.stanumbers3, v.stanumbers4,
450 v.stavalues1, v.stavalues2, v.stavalues3, v.stavalues4
453 s.starelid::regclass, s.staattnum, s.stainherit,
454 s.stanullfrac, s.stawidth, s.stadistinct,
455 s.stakind1, s.stakind2, s.stakind3, s.stakind4,
457 s.staop1, s.staop2, s.staop3, s.staop4,
459 NULL, s.stanumbers2, s.stanumbers3, s.stanumbers4,
461 s.stavalues1, s.stavalues2, s.stavalues3, s.stavalues4
464 FROM dbms_stats._column_stats_locked v,
466 WHERE v.starelid = 'st0'::regclass
467 AND v.staattnum = '2'::int2
468 AND s.starelid = 'st0'::regclass
469 AND s.staattnum = '1'::int2) m;
472 SELECT (m.merge).starelid::regclass,
474 (m.merge).stainherit,
475 (m.merge).stanullfrac,
477 (m.merge).stadistinct,
488 (m.merge).stanumbers1,
489 (m.merge).stanumbers2,
490 (m.merge).stanumbers3,
491 (m.merge).stanumbers4,
492 (m.merge).stanumbers5,
493 (m.merge).stavalues1,
494 (m.merge).stavalues2,
495 (m.merge).stavalues3,
497 ,(m.merge).stavalues5
498 FROM (SELECT dbms_stats.merge((
501 NULL, NULL, NULL, NULL,
502 NULL, NULL, NULL, NULL,
503 NULL, NULL, NULL, NULL,
504 NULL, NULL, NULL, NULL
505 ,NULL, NULL, NULL, NULL
508 WHERE s.starelid = 'st0'::regclass
509 AND s.staattnum = '1'::int2) m;
512 SELECT (m.merge).starelid::regclass,
514 (m.merge).stainherit,
515 (m.merge).stanullfrac,
517 (m.merge).stadistinct,
528 (m.merge).stanumbers1,
529 (m.merge).stanumbers2,
530 (m.merge).stanumbers3,
531 (m.merge).stanumbers4,
532 (m.merge).stanumbers5,
533 (m.merge).stavalues1,
534 (m.merge).stavalues2,
535 (m.merge).stavalues3,
537 ,(m.merge).stavalues5
538 FROM (SELECT dbms_stats.merge(v, (
541 NULL, NULL, NULL, NULL,
542 NULL, NULL, NULL, NULL,
543 NULL, NULL, NULL, NULL,
544 NULL, NULL, NULL, NULL,
545 NULL, NULL, NULL, NULL))
546 FROM dbms_stats._column_stats_locked v
547 WHERE v.starelid = 'st0'::regclass
548 AND v.staattnum = '2'::int2) m;
551 SELECT (m.merge).starelid::regclass,
553 (m.merge).stainherit,
554 (m.merge).stanullfrac,
556 (m.merge).stadistinct,
567 (m.merge).stanumbers1,
568 (m.merge).stanumbers2,
569 (m.merge).stanumbers3,
570 (m.merge).stanumbers4,
571 (m.merge).stanumbers5,
572 (m.merge).stavalues1,
573 (m.merge).stavalues2,
574 (m.merge).stavalues3,
576 ,(m.merge).stavalues5
577 FROM (SELECT dbms_stats.merge(v, s)
578 FROM dbms_stats._column_stats_locked v,
580 WHERE v.starelid = 'st0'::regclass
581 AND v.staattnum = '2'::int2
582 AND s.starelid = 'st0'::regclass
583 AND s.staattnum = '1'::int2) m;
586 SELECT dbms_stats.merge((
587 v.starelid::regclass, v.staattnum, v.stainherit,
588 v.stanullfrac, v.stawidth, v.stadistinct,
589 NULL, NULL, NULL, NULL,
590 NULL, NULL, NULL, NULL,
591 NULL, NULL, NULL, NULL,
592 NULL, NULL, NULL, NULL
593 ,NULL, NULL, NULL, NULL
595 s.starelid::regclass, s.staattnum, s.stainherit,
596 s.stanullfrac, s.stawidth, s.stadistinct,
597 NULL, NULL, NULL, NULL,
598 NULL, NULL, NULL, NULL,
599 NULL, NULL, NULL, NULL,
600 NULL, NULL, NULL, NULL,
601 NULL, NULL, NULL, NULL))
602 FROM dbms_stats._column_stats_locked v,
604 WHERE v.starelid = 'st0'::regclass
605 AND v.staattnum = '2'::int2
606 AND s.starelid = 'st0'::regclass
607 AND s.staattnum = '1'::int2;
610 SELECT (m.merge).starelid::regclass,
612 (m.merge).stainherit,
613 (m.merge).stanullfrac,
615 (m.merge).stadistinct,
626 (m.merge).stanumbers1,
627 (m.merge).stanumbers2,
628 (m.merge).stanumbers3,
629 (m.merge).stanumbers4,
630 (m.merge).stanumbers5,
631 (m.merge).stavalues1,
632 (m.merge).stavalues2,
633 (m.merge).stavalues3,
635 ,(m.merge).stavalues5
636 FROM (SELECT dbms_stats.merge((
637 v.starelid::regclass, v.staattnum, v.stainherit,
638 v.stanullfrac, v.stawidth, v.stadistinct,
639 v.stakind1, v.stakind2, v.stakind3, v.stakind4,
641 v.staop1, v.staop2, v.staop3,
643 NULL, v.stanumbers1, v.stanumbers2, v.stanumbers3, v.stanumbers4,
645 v.stavalues1, v.stavalues2, v.stavalues3, v.stavalues4
648 s.starelid::regclass, s.staattnum, s.stainherit,
649 s.stanullfrac, s.stawidth, s.stadistinct,
650 s.stakind1, s.stakind2, s.stakind3, s.stakind4,
652 s.staop1, s.staop2, s.staop3, s.staop4,
654 s.stanumbers1, s.stanumbers2, s.stanumbers3, s.stanumbers4,
656 s.stavalues1, s.stavalues2, s.stavalues3, s.stavalues4
659 FROM dbms_stats._column_stats_locked v,
661 WHERE v.starelid = 'st0'::regclass
662 AND v.staattnum = '1'::int2
663 AND s.starelid = 'st0'::regclass
664 AND s.staattnum = '1'::int2) m;
667 SELECT dbms_stats.merge((
668 v.starelid::regclass, v.staattnum, v.stainherit,
669 v.stanullfrac, v.stawidth, v.stadistinct,
670 v.stakind1, v.stakind2, v.stakind3, v.stakind4,
672 v.staop1, v.staop2, v.staop3,
674 NULL, v.stanumbers1, v.stanumbers2, v.stanumbers3, v.stanumbers4,
676 v.stavalues1, v.stavalues2, v.stavalues3, v.stavalues4
679 s.starelid::regclass, s.staattnum, s.stainherit,
680 s.stanullfrac, s.stawidth, s.stadistinct,
681 s.stakind1, s.stakind2, s.stakind3, s.stakind4,
683 s.staop1, s.staop2, s.staop3,
685 NULL, s.stanumbers1, s.stanumbers2, s.stanumbers3, s.stanumbers4,
687 s.stavalues1, s.stavalues2, s.stavalues3, s.stavalues4
690 FROM dbms_stats._column_stats_locked v,
692 WHERE v.starelid = 'st0'::regclass
693 AND v.staattnum = '1'::int2
694 AND s.starelid = 'st0'::regclass
695 AND s.staattnum = '1'::int2;
698 SELECT (m.merge).starelid::regclass,
700 (m.merge).stainherit,
701 (m.merge).stanullfrac,
703 (m.merge).stadistinct,
714 (m.merge).stanumbers1,
715 (m.merge).stanumbers2,
716 (m.merge).stanumbers3,
717 (m.merge).stanumbers4,
718 (m.merge).stanumbers5,
719 (m.merge).stavalues1,
720 (m.merge).stavalues2,
721 (m.merge).stavalues3,
723 ,(m.merge).stavalues5
724 FROM (SELECT dbms_stats.merge((
725 v.starelid::regclass, v.staattnum, v.stainherit,
726 v.stanullfrac, v.stawidth, v.stadistinct,
729 v.staop1, v.staop2, v.staop3, v.staop4,
731 v.stanumbers1, v.stanumbers2, v.stanumbers3, v.stanumbers4,
733 v.stavalues1, v.stavalues2, v.stavalues3, v.stavalues4
736 s.starelid::regclass, s.staattnum, s.stainherit,
737 s.stanullfrac, s.stawidth, s.stadistinct,
740 s.staop1, s.staop2, s.staop3, s.staop4,
742 s.stanumbers1, s.stanumbers2, s.stanumbers3, s.stanumbers4,
744 s.stavalues1, s.stavalues2, s.stavalues3, s.stavalues4
747 FROM dbms_stats._column_stats_locked v,
749 WHERE v.starelid = 'st0'::regclass
750 AND v.staattnum = '2'::int2
751 AND s.starelid = 'st0'::regclass
752 AND s.staattnum = '1'::int2) m;
755 SELECT (m.merge).starelid::regclass,
757 (m.merge).stainherit,
758 (m.merge).stanullfrac,
760 (m.merge).stadistinct,
771 (m.merge).stanumbers1,
772 (m.merge).stanumbers2,
773 (m.merge).stanumbers3,
774 (m.merge).stanumbers4,
775 (m.merge).stanumbers5,
776 (m.merge).stavalues1,
777 (m.merge).stavalues2,
778 (m.merge).stavalues3,
780 ,(m.merge).stavalues5
781 FROM (SELECT dbms_stats.merge((v.starelid::regclass, v.staattnum, v.stainherit,
782 v.stanullfrac, v.stawidth, v.stadistinct,
785 v.staop1, v.staop2, v.staop3, v.staop4,
787 v.stanumbers1, v.stanumbers2, v.stanumbers3, v.stanumbers4,
789 v.stavalues1, v.stavalues2, v.stavalues3, v.stavalues4
792 s.starelid::regclass, s.staattnum, s.stainherit,
793 s.stanullfrac, s.stawidth, s.stadistinct,
796 s.staop1, s.staop2, s.staop3, s.staop4,
798 s.stanumbers1, s.stanumbers2, s.stanumbers3, s.stanumbers4,
800 s.stavalues1, s.stavalues2, s.stavalues3, s.stavalues4
803 FROM dbms_stats._column_stats_locked v,
805 WHERE v.starelid = 'st0'::regclass
806 AND v.staattnum = '2'::int2
807 AND s.starelid = 'st0'::regclass
808 AND s.staattnum = '1'::int2) m;
811 SELECT dbms_stats.merge((v.starelid::regclass, '2', v.stainherit,
812 v.stanullfrac, v.stawidth, v.stadistinct,
815 v.staop1, v.staop2, v.staop3, v.staop4,
817 v.stanumbers1, v.stanumbers2, v.stanumbers3, v.stanumbers4,
819 v.stavalues1, v.stavalues2, v.stavalues3, v.stavalues4
822 s.starelid::regclass, s.staattnum, s.stainherit,
823 s.stanullfrac, s.stawidth, s.stadistinct,
826 s.staop1, s.staop2, s.staop3, s.staop4,
828 s.stanumbers1, s.stanumbers2, s.stanumbers3, s.stanumbers4,
830 s.stavalues1, s.stavalues2, s.stavalues3, s.stavalues4
833 FROM dbms_stats._column_stats_locked v,
835 WHERE v.starelid = 'st0'::regclass
836 AND v.staattnum = '1'::int2
837 AND s.starelid = 'st0'::regclass
838 AND s.staattnum = '1'::int2;
841 SELECT dbms_stats.merge((v.starelid::regclass, '2', v.stainherit,
842 v.stanullfrac, v.stawidth, v.stadistinct,
845 v.staop1, v.staop2, v.staop3, v.staop4,
847 v.stanumbers1, v.stanumbers2, v.stanumbers3, v.stanumbers4,
849 v.stavalues1, v.stavalues2, v.stavalues3, v.stavalues4
852 s.starelid::regclass, s.staattnum, s.stainherit,
853 s.stanullfrac, s.stawidth, s.stadistinct,
856 s.staop1, s.staop2, s.staop3, s.staop4,
858 s.stanumbers1, s.stanumbers2, s.stanumbers3, s.stanumbers4,
860 s.stavalues1, s.stavalues2, s.stavalues3, s.stavalues4
863 FROM dbms_stats._column_stats_locked v,
865 WHERE v.starelid = 'st0'::regclass
866 AND v.staattnum = '1'::int2
867 AND s.starelid = 'st0'::regclass
868 AND s.staattnum = '1'::int2;
869 RESET client_min_messages;
870 SELECT dbms_stats.unlock_database_stats();
873 * No.6-4 dbms_stats.is_target_relkind
876 SELECT dbms_stats.is_target_relkind('f');
879 * No.7-1 dbms_stats.backup
881 DELETE FROM dbms_stats.backup_history;
882 INSERT INTO dbms_stats.backup_history(id, time, unit) values(1, '2012-01-01', 'd');
884 SELECT dbms_stats.backup(1, 's0.sft0'::regclass, NULL);
885 SELECT count(*) FROM dbms_stats.relation_stats_backup;
886 SELECT count(*) FROM dbms_stats.column_stats_backup;
889 DELETE FROM dbms_stats.relation_stats_backup;
890 SELECT dbms_stats.backup(1, NULL, 1::int2);
891 SELECT relid::regclass FROM dbms_stats.relation_stats_backup
894 SELECT starelid::regclass, staattnum FROM dbms_stats.column_stats_backup
895 GROUP BY starelid, staattnum
896 ORDER BY starelid, staattnum;
899 DELETE FROM dbms_stats.relation_stats_backup;
900 SELECT dbms_stats.backup(1, NULL::regclass, NULL);
901 SELECT relid::regclass FROM dbms_stats.relation_stats_backup
904 SELECT starelid::regclass, staattnum FROM dbms_stats.column_stats_backup
905 GROUP BY starelid, staattnum
906 ORDER BY starelid, staattnum;
909 DELETE FROM dbms_stats.relation_stats_backup;
910 \! psql contrib_regression -c "SELECT dbms_stats.backup(NULL, 's0.st0'::regclass, NULL)" > results/ut_no2_1_17.out 2>&1
911 SELECT count(*) FROM dbms_stats.relation_stats_backup;
912 SELECT count(*) FROM dbms_stats.column_stats_backup;
915 * No.8-1 dbms_stats.backup
917 SELECT setval('dbms_stats.backup_history_id_seq',1, false);
919 * Stab function dbms_stats.backup
921 ALTER FUNCTION dbms_stats.backup(
925 RENAME TO truth_func_backup;
927 CREATE OR REPLACE FUNCTION dbms_stats.backup(
934 RAISE NOTICE 'arguments are %, %, %', $1, $2, $3;
941 DELETE FROM dbms_stats.backup_history;
942 SELECT dbms_stats.backup('s0.st0'::regclass, 'id', 'dummy comment');
943 SELECT id, unit, comment FROM dbms_stats.backup_history;
946 DELETE FROM dbms_stats.backup_history;
947 SELECT dbms_stats.backup('s0.st0'::regclass, NULL, 'dummy comment');
948 SELECT id, unit, comment FROM dbms_stats.backup_history;
951 DELETE FROM dbms_stats.backup_history;
952 SELECT dbms_stats.backup(NULL::regclass, 'id', 'dummy comment');
953 SELECT id, unit, comment FROM dbms_stats.backup_history;
956 DELETE FROM dbms_stats.backup_history;
957 SELECT dbms_stats.backup(NULL::regclass, NULL, 'dummy comment');
958 SELECT id, unit, comment FROM dbms_stats.backup_history;
961 DELETE FROM dbms_stats.backup_history;
962 SELECT dbms_stats.backup(0, NULL, 'dummy comment');
963 SELECT id, unit, comment FROM dbms_stats.backup_history;
966 DELETE FROM dbms_stats.backup_history;
967 SELECT dbms_stats.backup('s0.st0'::regclass, NULL, 'dummy comment');
968 SELECT id, unit, comment FROM dbms_stats.backup_history;
971 DELETE FROM dbms_stats.backup_history;
972 SELECT dbms_stats.backup(
973 'pg_toast.pg_toast_2618'::regclass,
976 SELECT id, unit, comment FROM dbms_stats.backup_history;
979 DELETE FROM dbms_stats.backup_history;
980 SELECT dbms_stats.backup('s0.st0_idx'::regclass, NULL, 'dummy comment');
981 SELECT id, unit, comment FROM dbms_stats.backup_history;
984 DELETE FROM dbms_stats.backup_history;
985 SELECT dbms_stats.backup('s0.ss0'::regclass, NULL, 'dummy comment');
986 SELECT id, unit, comment FROM dbms_stats.backup_history;
989 DELETE FROM dbms_stats.backup_history;
990 SELECT dbms_stats.backup('s0.sc0'::regclass, NULL, 'dummy comment');
991 SELECT id, unit, comment FROM dbms_stats.backup_history;
994 DELETE FROM dbms_stats.backup_history;
995 SELECT dbms_stats.backup('s0.sft0'::regclass, NULL, 'dummy comment');
996 SELECT id, unit, comment FROM dbms_stats.backup_history;
999 DELETE FROM dbms_stats.backup_history;
1000 SELECT dbms_stats.backup('pg_catalog.pg_class'::regclass, NULL, 'dummy comment');
1001 SELECT id, unit, comment FROM dbms_stats.backup_history;
1004 DELETE FROM dbms_stats.backup_history;
1005 SELECT dbms_stats.backup('s0.st0'::regclass, 'dummy', 'dummy comment');
1006 SELECT id, unit, comment FROM dbms_stats.backup_history;
1009 DELETE FROM dbms_stats.backup_history;
1010 DELETE FROM pg_statistic
1011 WHERE starelid = 's0.st0'::regclass
1012 AND staattnum = 1::int2;
1013 SELECT count(*) FROM dbms_stats.column_stats_effective
1014 WHERE starelid = 's0.st0'::regclass
1015 AND staattnum = 1::int2;
1016 SELECT dbms_stats.backup('s0.st0'::regclass, 'id', 'dummy comment');
1017 SELECT id, unit, comment FROM dbms_stats.backup_history;
1020 * Stab function dbms_stats.backup
1022 ALTER FUNCTION dbms_stats.backup(
1026 RENAME TO truth_func_backup;
1027 CREATE OR REPLACE FUNCTION dbms_stats.backup(
1028 relid regclass DEFAULT NULL,
1029 attname text DEFAULT NULL,
1030 comment text DEFAULT NULL)
1034 IF $3 = '<NULL>' THEN
1035 RAISE NOTICE 'third argument is not NULL but string "<NULL>"';
1037 RAISE NOTICE 'arguments are %, %, %', $1, $2, $3;
1044 * No.8-3 dbms_stats.backup_schema_stats
1046 SELECT setval('dbms_stats.backup_history_id_seq',9, false);
1048 SELECT dbms_stats.backup_schema_stats('s0', 'comment');
1049 SELECT id, unit, comment FROM dbms_stats.backup_history
1053 SELECT dbms_stats.backup_schema_stats('s00', 'comment');
1054 SELECT id, unit, comment FROM dbms_stats.backup_history
1058 SELECT dbms_stats.backup_schema_stats('pg_catalog', 'comment');
1059 SELECT id, unit, comment FROM dbms_stats.backup_history
1064 * Delete stab function dbms_stats.backup
1066 DROP FUNCTION dbms_stats.backup(
1070 ALTER FUNCTION dbms_stats.truth_func_backup(
1075 DROP FUNCTION dbms_stats.backup(
1079 ALTER FUNCTION dbms_stats.truth_func_backup(
1087 * create backup statistics state A
1089 DELETE FROM dbms_stats.backup_history;
1091 INSERT INTO dbms_stats.backup_history(id, time, unit)
1092 VALUES (1, '2012-02-29 23:59:56.999999', 'd');
1094 SELECT setval('dbms_stats.backup_history_id_seq',1);
1095 SELECT dbms_stats.backup();
1096 UPDATE dbms_stats.backup_history
1097 SET time = '2012-02-29 23:59:57'
1099 SELECT dbms_stats.backup('s0.st0');
1100 UPDATE dbms_stats.backup_history
1101 SET time = '2012-02-29 23:59:57.000001'
1103 SELECT dbms_stats.backup();
1104 UPDATE dbms_stats.backup_history
1105 SET time = '2012-02-29 23:59:58'
1107 DELETE FROM dbms_stats.relation_stats_backup
1109 SELECT dbms_stats.backup('s0.st0', 'id');
1110 UPDATE dbms_stats.backup_history
1111 SET time = '2012-03-01 00:00:00'
1113 SELECT dbms_stats.backup('s0.st0');
1114 UPDATE dbms_stats.backup_history
1115 SET time = '2012-03-01 00:00:02'
1117 SELECT dbms_stats.backup('public.st0');
1118 UPDATE dbms_stats.backup_history
1119 SET time = '2012-03-01 00:00:04'
1121 INSERT INTO dbms_stats.backup_history(time, unit)
1122 VALUES ('2012-03-01 00:00:06', 's');
1123 SELECT dbms_stats.backup(8, c.oid, NULL)
1124 FROM pg_catalog.pg_class c,
1125 pg_catalog.pg_namespace n
1126 WHERE n.nspname = 's0'
1127 AND c.relnamespace = n.oid
1128 AND c.relkind IN ('r', 'i');
1130 SELECT * FROM dbms_stats.backup_history
1132 SELECT * FROM relations_backup_v;
1133 SELECT * FROM columns_backup_v;
1138 * No.9-1 dbms_stats.restore
1141 DELETE FROM dbms_stats._relation_stats_locked;
1143 SELECT relation::regclass, mode
1144 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
1145 WHERE mode LIKE '%ExclusiveLock%'
1146 ORDER BY relation::regclass::text, mode;
1147 SELECT dbms_stats.restore(2, 's0.st0', NULL);
1148 SELECT relation::regclass, mode
1149 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
1150 WHERE mode LIKE '%ExclusiveLock%'
1151 ORDER BY relation::regclass::text, mode;
1153 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1156 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1159 DELETE FROM dbms_stats._relation_stats_locked;
1160 SELECT dbms_stats.restore(2, 'st0', NULL);
1161 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1164 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1167 DELETE FROM dbms_stats._relation_stats_locked;
1168 SELECT dbms_stats.restore(2, 's00.s0', NULL);
1169 SELECT count(*) FROM dbms_stats.column_stats_locked;
1170 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1173 DELETE FROM dbms_stats._relation_stats_locked;
1174 SELECT dbms_stats.restore(NULL, 's0.st0', NULL);
1175 SELECT count(*) FROM dbms_stats.column_stats_locked;
1176 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1179 DELETE FROM dbms_stats._relation_stats_locked;
1180 SELECT dbms_stats.restore(2, 's0.st0', 'id');
1181 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1184 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1187 DELETE FROM dbms_stats._relation_stats_locked;
1188 SELECT dbms_stats.restore(2, NULL, 'id');
1189 SELECT count(*) FROM dbms_stats.column_stats_locked;
1190 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1193 DELETE FROM dbms_stats._relation_stats_locked;
1194 SELECT dbms_stats.restore(2, 's0.st0', NULL);
1195 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1198 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1201 DELETE FROM dbms_stats._relation_stats_locked;
1202 SELECT dbms_stats.restore(2, NULL, NULL);
1203 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1206 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1209 DELETE FROM dbms_stats._relation_stats_locked;
1210 SELECT dbms_stats.restore(0, 's0.st0', NULL);
1211 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1214 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1217 DELETE FROM dbms_stats._relation_stats_locked;
1218 SELECT dbms_stats.restore(2, 0, 'id');
1219 SELECT count(*) FROM dbms_stats.column_stats_locked;
1220 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1223 DELETE FROM dbms_stats._relation_stats_locked;
1224 SELECT dbms_stats.restore(1, 's0.st0', NULL);
1225 SELECT count(*) FROM dbms_stats.column_stats_locked;
1226 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1229 DELETE FROM dbms_stats._relation_stats_locked;
1230 SELECT dbms_stats.restore(2, 's0.st0', 'dummy');
1231 SELECT count(*) FROM dbms_stats.column_stats_locked;
1232 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1235 DELETE FROM dbms_stats._relation_stats_locked;
1236 SELECT dbms_stats.restore(1, 's0.st0', 'id');
1237 SELECT count(*) FROM dbms_stats.column_stats_locked;
1238 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1241 DELETE FROM dbms_stats._relation_stats_locked;
1242 ALTER TABLE s1.st0 DROP COLUMN id;
1243 SELECT dbms_stats.restore(2, 's1.st0', 'id');
1244 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1247 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1250 DELETE FROM dbms_stats._relation_stats_locked;
1251 \set s1_st0_oid `psql contrib_regression -tA -c "SELECT c.oid FROM pg_class c, pg_namespace n WHERE c.relnamespace = n.oid AND n.nspname = 's1' AND c.relname = 'st0';"`
1253 SELECT dbms_stats.restore(2, :s1_st0_oid, NULL);
1254 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1255 SELECT count(*) FROM dbms_stats.column_stats_locked;
1256 CREATE TABLE s1.st0(id integer, num integer);
1257 INSERT INTO s1.st0 VALUES (1, 15), (2, 25), (3, 35), (4, 45);
1260 DELETE FROM dbms_stats._relation_stats_locked;
1261 SELECT dbms_stats.restore(2, 's0.st0', NULL);
1262 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1265 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1268 DELETE FROM dbms_stats._relation_stats_locked;
1269 INSERT INTO dbms_stats.relation_stats_backup(
1270 id, relid, relname, relpages, reltuples,
1274 'pg_toast.pg_toast_2618'::regclass,
1275 'pg_toast.pg_toast_2618', 1, 1,
1278 SELECT * FROM relations_backup_v
1280 AND relname = 'pg_toast.pg_toast_2618';
1281 SELECT dbms_stats.restore(2, 'pg_toast.pg_toast_2618', NULL);
1282 SELECT count(*) FROM dbms_stats.column_stats_locked;
1283 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1284 DELETE FROM dbms_stats.relation_stats_backup
1286 AND relname = 'pg_toast.pg_toast_2618';
1289 DELETE FROM dbms_stats._relation_stats_locked;
1290 SELECT dbms_stats.restore(2, 's0.st0_idx', NULL);
1291 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1294 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1297 DELETE FROM dbms_stats._relation_stats_locked;
1298 INSERT INTO dbms_stats.relation_stats_backup(
1299 id, relid, relname, relpages, reltuples,
1302 VALUES (2, 's0.ss0'::regclass, 's0.ss0', 1, 1,
1305 SELECT * FROM relations_backup_v
1307 AND relname = 's0.ss0';
1308 SELECT dbms_stats.restore(2, 's0.ss0', NULL);
1309 SELECT count(*) FROM dbms_stats.column_stats_locked;
1310 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1311 DELETE FROM dbms_stats.relation_stats_backup
1313 AND relname = 's0.ss0';
1316 DELETE FROM dbms_stats._relation_stats_locked;
1317 INSERT INTO dbms_stats.relation_stats_backup(
1318 id, relid, relname, relpages, reltuples,
1321 VALUES (2, 's0.sc0'::regclass, 's0.sc0', 1, 1,
1324 SELECT * FROM relations_backup_v
1326 AND relname = 's0.sc0';
1327 SELECT dbms_stats.restore(2, 's0.sc0', NULL);
1328 SELECT count(*) FROM dbms_stats.column_stats_locked;
1329 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1330 DELETE FROM dbms_stats.relation_stats_backup
1332 AND relname = 's0.sc0';
1335 DELETE FROM dbms_stats._relation_stats_locked;
1336 INSERT INTO dbms_stats.relation_stats_backup(
1337 id, relid, relname, relpages, reltuples,
1340 VALUES (3, 's0.sft0'::regclass, 's0.sft0', 1, 1,
1343 SELECT * FROM relations_backup_v
1345 AND relname = 's0.sft0';
1346 SELECT dbms_stats.restore(2, 's0.sft0', NULL);
1347 SELECT count(*) FROM dbms_stats.column_stats_locked;
1348 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1349 DELETE FROM dbms_stats.relation_stats_backup
1351 AND relname = 's0.sft0';
1354 DELETE FROM dbms_stats._relation_stats_locked;
1355 INSERT INTO dbms_stats.relation_stats_backup(
1356 id, relid, relname, relpages, reltuples,
1359 VALUES (2, 'pg_catalog.pg_class'::regclass, 'pg_catalog.pg_class', 1, 1,
1362 SELECT * FROM relations_backup_v
1364 AND relname = 'pg_catalog.pg_class';
1365 SELECT dbms_stats.restore(2, 'pg_catalog.pg_class', NULL);
1366 SELECT count(*) FROM dbms_stats.column_stats_locked;
1367 SELECT count(*) FROM dbms_stats.relation_stats_locked;
1368 DELETE FROM dbms_stats.relation_stats_backup
1370 AND relname = 'pg_catalog.pg_class';
1373 DELETE FROM dbms_stats._relation_stats_locked;
1374 INSERT INTO dbms_stats._relation_stats_locked(relid, relname)
1375 VALUES ('s0.st0'::regclass, 's0.st0');
1376 INSERT INTO dbms_stats._column_stats_locked(starelid, staattnum, stainherit)
1377 SELECT starelid::regclass, staattnum, stainherit
1378 FROM dbms_stats.column_stats_effective
1379 WHERE starelid = 's0.st0'::regclass;
1380 SELECT id, unit, comment FROM dbms_stats.backup_history
1382 SELECT * FROM columns_locked_v;
1383 SELECT * FROM relations_locked_v;
1384 SELECT dbms_stats.restore(2, 's0.st0', NULL);
1385 SELECT * FROM relations_locked_v;
1386 SELECT * FROM columns_locked_v;
1389 DELETE FROM dbms_stats._relation_stats_locked;
1390 SELECT id, unit, comment FROM dbms_stats.backup_history
1392 SELECT dbms_stats.restore(2, 's0.st0', NULL);
1393 SELECT * FROM relations_locked_v;
1394 SELECT * FROM columns_locked_v;
1397 * Stab function dbms_stats.restore
1399 CREATE OR REPLACE FUNCTION dbms_stats.restore(
1401 relid regclass DEFAULT NULL,
1402 attname text DEFAULT NULL)
1403 RETURNS SETOF regclass AS
1406 RAISE NOTICE 'arguments are "%, %, %"', $1, $2, $3;
1408 SELECT c.oid::regclass
1409 FROM pg_class c, dbms_stats.relation_stats_backup b
1410 WHERE (c.oid = $2 OR $2 IS NULL)
1412 AND c.relkind IN ('r', 'i')
1413 AND (b.id <= $1 OR $1 IS NOT NULL)
1415 ORDER BY c.oid::regclass::text;
1421 * No.10-1 dbms_stats.restore_database_stats
1424 SELECT dbms_stats.restore_database_stats('2012-02-29 23:59:57');
1426 SELECT dbms_stats.restore_database_stats('2012-02-29 23:59:57.000002');
1428 SELECT dbms_stats.restore_database_stats('2012-01-01 00:00:00');
1429 --#No.10-1-4 is skipped after lock tests
1430 --#No.10-1-5 is skipped after lock tests
1432 SELECT dbms_stats.restore_database_stats('2012-02-29 23:59:57');
1435 * No.10-2 dbms_stats.restore_schema_stats
1438 SELECT dbms_stats.restore_schema_stats('s0', '2012-02-29 23:59:57');
1440 SELECT dbms_stats.restore_schema_stats('s0', '2012-02-29 23:59:57.000002');
1442 SELECT dbms_stats.restore_schema_stats('s0', '2012-01-01 00:00:00');
1443 --#No.10-2-4 is skipped after lock tests
1444 --#No.10-2-5 is skipped after lock tests
1446 SELECT dbms_stats.restore_schema_stats('s0', '2012-02-29 23:59:57');
1448 SELECT dbms_stats.restore_schema_stats('s0', '2012-02-29 23:59:57');
1449 --#No.10-2-8 is skipped after lock tests
1451 SELECT dbms_stats.restore_schema_stats('s00', '2012-02-29 23:59:57');
1453 SELECT dbms_stats.restore_schema_stats('pg_catalog', '2012-02-29 23:59:57');
1456 * No.10-7 dbms_stats.restore_stats
1459 DELETE FROM dbms_stats._relation_stats_locked;
1460 SELECT dbms_stats.restore_stats(NULL);
1463 DELETE FROM dbms_stats._relation_stats_locked;
1464 SELECT dbms_stats.restore_stats(0);
1467 DELETE FROM dbms_stats._relation_stats_locked;
1469 SELECT relation::regclass, mode
1470 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
1471 WHERE mode LIKE '%ExclusiveLock%'
1472 ORDER BY relation::regclass::text, mode;
1473 SELECT dbms_stats.restore_stats(2);
1474 SELECT relation::regclass, mode
1475 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
1476 WHERE mode LIKE '%ExclusiveLock%'
1477 ORDER BY relation::regclass::text, mode;
1479 SELECT relid::regclass FROM dbms_stats.relation_stats_locked
1482 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1485 DELETE FROM dbms_stats._relation_stats_locked;
1486 INSERT INTO dbms_stats._relation_stats_locked(relid, relname)
1487 SELECT relid::regclass, relname
1488 FROM dbms_stats.relation_stats_effective;
1489 INSERT INTO dbms_stats._column_stats_locked(starelid, staattnum, stainherit)
1490 SELECT starelid::regclass, staattnum, stainherit
1491 FROM dbms_stats.column_stats_effective;
1492 SELECT id, unit, comment FROM dbms_stats.backup_history
1494 SELECT * FROM columns_locked_v;
1495 SELECT * FROM relations_locked_v;
1496 SELECT dbms_stats.restore_stats(8);
1497 SELECT * FROM relations_locked_v;
1498 SELECT * FROM columns_locked_v;
1501 DELETE FROM dbms_stats._relation_stats_locked;
1502 SELECT id, unit, comment FROM dbms_stats.backup_history
1504 SELECT dbms_stats.restore_stats(8);
1505 SELECT * FROM relations_locked_v;
1506 SELECT * FROM columns_locked_v;
1509 * No.11-1 dbms_stats.lock(relid, attname)
1512 DELETE FROM dbms_stats._relation_stats_locked;
1513 SELECT dbms_stats.lock(NULL, NULL);
1515 ALTER FUNCTION dbms_stats.lock(relid regclass)
1516 RENAME TO truth_lock;
1517 CREATE FUNCTION dbms_stats.lock(relid regclass)
1521 RAISE NOTICE 'arguments are %', $1;
1526 DELETE FROM dbms_stats._relation_stats_locked;
1527 SELECT dbms_stats.lock('s0.st0', NULL);
1528 DROP FUNCTION dbms_stats.lock(relid regclass);
1529 ALTER FUNCTION dbms_stats.truth_lock(relid regclass)
1532 DELETE FROM dbms_stats._relation_stats_locked;
1533 SELECT dbms_stats.lock(NULL, 'id');
1535 DELETE FROM dbms_stats._relation_stats_locked;
1536 SELECT dbms_stats.lock('s0.st0', 'id');
1537 SELECT * FROM relations_locked_v;
1538 SELECT * FROM columns_locked_v c;
1540 DELETE FROM dbms_stats._relation_stats_locked;
1541 SELECT dbms_stats.lock(0, 'id');
1543 DELETE FROM dbms_stats._relation_stats_locked;
1544 SELECT dbms_stats.lock('s0.st0', 'id');
1545 SELECT * FROM relations_locked_v;
1546 SELECT * FROM columns_locked_v c;
1548 DELETE FROM dbms_stats._relation_stats_locked;
1549 SELECT dbms_stats.lock('pg_toast.pg_toast_2618', 'id');
1551 DELETE FROM dbms_stats._relation_stats_locked;
1552 SELECT dbms_stats.lock('s0.st0_idx', 'id');
1554 DELETE FROM dbms_stats._relation_stats_locked;
1555 SELECT dbms_stats.lock('st1_exp', 'lower');
1556 SELECT * FROM relations_locked_v;
1557 SELECT * FROM columns_locked_v c;
1558 DELETE FROM dbms_stats._relation_stats_locked;
1561 DELETE FROM dbms_stats._relation_stats_locked;
1562 SELECT dbms_stats.lock('s0.ss0', 'id');
1564 DELETE FROM dbms_stats._relation_stats_locked;
1565 SELECT dbms_stats.lock('s0.sc0', 'id');
1567 DELETE FROM dbms_stats._relation_stats_locked;
1568 SELECT dbms_stats.lock('s0.sft0', 'id');
1569 SELECT * FROM relations_locked_v;
1570 SELECT * FROM columns_locked_v c;
1572 DELETE FROM dbms_stats._relation_stats_locked;
1573 SELECT dbms_stats.lock('pg_catalog.pg_class', 'id');
1575 DELETE FROM dbms_stats._relation_stats_locked;
1576 SELECT dbms_stats.lock('s0.st0', 'dummy');
1578 DELETE FROM dbms_stats._relation_stats_locked;
1579 DELETE FROM pg_statistic
1580 WHERE starelid = 's0.st0'::regclass;
1581 SELECT dbms_stats.lock('s0.st0', 'id');
1584 DELETE FROM dbms_stats._relation_stats_locked;
1585 INSERT INTO dbms_stats._relation_stats_locked(
1586 relid, relname, relpages, reltuples,
1589 VALUES('s0.st0'::regclass, 's0.st0', 1, 1640,
1592 SELECT dbms_stats.lock_column_stats('s0.st0','id');
1593 UPDATE dbms_stats._column_stats_locked
1594 SET (stanullfrac, stawidth, stadistinct,
1595 stakind1, stakind2, stakind3, stakind4,
1597 staop1, staop2, staop3, staop4,
1599 stanumbers1, stanumbers2, stanumbers3, stanumbers4,
1601 stavalues1, stavalues2, stavalues3, stavalues4
1605 NULL, NULL, NULL, NULL,
1606 NULL, NULL, NULL, NULL,
1607 NULL, NULL, NULL, NULL,
1608 NULL, NULL, NULL, NULL,
1609 NULL, NULL, NULL, NULL)
1610 WHERE starelid = 's0.st0'::regclass;
1611 SELECT dbms_stats.lock('s0.st0', 'id');
1612 SELECT * FROM relations_locked_v;
1613 SELECT * FROM columns_locked_v c;
1615 DELETE FROM dbms_stats._relation_stats_locked;
1616 SELECT dbms_stats.lock('s0.st0', 'id');
1617 SELECT * FROM relations_locked_v
1618 WHERE relid = 's0.st0'::regclass;
1619 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1622 * No.11-2 dbms_stats.lock(relid)
1625 DELETE FROM dbms_stats._relation_stats_locked;
1627 SELECT relation::regclass, mode
1628 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
1629 WHERE mode LIKE '%ExclusiveLock%'
1630 ORDER BY relation::regclass::text, mode;
1631 SELECT dbms_stats.lock('s0.st0');
1632 SELECT * FROM relations_locked_v;
1633 SELECT * FROM columns_locked_v c;
1634 SELECT relation::regclass, mode
1635 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
1636 WHERE mode LIKE '%ExclusiveLock%'
1637 ORDER BY relation::regclass::text, mode;
1641 DELETE FROM dbms_stats._relation_stats_locked;
1642 SELECT dbms_stats.lock(NULL);
1644 DELETE FROM dbms_stats._relation_stats_locked;
1645 SELECT dbms_stats.lock('0');
1647 DELETE FROM dbms_stats._relation_stats_locked;
1648 SELECT dbms_stats.lock('s0.st0');
1649 SELECT * FROM relations_locked_v;
1650 SELECT * FROM columns_locked_v c;
1652 DELETE FROM dbms_stats._relation_stats_locked;
1653 SELECT dbms_stats.lock('pg_toast.pg_toast_2618');
1655 DELETE FROM dbms_stats._relation_stats_locked;
1656 SELECT dbms_stats.lock('s0.st0_idx');
1657 SELECT * FROM relations_locked_v;
1658 SELECT * FROM columns_locked_v c;
1660 DELETE FROM dbms_stats._relation_stats_locked;
1661 SELECT dbms_stats.lock('s0.ss0');
1663 DELETE FROM dbms_stats._relation_stats_locked;
1664 SELECT dbms_stats.lock('s0.sc0');
1666 DELETE FROM dbms_stats._relation_stats_locked;
1667 SELECT dbms_stats.lock('s0.sft0');
1668 SELECT * FROM relations_locked_v;
1669 SELECT * FROM columns_locked_v c;
1671 DELETE FROM dbms_stats._relation_stats_locked;
1672 SELECT dbms_stats.lock('pg_catalog.pg_class');
1674 DELETE FROM dbms_stats._relation_stats_locked;
1675 SELECT dbms_stats.lock_table_stats('s0.st0');
1676 UPDATE dbms_stats._relation_stats_locked
1677 SET (relpages, reltuples,
1683 WHERE relid = 's0.st0'::regclass;
1684 SELECT dbms_stats.lock('s0.st0');
1685 SELECT * FROM relations_locked_v;
1686 SELECT * FROM columns_locked_v c;
1688 DELETE FROM dbms_stats._relation_stats_locked;
1689 SELECT dbms_stats.lock('s0.st0');
1690 SELECT * FROM relations_locked_v;
1691 SELECT * FROM columns_locked_v c;
1694 * Stab function dbms_stats.lock
1696 ALTER FUNCTION dbms_stats.lock(relid regclass)
1697 RENAME TO truth_lock;
1698 CREATE FUNCTION dbms_stats.lock(relid regclass)
1702 RAISE NOTICE 'arguments are %', $1;
1708 ALTER FUNCTION dbms_stats.lock(relid regclass, attname text)
1709 RENAME TO truth_lock;
1710 CREATE FUNCTION dbms_stats.lock(
1716 RAISE NOTICE 'arguments are %, %', $1, $2;
1723 * No.12-1 dbms_stats.lock_database_stats
1726 SELECT dbms_stats.lock_database_stats();
1729 * No.12-2 dbms_stats.lock_schema_stats
1732 SELECT dbms_stats.lock_schema_stats('s0');
1734 SELECT dbms_stats.lock_schema_stats('s00');
1736 SELECT dbms_stats.lock_schema_stats('pg_catalog');
1739 * No.12-3 dbms_stats.lock_table_stats(regclass)
1742 SELECT dbms_stats.lock_table_stats('s0.st0');
1744 SELECT dbms_stats.lock_table_stats('st0');
1746 SELECT dbms_stats.lock_table_stats('s00.s0');
1749 * No.12-4 dbms_stats.lock_table_stats(schemaname, tablename)
1752 SELECT dbms_stats.lock_table_stats('s0', 'st0');
1755 * No.12-5 dbms_stats.lock_column_stats(regclass, attname)
1758 SELECT dbms_stats.lock_column_stats('s0.st0', 'id');
1760 SELECT dbms_stats.lock_column_stats('st0', 'id');
1762 SELECT dbms_stats.lock_column_stats('s00.s0', 'id');
1765 * No.12-6 dbms_stats.lock_column_stats(schemaname, tablename, int2)
1768 SELECT dbms_stats.lock_column_stats('s0', 'st0', 'id');
1771 * Delete Stab function lock
1773 DROP FUNCTION dbms_stats.lock(relid regclass);
1774 ALTER FUNCTION dbms_stats.truth_lock(relid regclass)
1776 DROP FUNCTION dbms_stats.lock(relid regclass, attname text);
1777 ALTER FUNCTION dbms_stats.truth_lock(relid regclass, attname text)
1781 * No.13-1 dbms_stats.unlock
1784 DELETE FROM dbms_stats._relation_stats_locked;
1785 SELECT dbms_stats.lock_database_stats();
1786 SELECT * FROM dbms_stats.backup_history
1788 SELECT count(*) FROM dbms_stats.relation_stats_backup;
1789 SELECT count(*) FROM dbms_stats.column_stats_backup;
1790 SELECT dbms_stats.unlock();
1791 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1792 SELECT count(*) FROM dbms_stats._column_stats_locked;
1793 SELECT * FROM dbms_stats.backup_history
1795 SELECT count(*) FROM dbms_stats.relation_stats_backup;
1796 SELECT count(*) FROM dbms_stats.column_stats_backup;
1799 DELETE FROM dbms_stats._relation_stats_locked;
1800 SELECT dbms_stats.lock_database_stats();
1801 SELECT dbms_stats.unlock();
1802 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1803 SELECT count(*) FROM dbms_stats._column_stats_locked;
1806 DELETE FROM dbms_stats._relation_stats_locked;
1807 SELECT dbms_stats.lock_database_stats();
1808 DELETE FROM dbms_stats._column_stats_locked;
1809 SELECT dbms_stats.unlock();
1810 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1811 SELECT count(*) FROM dbms_stats._column_stats_locked;
1814 DELETE FROM dbms_stats._relation_stats_locked;
1815 SELECT dbms_stats.unlock();
1816 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1817 SELECT count(*) FROM dbms_stats._column_stats_locked;
1820 DELETE FROM dbms_stats._relation_stats_locked;
1821 SELECT dbms_stats.lock_database_stats();
1822 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1825 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
1828 SELECT dbms_stats.unlock('s0.st0');
1829 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1832 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
1837 DELETE FROM dbms_stats._relation_stats_locked;
1838 SELECT dbms_stats.lock_database_stats();
1839 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1842 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
1845 SELECT dbms_stats.unlock('st0');
1846 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1849 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
1854 DELETE FROM dbms_stats._relation_stats_locked;
1855 SELECT dbms_stats.lock_database_stats();
1856 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1857 SELECT count(*) FROM dbms_stats._column_stats_locked;
1858 SELECT dbms_stats.unlock('s00.s0');
1859 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1860 SELECT count(*) FROM dbms_stats._column_stats_locked;
1863 DELETE FROM dbms_stats._relation_stats_locked;
1864 SELECT dbms_stats.lock_database_stats();
1865 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1868 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1869 SELECT dbms_stats.unlock('s0.st0', 'id');
1870 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1873 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1876 DELETE FROM dbms_stats._relation_stats_locked;
1877 SELECT dbms_stats.lock_database_stats();
1878 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1881 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1882 SELECT dbms_stats.unlock('s0.st0', 'dummy');
1883 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1886 SELECT starelid, attname, stainherit FROM columns_locked_v c;
1889 DELETE FROM dbms_stats._relation_stats_locked;
1890 SELECT dbms_stats.lock_database_stats();
1891 DELETE FROM dbms_stats._column_stats_locked;
1892 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1895 SELECT dbms_stats.unlock('s0.st0', 'id');
1896 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1899 SELECT starelid::regclass, staattnum FROM dbms_stats._column_stats_locked
1900 GROUP BY starelid, staattnum
1904 DELETE FROM dbms_stats._relation_stats_locked;
1905 SELECT dbms_stats.lock_database_stats();
1906 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1909 SELECT starelid::regclass, staattnum FROM dbms_stats._column_stats_locked
1910 GROUP BY starelid, staattnum
1912 SELECT dbms_stats.unlock(NULL, 'id');
1913 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1916 SELECT starelid::regclass, staattnum FROM dbms_stats._column_stats_locked
1917 GROUP BY starelid, staattnum
1921 DELETE FROM dbms_stats._relation_stats_locked;
1922 SELECT dbms_stats.lock_database_stats();
1923 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1926 SELECT starelid::regclass, staattnum FROM dbms_stats._column_stats_locked
1927 GROUP BY starelid, staattnum
1929 SELECT dbms_stats.unlock('s0.st0', NULL);
1930 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
1933 SELECT starelid::regclass, staattnum FROM dbms_stats._column_stats_locked
1934 GROUP BY starelid, staattnum
1938 DELETE FROM dbms_stats._relation_stats_locked;
1939 SELECT dbms_stats.lock_database_stats();
1940 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1941 SELECT count(*) FROM dbms_stats._column_stats_locked;
1943 SELECT relation::regclass, mode
1944 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
1945 WHERE mode LIKE '%ExclusiveLock%'
1946 ORDER BY relation::regclass::text, mode;
1947 SELECT dbms_stats.unlock();
1948 SELECT relation::regclass, mode
1949 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
1950 WHERE mode LIKE '%ExclusiveLock%'
1951 ORDER BY relation::regclass::text, mode;
1953 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1954 SELECT count(*) FROM dbms_stats._column_stats_locked;
1957 * No.14-1 dbms_stats.unlock_database_stats
1960 DELETE FROM dbms_stats._relation_stats_locked;
1961 SELECT dbms_stats.lock_database_stats();
1962 SELECT * FROM dbms_stats.backup_history
1964 SELECT count(*) FROM dbms_stats.relation_stats_backup;
1965 SELECT count(*) FROM dbms_stats.column_stats_backup;
1966 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1967 SELECT count(*) FROM dbms_stats._column_stats_locked;
1968 SELECT dbms_stats.unlock_database_stats();
1969 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1970 SELECT count(*) FROM dbms_stats._column_stats_locked;
1971 SELECT * FROM dbms_stats.backup_history
1973 SELECT count(*) FROM dbms_stats.relation_stats_backup;
1974 SELECT count(*) FROM dbms_stats.column_stats_backup;
1977 DELETE FROM dbms_stats._relation_stats_locked;
1978 SELECT dbms_stats.lock_database_stats();
1979 DELETE FROM dbms_stats._column_stats_locked;
1980 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1981 SELECT dbms_stats.unlock_database_stats();
1982 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1983 SELECT count(*) FROM dbms_stats._column_stats_locked;
1986 DELETE FROM dbms_stats._relation_stats_locked;
1987 SELECT dbms_stats.unlock_database_stats();
1988 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1989 SELECT count(*) FROM dbms_stats._column_stats_locked;
1992 DELETE FROM dbms_stats._relation_stats_locked;
1993 SELECT dbms_stats.lock_database_stats();
1994 SELECT count(*) FROM dbms_stats._relation_stats_locked;
1995 SELECT count(*) FROM dbms_stats._column_stats_locked;
1997 SELECT relation::regclass, mode
1998 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
1999 WHERE mode LIKE '%ExclusiveLock%'
2000 ORDER BY relation::regclass::text, mode;
2001 SELECT dbms_stats.unlock_database_stats();
2002 SELECT relation::regclass, mode
2003 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
2004 WHERE mode LIKE '%ExclusiveLock%'
2005 ORDER BY relation::regclass::text, mode;
2007 SELECT count(*) FROM dbms_stats._relation_stats_locked;
2008 SELECT count(*) FROM dbms_stats._column_stats_locked;
2011 * No.14-2 dbms_stats.unlock_schema_stats
2014 DELETE FROM dbms_stats._relation_stats_locked;
2015 SELECT dbms_stats.lock_database_stats();
2016 SELECT * FROM dbms_stats.backup_history
2018 SELECT count(*) FROM dbms_stats.relation_stats_backup;
2019 SELECT count(*) FROM dbms_stats.column_stats_backup;
2020 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2023 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2026 SELECT dbms_stats.unlock_schema_stats('s0');
2027 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2030 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2033 SELECT * FROM dbms_stats.backup_history
2035 SELECT count(*) FROM dbms_stats.relation_stats_backup;
2036 SELECT count(*) FROM dbms_stats.column_stats_backup;
2039 DELETE FROM dbms_stats._relation_stats_locked;
2040 SELECT dbms_stats.lock_database_stats();
2041 DELETE FROM dbms_stats._column_stats_locked;
2042 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2045 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2048 SELECT dbms_stats.unlock_schema_stats('s0');
2049 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2052 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2057 DELETE FROM dbms_stats._relation_stats_locked;
2058 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2061 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2064 SELECT dbms_stats.unlock_schema_stats('s0');
2065 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2068 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2073 DELETE FROM dbms_stats._relation_stats_locked;
2074 SELECT dbms_stats.lock_database_stats();
2075 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2078 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2081 SELECT dbms_stats.unlock_schema_stats('s0');
2082 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2085 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2090 DELETE FROM dbms_stats._relation_stats_locked;
2091 SELECT dbms_stats.lock_database_stats();
2092 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2095 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2098 SELECT dbms_stats.unlock_schema_stats('s00');
2099 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2102 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2107 DELETE FROM dbms_stats._relation_stats_locked;
2108 SELECT dbms_stats.lock_database_stats();
2109 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2112 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2115 SELECT dbms_stats.unlock_schema_stats('pg_catalog');
2116 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2119 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2124 DELETE FROM dbms_stats._relation_stats_locked;
2125 SELECT dbms_stats.lock_database_stats();
2126 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2129 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2132 SELECT dbms_stats.unlock_schema_stats(NULL);
2133 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2136 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2141 DELETE FROM dbms_stats._relation_stats_locked;
2142 SELECT dbms_stats.lock_database_stats();
2143 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2146 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2150 SELECT relation::regclass, mode
2151 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
2152 WHERE mode LIKE '%ExclusiveLock%'
2153 ORDER BY relation::regclass::text, mode;
2154 SELECT dbms_stats.unlock_schema_stats('s0');
2155 SELECT relation::regclass, mode
2156 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
2157 WHERE mode LIKE '%ExclusiveLock%'
2158 ORDER BY relation::regclass::text, mode;
2160 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2163 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2168 * No.14-3 dbms_stats.unlock_table_stats(regclass)
2171 DELETE FROM dbms_stats._relation_stats_locked;
2172 SELECT dbms_stats.lock_database_stats();
2173 SELECT * FROM dbms_stats.backup_history
2175 SELECT count(*) FROM dbms_stats.relation_stats_backup;
2176 SELECT count(*) FROM dbms_stats.column_stats_backup;
2177 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2180 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2183 SELECT dbms_stats.unlock_table_stats('s0.st0');
2184 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2187 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2190 SELECT * FROM dbms_stats.backup_history
2192 SELECT count(*) FROM dbms_stats.relation_stats_backup;
2193 SELECT count(*) FROM dbms_stats.column_stats_backup;
2196 DELETE FROM dbms_stats._relation_stats_locked;
2197 SELECT dbms_stats.lock_database_stats();
2198 DELETE FROM dbms_stats._column_stats_locked;
2199 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2202 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2205 SELECT dbms_stats.unlock_table_stats('s0.st0');
2206 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2209 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2214 DELETE FROM dbms_stats._relation_stats_locked;
2215 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2218 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2221 SELECT dbms_stats.unlock_table_stats('s0.st0');
2222 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2225 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2230 DELETE FROM dbms_stats._relation_stats_locked;
2231 SELECT dbms_stats.lock_database_stats();
2232 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2235 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2238 SELECT dbms_stats.unlock_table_stats('s0.st0');
2239 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2242 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2247 DELETE FROM dbms_stats._relation_stats_locked;
2248 SELECT dbms_stats.lock_database_stats();
2249 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2252 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2255 SELECT dbms_stats.unlock_table_stats('st0');
2256 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2259 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2264 DELETE FROM dbms_stats._relation_stats_locked;
2265 SELECT dbms_stats.lock_database_stats();
2266 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2269 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2272 SELECT dbms_stats.unlock_table_stats('s00.s0');
2273 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2276 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2281 DELETE FROM dbms_stats._relation_stats_locked;
2282 SELECT dbms_stats.lock_database_stats();
2283 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2286 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2289 SELECT dbms_stats.unlock_table_stats(NULL);
2290 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2293 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2298 DELETE FROM dbms_stats._relation_stats_locked;
2299 SELECT dbms_stats.lock_database_stats();
2300 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2303 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2307 SELECT relation::regclass, mode
2308 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
2309 WHERE mode LIKE '%ExclusiveLock%'
2310 ORDER BY relation::regclass::text, mode;
2311 SELECT dbms_stats.unlock_table_stats('s0.st0');
2312 SELECT relation::regclass, mode
2313 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
2314 WHERE mode LIKE '%ExclusiveLock%'
2315 ORDER BY relation::regclass::text, mode;
2317 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2320 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2325 * No.14-4 dbms_stats.unlock_table_stats(schemaname, tablename)
2328 DELETE FROM dbms_stats._relation_stats_locked;
2329 SELECT dbms_stats.lock_database_stats();
2330 SELECT * FROM dbms_stats.backup_history
2332 SELECT count(*) FROM dbms_stats.relation_stats_backup;
2333 SELECT count(*) FROM dbms_stats.column_stats_backup;
2334 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2337 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2340 SELECT dbms_stats.unlock_table_stats('s0','st0');
2341 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2344 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2347 SELECT * FROM dbms_stats.backup_history
2349 SELECT count(*) FROM dbms_stats.relation_stats_backup;
2350 SELECT count(*) FROM dbms_stats.column_stats_backup;
2353 DELETE FROM dbms_stats._relation_stats_locked;
2354 SELECT dbms_stats.lock_database_stats();
2355 DELETE FROM dbms_stats._column_stats_locked;
2356 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2359 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2362 SELECT dbms_stats.unlock_table_stats('s0', 'st0');
2363 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2366 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2371 DELETE FROM dbms_stats._relation_stats_locked;
2372 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2375 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2378 SELECT dbms_stats.unlock_table_stats('s0', 'st0');
2379 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2382 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2387 DELETE FROM dbms_stats._relation_stats_locked;
2388 SELECT dbms_stats.lock_database_stats();
2389 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2392 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2395 SELECT dbms_stats.unlock_table_stats('s0', 'st0');
2396 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2399 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2404 DELETE FROM dbms_stats._relation_stats_locked;
2405 SELECT dbms_stats.lock_database_stats();
2406 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2409 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2412 SELECT dbms_stats.unlock_table_stats('s00', 's0');
2413 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2416 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2421 DELETE FROM dbms_stats._relation_stats_locked;
2422 SELECT dbms_stats.lock_database_stats();
2423 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2426 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2429 SELECT dbms_stats.unlock_table_stats(NULL, 'st0');
2430 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2433 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2438 DELETE FROM dbms_stats._relation_stats_locked;
2439 SELECT dbms_stats.lock_database_stats();
2440 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2443 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2446 SELECT dbms_stats.unlock_table_stats('s0', NULL);
2447 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2450 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2455 DELETE FROM dbms_stats._relation_stats_locked;
2456 SELECT dbms_stats.lock_database_stats();
2457 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2460 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2464 SELECT relation::regclass, mode
2465 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
2466 WHERE mode LIKE '%ExclusiveLock%'
2467 ORDER BY relation::regclass::text, mode;
2468 SELECT dbms_stats.unlock_table_stats('s0', 'st0');
2469 SELECT relation::regclass, mode
2470 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
2471 WHERE mode LIKE '%ExclusiveLock%'
2472 ORDER BY relation::regclass::text, mode;
2474 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2477 SELECT starelid::regclass, count(*) FROM dbms_stats._column_stats_locked
2482 * No.14-5 dbms_stats.unlock_column_stats(regclass, attname)
2485 DELETE FROM dbms_stats._relation_stats_locked;
2486 SELECT dbms_stats.lock_database_stats();
2487 SELECT * FROM dbms_stats.backup_history
2489 SELECT count(*) FROM dbms_stats.relation_stats_backup;
2490 SELECT count(*) FROM dbms_stats.column_stats_backup;
2491 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2494 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2495 SELECT dbms_stats.unlock_column_stats('s0.st0', 'id');
2496 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2497 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2500 SELECT * FROM dbms_stats.backup_history
2502 SELECT count(*) FROM dbms_stats.relation_stats_backup;
2503 SELECT count(*) FROM dbms_stats.column_stats_backup;
2506 DELETE FROM dbms_stats._relation_stats_locked;
2507 SELECT dbms_stats.lock_database_stats();
2508 DELETE FROM dbms_stats._column_stats_locked;
2509 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2512 SELECT dbms_stats.unlock_column_stats('s0.st0', 'id');
2513 SELECT count(*) FROM dbms_stats.column_stats_locked;
2514 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2519 DELETE FROM dbms_stats._relation_stats_locked;
2520 SELECT dbms_stats.lock_database_stats();
2521 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2524 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2525 SELECT dbms_stats.unlock_column_stats('s0.st0', 'id');
2526 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2527 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2532 DELETE FROM dbms_stats._relation_stats_locked;
2533 SELECT dbms_stats.lock_database_stats();
2534 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2537 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2538 SELECT dbms_stats.unlock_column_stats('st0', 'id');
2539 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2540 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2545 DELETE FROM dbms_stats._relation_stats_locked;
2546 SELECT dbms_stats.lock_database_stats();
2547 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2550 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2551 SELECT dbms_stats.unlock_column_stats('s0.st0', 'dummy');
2552 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2553 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2558 DELETE FROM dbms_stats._relation_stats_locked;
2559 SELECT dbms_stats.lock_database_stats();
2560 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2563 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2564 SELECT dbms_stats.unlock_column_stats('s00.s0', 'id');
2565 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2566 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2571 DELETE FROM dbms_stats._relation_stats_locked;
2572 SELECT dbms_stats.lock_database_stats();
2573 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2576 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2577 SELECT dbms_stats.unlock_column_stats(NULL, 'id');
2578 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2579 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2584 DELETE FROM dbms_stats._relation_stats_locked;
2585 SELECT dbms_stats.lock_database_stats();
2586 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2589 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2590 SELECT dbms_stats.unlock_column_stats('s0.st0', NULL);
2591 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2592 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2597 DELETE FROM dbms_stats._relation_stats_locked;
2598 SELECT dbms_stats.lock_database_stats();
2599 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2602 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2604 SELECT relation::regclass, mode
2605 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
2606 WHERE mode LIKE '%ExclusiveLock%'
2607 ORDER BY relation::regclass::text, mode;
2608 SELECT dbms_stats.unlock_column_stats('s0.st0', 'id');
2609 SELECT relation::regclass, mode
2610 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
2611 WHERE mode LIKE '%ExclusiveLock%'
2612 ORDER BY relation::regclass::text, mode;
2614 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2615 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2620 * No.14-6 dbms_stats.unlock_column_stats(schemaname, tablename, attname)
2623 DELETE FROM dbms_stats._relation_stats_locked;
2624 SELECT dbms_stats.lock_database_stats();
2625 SELECT * FROM dbms_stats.backup_history
2627 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2630 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2631 SELECT dbms_stats.unlock_column_stats('s0', 'st0', 'id');
2632 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2633 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2636 SELECT * FROM dbms_stats.backup_history
2638 SELECT count(*) FROM dbms_stats.relation_stats_backup;
2639 SELECT count(*) FROM dbms_stats.column_stats_backup;
2642 DELETE FROM dbms_stats._relation_stats_locked;
2643 SELECT dbms_stats.lock_database_stats();
2644 DELETE FROM dbms_stats._column_stats_locked;
2645 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2648 SELECT dbms_stats.unlock_column_stats('s0', 'st0', 'id');
2649 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2650 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2655 DELETE FROM dbms_stats._relation_stats_locked;
2656 SELECT dbms_stats.lock_database_stats();
2657 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2660 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2661 SELECT dbms_stats.unlock_column_stats('s0', 'st0', 'id');
2662 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2663 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2668 DELETE FROM dbms_stats._relation_stats_locked;
2669 SELECT dbms_stats.lock_database_stats();
2670 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2673 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2674 SELECT dbms_stats.unlock_column_stats('s0', 'st0', 'dummy');
2675 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2676 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2681 DELETE FROM dbms_stats._relation_stats_locked;
2682 SELECT dbms_stats.lock_database_stats();
2683 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2686 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2687 SELECT dbms_stats.unlock_column_stats(NULL, 'st0', 'id');
2688 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2689 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2694 DELETE FROM dbms_stats._relation_stats_locked;
2695 SELECT dbms_stats.lock_database_stats();
2696 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2699 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2700 SELECT dbms_stats.unlock_column_stats('s0', NULL, 'id');
2701 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2702 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2707 DELETE FROM dbms_stats._relation_stats_locked;
2708 SELECT dbms_stats.lock_database_stats();
2709 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2712 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2713 SELECT dbms_stats.unlock_column_stats('s0', 'st0', NULL);
2714 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2715 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2720 DELETE FROM dbms_stats._relation_stats_locked;
2721 SELECT dbms_stats.lock_database_stats();
2722 SELECT relid::regclass FROM dbms_stats._relation_stats_locked
2725 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2727 SELECT relation::regclass, mode
2728 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
2729 WHERE mode LIKE '%ExclusiveLock%'
2730 ORDER BY relation::regclass::text, mode;
2731 SELECT dbms_stats.unlock_column_stats('s0', 'st0', 'id');
2732 SELECT relation::regclass, mode
2733 FROM pg_locks l join pg_class c on (l.relation = c.oid and c.relkind = 'r')
2734 WHERE mode LIKE '%ExclusiveLock%'
2735 ORDER BY relation::regclass::text, mode;
2737 SELECT starelid, attname, stainherit FROM columns_locked_v c;
2738 SELECT relid::regclass FROM dbms_stats._relation_stats_locked