pg_type_typname_nsp_index_index_example_log.txt

 2023-06-07 23:46:15.130 PDT [260646][client backend] [pg_regress/insert][6/681:2269] LOG:  simple deletion of index "pg_type_typname_nsp_index", block 6:
	n_tup: 251, including high key
	first: (typname, typnamespace)=(column_column_usage, 13858)
	h_key: (typname, typnamespace)=(pg_largeobject)
	finished up on heap block 28 (having accessed 4 blocks in total)
	 10. (typname, typnamespace)=(copydml_test, 2200) w TID (25,3) will be deleted freeing 36 
	 28. (typname, typnamespace)=(enumtest, 2200) w TID (18,7) will be deleted freeing 28 
	 29. (typname, typnamespace)=(enumtest_bogus_child, 2200) w TID (18,21) will be deleted freeing 44 
	 30. (typname, typnamespace)=(enumtest_child, 2200) w TID (18,17) will be deleted freeing 36 
	 31. (typname, typnamespace)=(enumtest_parent, 2200) w TID (18,13) will be deleted freeing 36 
	 43. (typname, typnamespace)=(float8range_test, 2200) w TID (18,43) will be deleted freeing 36 
	 54. (typname, typnamespace)=(hash_parted, 2200) w TID (27,34) will be deleted freeing 28 
	 56. (typname, typnamespace)=(hpart0, 2200) w TID (27,36) will be deleted freeing 28 
	 57. (typname, typnamespace)=(hpart1, 2200) w TID (27,38) will be deleted freeing 28 
	 58. (typname, typnamespace)=(hpart2, 2200) w TID (27,40) will be deleted freeing 28 
	 59. (typname, typnamespace)=(hpart3, 2200) w TID (27,42) will be deleted freeing 28 
	 61. (typname, typnamespace)=(i8r_array, 2200) w TID (18,61) will be deleted freeing 28 
	 68. (typname, typnamespace)=(insert_test_type, 2200) w TID (25,15) will be deleted freeing 36 
	 73. (typname, typnamespace)=(inserttest, 2200) w TID (25,1) will be deleted freeing 28 (LP_DEAD bit set)
	 74. (typname, typnamespace)=(inserttest, 2200) w TID (25,17) will be deleted freeing 28 
	 75. (typname, typnamespace)=(inserttest2, 2200) w TID (25,19) will be deleted freeing 28 
	104. (typname, typnamespace)=(large_tuple_test, 2200) w TID (25,9) will be deleted freeing 36 
	107. (typname, typnamespace)=(list_parted, 2200) w TID (25,31) will be deleted freeing 28 (LP_DEAD bit set)
	108. (typname, typnamespace)=(list_parted, 2200) w TID (27,44) will be deleted freeing 28 
	109. (typname, typnamespace)=(lparted_nonullpart, 2200) w TID (27,54) will be deleted freeing 36 
	110. (typname, typnamespace)=(lparted_nonullpart_a, 2200) w TID (27,56) will be deleted freeing 44 
	124. (typname, typnamespace)=(mlparted5, 2200) w TID (27,66) will be deleted freeing 28 (LP_DEAD bit set)
	128. (typname, typnamespace)=(mlparted5a, 2200) w TID (27,68) will be deleted freeing 28 
	136. (typname, typnamespace)=(mydomain, 2200) w TID (18,45) will be deleted freeing 28 (LP_DEAD bit set)
	138. (typname, typnamespace)=(mydomainmultirange, 2200) w TID (18,48) will be deleted freeing 36 (LP_DEAD bit set)
	140. (typname, typnamespace)=(mydomainrange, 2200) w TID (18,47) will be deleted freeing 36 (LP_DEAD bit set)
	166. (typname, typnamespace)=(numrange_test2, 2200) w TID (18,9) will be deleted freeing 36 
	173. (typname, typnamespace)=(part1, 2200) w TID (25,23) will be deleted freeing 28 
	174. (typname, typnamespace)=(part2, 2200) w TID (25,25) will be deleted freeing 28 
	175. (typname, typnamespace)=(part3, 2200) w TID (25,27) will be deleted freeing 28 
	176. (typname, typnamespace)=(part4, 2200) w TID (25,29) will be deleted freeing 28 
	177. (typname, typnamespace)=(part_aa_bb, 2200) w TID (25,33) will be deleted freeing 28 
	178. (typname, typnamespace)=(part_cc_dd, 2200) w TID (25,35) will be deleted freeing 28 
	179. (typname, typnamespace)=(part_def, 2200) w TID (27,16) will be deleted freeing 28 
	180. (typname, typnamespace)=(part_default, 2200) w TID (27,2) will be deleted freeing 36 (LP_DEAD bit set)
	181. (typname, typnamespace)=(part_default, 2200) w TID (27,10) will be deleted freeing 36 (LP_DEAD bit set)
	182. (typname, typnamespace)=(part_default, 2200) w TID (27,46) will be deleted freeing 36 
	183. (typname, typnamespace)=(part_default_p1, 2200) w TID (27,12) will be deleted freeing 36 
	184. (typname, typnamespace)=(part_default_p2, 2200) w TID (27,14) will be deleted freeing 36 
	185. (typname, typnamespace)=(part_ee_ff, 2200) w TID (25,39) will be deleted freeing 28 
	186. (typname, typnamespace)=(part_ee_ff1, 2200) w TID (25,41) will be deleted freeing 28 
	187. (typname, typnamespace)=(part_ee_ff2, 2200) w TID (25,43) will be deleted freeing 28 
	188. (typname, typnamespace)=(part_ee_ff3, 2200) w TID (27,28) will be deleted freeing 28 
	189. (typname, typnamespace)=(part_ee_ff3_1, 2200) w TID (27,30) will be deleted freeing 36 
	190. (typname, typnamespace)=(part_ee_ff3_2, 2200) w TID (27,32) will be deleted freeing 36 
	191. (typname, typnamespace)=(part_gg, 2200) w TID (27,18) will be deleted freeing 28 
	192. (typname, typnamespace)=(part_gg1, 2200) w TID (27,20) will be deleted freeing 28 
	193. (typname, typnamespace)=(part_gg2, 2200) w TID (27,22) will be deleted freeing 28 
	194. (typname, typnamespace)=(part_gg2_1, 2200) w TID (27,24) will be deleted freeing 28 
	195. (typname, typnamespace)=(part_gg2_2, 2200) w TID (27,26) will be deleted freeing 28 
	196. (typname, typnamespace)=(part_null, 2200) w TID (25,37) will be deleted freeing 28 
	197. (typname, typnamespace)=(part_xx_yy, 2200) w TID (27,4) will be deleted freeing 28 
	198. (typname, typnamespace)=(part_xx_yy_defpart, 2200) w TID (27,8) will be deleted freeing 36 
	199. (typname, typnamespace)=(part_xx_yy_p1, 2200) w TID (27,6) will be deleted freeing 36 
	results: checked 70 tids out of 250 on page (28.00% of total on page), of which 54 (21.60% of total on page) deleted
	results: deleted tids plain 54, deleted tids posting 0, pagelsn: 0/3303FD8
	results: exact free space 1716, exact TIDs deleted 54/LP_DEAD tuples 8 (RR 6.75), LP_DEAD-related table blocks 4
 2023-06-07 23:46:15.130 PDT [260646][client backend] [pg_regress/insert][6/681:2269] STATEMENT:  create table mlparted5_a partition of mlparted5_ab for values in ('a');