pgbench_index_after_128_10min.txt
text/plain
Filename: pgbench_index_after_128_10min.txt
Type: text/plain
Part: 0
idx | level | l_item | blkno | btpo_prev | btpo_next | btpo_flags | type | live_items | dead_items | avg_item_size | page_size | free_size | highkey -----------------------+-------+--------+-------+-----------+-----------+------------+------+------------+------------+---------------+-----------+-----------+------------------------- pgbench_accounts_pkey | 2 | 1 | 290 | 0 | 0 | 2 | r | 10 | 0 | 15 | 8192 | 7956 | pgbench_accounts_pkey | 1 | 1 | 3 | 0 | 289 | 0 | i | 296 | 0 | 15 | 8192 | 2236 | 09 96 01 00 00 00 00 00 pgbench_accounts_pkey | 1 | 2 | 289 | 3 | 575 | 0 | i | 285 | 0 | 15 | 8192 | 2456 | 11 2c 03 00 00 00 00 00 pgbench_accounts_pkey | 1 | 3 | 575 | 289 | 860 | 0 | i | 285 | 0 | 15 | 8192 | 2456 | 19 c2 04 00 00 00 00 00 pgbench_accounts_pkey | 1 | 4 | 860 | 575 | 1145 | 0 | i | 285 | 0 | 15 | 8192 | 2456 | 21 58 06 00 00 00 00 00 pgbench_accounts_pkey | 1 | 5 | 1145 | 860 | 1430 | 0 | i | 285 | 0 | 15 | 8192 | 2456 | 29 ee 07 00 00 00 00 00 pgbench_accounts_pkey | 1 | 6 | 1430 | 1145 | 1715 | 0 | i | 285 | 0 | 15 | 8192 | 2456 | 31 84 09 00 00 00 00 00 pgbench_accounts_pkey | 1 | 7 | 1715 | 1430 | 2000 | 0 | i | 285 | 0 | 15 | 8192 | 2456 | 39 1a 0b 00 00 00 00 00 pgbench_accounts_pkey | 1 | 8 | 2000 | 1715 | 2285 | 0 | i | 285 | 0 | 15 | 8192 | 2456 | 41 b0 0c 00 00 00 00 00 pgbench_accounts_pkey | 1 | 9 | 2285 | 2000 | 2570 | 0 | i | 285 | 0 | 15 | 8192 | 2456 | 49 46 0e 00 00 00 00 00 pgbench_accounts_pkey | 1 | 10 | 2570 | 2285 | 0 | 0 | i | 177 | 0 | 15 | 8192 | 4616 | pgbench_accounts_pkey | 0 | 1 | 1 | 0 | 2751 | 65 | l | 100 | 41 | 16 | 8192 | 5328 | 11 00 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 2 | 2751 | 1 | 2746 | 65 | l | 48 | 90 | 16 | 8192 | 5388 | 32 00 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 3 | 2746 | 2751 | 2749 | 65 | l | 47 | 6 | 16 | 8192 | 7088 | 5f 00 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 4 | 2749 | 2746 | 2745 | 65 | l | 57 | 5 | 16 | 8192 | 6908 | 97 00 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 5 | 2745 | 2749 | 2748 | 65 | l | 91 | 11 | 16 | 8192 | 6108 | eb 00 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 6 | 2748 | 2745 | 2752 | 1 | l | 65 | 0 | 16 | 8192 | 6848 | 28 01 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 7 | 2752 | 2748 | 2 | 65 | l | 73 | 1 | 16 | 8192 | 6668 | 6f 01 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 8 | 2 | 2752 | 2753 | 65 | l | 69 | 5 | 16 | 8192 | 6668 | b3 01 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 9 | 2753 | 2 | 2747 | 65 | l | 91 | 5 | 16 | 8192 | 6228 | 0a 02 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 10 | 2747 | 2753 | 2754 | 65 | l | 87 | 9 | 16 | 8192 | 6228 | 5e 02 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 11 | 2754 | 2747 | 4 | 65 | l | 130 | 26 | 16 | 8192 | 5028 | dd 02 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 12 | 4 | 2754 | 2750 | 65 | l | 174 | 14 | 16 | 8192 | 4388 | 7d 03 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 13 | 2750 | 4 | 5 | 65 | l | 219 | 18 | 16 | 8192 | 3408 | 4b 04 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 14 | 5 | 2750 | 2755 | 65 | l | 157 | 5 | 16 | 8192 | 4908 | e8 04 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 15 | 2755 | 5 | 6 | 65 | l | 214 | 17 | 16 | 8192 | 3528 | b9 05 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 16 | 6 | 2755 | 7 | 65 | l | 371 | 8 | 16 | 8192 | 568 | 27 07 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 17 | 7 | 6 | 8 | 65 | l | 370 | 2 | 16 | 8192 | 708 | 95 08 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 18 | 8 | 7 | 9 | 65 | l | 366 | 3 | 16 | 8192 | 768 | 03 0a 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 19 | 9 | 8 | 10 | 65 | l | 368 | 1 | 16 | 8192 | 768 | 71 0b 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 20 | 10 | 9 | 11 | 65 | l | 367 | 2 | 16 | 8192 | 768 | df 0c 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 21 | 11 | 10 | 12 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 4d 0e 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 22 | 12 | 11 | 13 | 1 | l | 367 | 0 | 16 | 8192 | 808 | bb 0f 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 23 | 13 | 12 | 14 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 29 11 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 24 | 14 | 13 | 15 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 97 12 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 25 | 15 | 14 | 16 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 05 14 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 26 | 16 | 15 | 17 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 73 15 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 27 | 17 | 16 | 18 | 1 | l | 367 | 0 | 16 | 8192 | 808 | e1 16 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 28 | 18 | 17 | 19 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 4f 18 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 29 | 19 | 18 | 20 | 1 | l | 367 | 0 | 16 | 8192 | 808 | bd 19 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 30 | 20 | 19 | 21 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 2b 1b 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 31 | 21 | 20 | 22 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 99 1c 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 32 | 22 | 21 | 23 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 07 1e 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 33 | 23 | 22 | 24 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 75 1f 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 34 | 24 | 23 | 25 | 1 | l | 367 | 0 | 16 | 8192 | 808 | e3 20 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 35 | 25 | 24 | 26 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 51 22 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 36 | 26 | 25 | 27 | 1 | l | 367 | 0 | 16 | 8192 | 808 | bf 23 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 37 | 27 | 26 | 28 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 2d 25 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 38 | 28 | 27 | 29 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 9b 26 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 39 | 29 | 28 | 30 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 09 28 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 40 | 30 | 29 | 31 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 77 29 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 41 | 31 | 30 | 32 | 1 | l | 367 | 0 | 16 | 8192 | 808 | e5 2a 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 42 | 32 | 31 | 33 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 53 2c 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 43 | 33 | 32 | 34 | 1 | l | 367 | 0 | 16 | 8192 | 808 | c1 2d 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 44 | 34 | 33 | 35 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 2f 2f 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 45 | 35 | 34 | 36 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 9d 30 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 46 | 36 | 35 | 37 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 0b 32 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 47 | 37 | 36 | 38 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 79 33 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 48 | 38 | 37 | 39 | 1 | l | 367 | 0 | 16 | 8192 | 808 | e7 34 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 49 | 39 | 38 | 40 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 55 36 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 50 | 40 | 39 | 41 | 1 | l | 367 | 0 | 16 | 8192 | 808 | c3 37 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 51 | 41 | 40 | 42 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 31 39 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 52 | 42 | 41 | 43 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 9f 3a 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 53 | 43 | 42 | 44 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 0d 3c 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 54 | 44 | 43 | 45 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 7b 3d 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 55 | 45 | 44 | 46 | 1 | l | 367 | 0 | 16 | 8192 | 808 | e9 3e 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 56 | 46 | 45 | 47 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 57 40 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 57 | 47 | 46 | 48 | 1 | l | 367 | 0 | 16 | 8192 | 808 | c5 41 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 58 | 48 | 47 | 49 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 33 43 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 59 | 49 | 48 | 50 | 1 | l | 367 | 0 | 16 | 8192 | 808 | a1 44 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 60 | 50 | 49 | 51 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 0f 46 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 61 | 51 | 50 | 52 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 7d 47 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 62 | 52 | 51 | 53 | 1 | l | 367 | 0 | 16 | 8192 | 808 | eb 48 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 63 | 53 | 52 | 54 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 59 4a 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 64 | 54 | 53 | 55 | 1 | l | 367 | 0 | 16 | 8192 | 808 | c7 4b 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 65 | 55 | 54 | 56 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 35 4d 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 66 | 56 | 55 | 57 | 1 | l | 367 | 0 | 16 | 8192 | 808 | a3 4e 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 67 | 57 | 56 | 58 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 11 50 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 68 | 58 | 57 | 59 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 7f 51 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 69 | 59 | 58 | 60 | 1 | l | 367 | 0 | 16 | 8192 | 808 | ed 52 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 70 | 60 | 59 | 61 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 5b 54 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 71 | 61 | 60 | 62 | 1 | l | 367 | 0 | 16 | 8192 | 808 | c9 55 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 72 | 62 | 61 | 63 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 37 57 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 73 | 63 | 62 | 64 | 1 | l | 367 | 0 | 16 | 8192 | 808 | a5 58 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 74 | 64 | 63 | 65 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 13 5a 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 75 | 65 | 64 | 66 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 81 5b 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 76 | 66 | 65 | 67 | 1 | l | 367 | 0 | 16 | 8192 | 808 | ef 5c 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 77 | 67 | 66 | 68 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 5d 5e 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 78 | 68 | 67 | 69 | 1 | l | 367 | 0 | 16 | 8192 | 808 | cb 5f 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 79 | 69 | 68 | 70 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 39 61 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 80 | 70 | 69 | 71 | 1 | l | 367 | 0 | 16 | 8192 | 808 | a7 62 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 81 | 71 | 70 | 72 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 15 64 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 82 | 72 | 71 | 73 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 83 65 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 83 | 73 | 72 | 74 | 1 | l | 367 | 0 | 16 | 8192 | 808 | f1 66 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 84 | 74 | 73 | 75 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 5f 68 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 85 | 75 | 74 | 76 | 1 | l | 367 | 0 | 16 | 8192 | 808 | cd 69 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 86 | 76 | 75 | 77 | 1 | l | 367 | 0 | 16 | 8192 | 808 | 3b 6b 00 00 00 00 00 00 pgbench_accounts_pkey | 0 | 87 | 77 | 76 | 78 | 1 | l | 367 | 0 | 16 | 8192 | 808 | a9 6c 00 00 00 00 00 00