vacumm.txt

text/plain

Filename: vacumm.txt
Type: text/plain
Part: 0
Message: Re: VACUUM ANALYZE - with debug
DEBUG:  --Relation pg_type--
DEBUG:  Pages 3: Changed 0, reaped 1, Empty 0, New 0; Tup 178: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 35, MinLen 106, MaxLen 109; Re-using: Free/Avail. Space 3972/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_type_oid_index: Pages 2; Tuples 178: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_type_typname_index: Pages 4; Tuples 178: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_attribute--
DEBUG:  Pages 17: Changed 0, reaped 1, Empty 0, New 0; Tup 1253: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 73, MinLen 98, MaxLen 98; Re-using: Free/Avail. Space 7360/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.01u sec.
DEBUG:  Index pg_attribute_relid_attnam_index: Pages 25; Tuples 1253: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_attribute_relid_attnum_index: Pages 12; Tuples 1253: Deleted 0. CPU 0.00s/0.01u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_class--
DEBUG:  Pages 3: Changed 0, reaped 2, Empty 0, New 0; Tup 158: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 40, MinLen 115, MaxLen 160; Re-using: Free/Avail. Space 3892/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_class_oid_index: Pages 4; Tuples 158: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_class_relname_index: Pages 7; Tuples 158: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_group--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_group_name_index: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_group_sysid_index: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_database--
DEBUG:  Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 4: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 1, MinLen 84, MaxLen 84; Re-using: Free/Avail. Space 7816/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_attrdef--
DEBUG:  Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 16: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 13, MinLen 141, MaxLen 396; Re-using: Free/Avail. Space 3856/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_attrdef_adrelid_index: Pages 2; Tuples 16: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_1215--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_toast_1215_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_trigger--
DEBUG:  Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 28: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 10, MinLen 152, MaxLen 214; Re-using: Free/Avail. Space 2144/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_trigger_tgconstrname_index: Pages 2; Tuples 28: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_trigger_tgconstrrelid_index: Pages 2; Tuples 28: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_trigger_tgrelid_index: Pages 2; Tuples 28: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_inherits--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_inherits_relid_seqno_index: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_index--
DEBUG:  Pages 2: Changed 0, reaped 1, Empty 0, New 0; Tup 66: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 30, MinLen 164, MaxLen 164; Re-using: Free/Avail. Space 5028/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_index_indrelid_index: Pages 2; Tuples 66: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_index_indexrelid_index: Pages 2; Tuples 66: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_operator--
DEBUG:  Pages 9: Changed 0, reaped 0, Empty 0, New 0; Tup 594: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 116, MaxLen 116; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_operator_oid_index: Pages 4; Tuples 594. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_operator_oprname_l_r_k_index: Pages 9; Tuples 594. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_opclass--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 29: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 68, MaxLen 68; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_opclass_deftype_index: Pages 2; Tuples 29. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_opclass_name_index: Pages 2; Tuples 29. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_am--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 4: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 148, MaxLen 148; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_am_name_index: Pages 2; Tuples 4. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_amop--
DEBUG:  Pages 2: Changed 0, reaped 0, Empty 0, New 0; Tup 169: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 46, MaxLen 46; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_amop_opid_index: Pages 2; Tuples 169. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_amop_strategy_index: Pages 2; Tuples 169. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_amproc--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 54: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 46, MaxLen 46; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_language--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 3: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 79, MaxLen 84; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_language_name_index: Pages 2; Tuples 3. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_language_oid_index: Pages 2; Tuples 3. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_largeobject--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_largeobject_loid_pn_index: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_aggregate--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 56: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 92, MaxLen 111; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_aggregate_name_type_index: Pages 2; Tuples 56. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_ipl--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_inheritproc--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_description--
DEBUG:  Pages 10: Changed 0, reaped 0, Empty 0, New 0; Tup 1177: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 42, MaxLen 110; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_description_objoid_index: Pages 6; Tuples 1177. CPU 0.00s/0.01u sec.
DEBUG:  --Relation pg_toast_17086--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_toast_17086_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_listener--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_listener_pid_relname_index: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_shadow--
DEBUG:  Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 3: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 2, MinLen 86, MaxLen 90; Re-using: Free/Avail. Space 7880/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_proc--
DEBUG:  Pages 28: Changed 0, reaped 0, Empty 0, New 0; Tup 1150: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 177, MaxLen 301; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_proc_oid_index: Pages 6; Tuples 1150. CPU 0.00s/0.01u sec.
DEBUG:  Index pg_proc_proname_narg_type_index: Pages 26; Tuples 1150. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_1255--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_toast_1255_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation language--
DEBUG:  Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 4: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 16, MinLen 66, MaxLen 70; Re-using: Free/Avail. Space 7816/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index language_pkey: Pages 2; Tuples 4: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index language_shortcut_key: Pages 2; Tuples 4: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index language_lang_name_key: Pages 2; Tuples 4: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_20091--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_toast_20091_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pga_queries--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_18732--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_toast_18732_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pga_forms--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_18763--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_toast_18763_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation files--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index files_pkey: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_20460--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_toast_20460_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation gal_text--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index gal_text_pkey: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index gal_text_gal_name_key: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_relcheck--
DEBUG:  Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 3: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 6, MinLen 832, MaxLen 834; Re-using: Free/Avail. Space 5636/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_relcheck_rcrelid_index: Pages 2; Tuples 3: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_1216--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_toast_1216_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation gallery--
DEBUG:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index gallery_pkey: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_rewrite--
DEBUG:  Pages 3: Changed 0, reaped 0, Empty 0, New 0; Tup 16: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 116, MaxLen 1965; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_rewrite_oid_index: Pages 2; Tuples 16. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_rewrite_rulename_index: Pages 2; Tuples 16. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_17058--
DEBUG:  Pages 2: Changed 0, reaped 0, Empty 0, New 0; Tup 7: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 102, MaxLen 2034; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_toast_17058_idx: Pages 2; Tuples 7. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
Server process (pid 13150) exited with status 139 at Mon Aug  6 10:04:43 2001
Terminating any active server processes...
Server processes were terminated at Mon Aug  6 10:04:43 2001
Reinitializing shared memory and semaphores
The Data Base System is starting up
DEBUG:  database system was interrupted at 2001-08-06 09:55:48 IDT
DEBUG:  CheckPoint record at (0, 8392012)
DEBUG:  Redo record at (0, 8392012); Undo record at (0, 0); Shutdown TRUE
DEBUG:  NextTransactionId: 4624; NextOid: 43300
DEBUG:  database system was not properly shut down; automatic recovery in progress...
DEBUG:  redo starts at (0, 8392076)
DEBUG:  ReadRecord: record with zero len at (0, 8564868)
DEBUG:  redo done at (0, 8564832)
DEBUG:  database system is in production state