> On 13 Jul 2017, at 23:13, Peter Geoghegan <p...@bowt.ie> wrote:
>
> I just figured out that "result.txt" is only a 60 second pgbench run.
> Is the same true for other tests?
Yes, other tests ran 60 seconds too.
>
> It would be much more interesting to see runs that lasted 10 minutes
> or more.
I am attaching results of tests for 32 and 128 clients that were running for 10
minutes, and TPS remains 305 and 115 ktps respectively.
Tests was executed with configuration set for YCSB. And there is very
aggressively autovacuum, this can be reason why there is no decline appears
with increasing working time.
Autovacuum config:
autovacuum_max_workers = 8
autovacuum_naptime = 10s
autovacuum_vacuum_scale_factor = 0.1
autovacuum_vacuum_cost_delay = 0ms
autovacuum_vacuum_cost_limit = 10000
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
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 | 2752 |
65 | l | 22 | 164 | 16 | 8192 | 4428 |
15 00 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 2 | 2752 | 1 | 2747 |
65 | l | 43 | 112 | 16 | 8192 | 5048 |
3f 00 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 3 | 2747 | 2752 | 2751 |
65 | l | 38 | 341 | 16 | 8192 | 568 |
64 00 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 4 | 2751 | 2747 | 2745 |
65 | l | 52 | 116 | 16 | 8192 | 4788 |
97 00 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 5 | 2745 | 2751 | 2748 |
65 | l | 88 | 188 | 16 | 8192 | 2628 |
ee 00 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 6 | 2748 | 2745 | 2754 |
65 | l | 61 | 100 | 16 | 8192 | 4928 |
2a 01 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 7 | 2754 | 2748 | 2 |
65 | l | 70 | 12 | 16 | 8192 | 6508 |
6f 01 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 8 | 2 | 2754 | 2755 |
65 | l | 69 | 246 | 16 | 8192 | 1848 |
b3 01 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 9 | 2755 | 2 | 2746 |
65 | l | 89 | 256 | 16 | 8192 | 1248 |
0c 02 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 10 | 2746 | 2755 | 2750 |
65 | l | 88 | 216 | 16 | 8192 | 2068 |
62 02 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 11 | 2750 | 2746 | 4 |
65 | l | 124 | 229 | 16 | 8192 | 1088 |
dd 02 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 12 | 4 | 2750 | 2749 |
65 | l | 162 | 199 | 16 | 8192 | 928 |
7f 03 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 13 | 2749 | 4 | 5 |
65 | l | 205 | 2 | 16 | 8192 | 4008 |
4b 04 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 14 | 5 | 2749 | 2753 |
65 | l | 178 | 124 | 16 | 8192 | 2108 |
fc 04 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 15 | 2753 | 5 | 6 |
65 | l | 190 | 99 | 16 | 8192 | 2368 |
b9 05 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 16 | 6 | 2753 | 7 |
65 | l | 368 | 38 | 16 | 8192 | 28 |
27 07 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 17 | 7 | 6 | 8 |
65 | l | 366 | 30 | 16 | 8192 | 228 |
95 08 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 18 | 8 | 7 | 9 |
65 | l | 367 | 37 | 16 | 8192 | 68 |
03 0a 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 19 | 9 | 8 | 10 |
65 | l | 367 | 1 | 16 | 8192 | 788 |
71 0b 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 20 | 10 | 9 | 11 |
65 | l | 367 | 1 | 16 | 8192 | 788 |
df 0c 00 00 00 00 00 00
pgbench_accounts_pkey | 0 | 21 | 11 | 10 | 12 |
65 | l | 367 | 2 | 16 | 8192 | 768 |
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
—
Thanks and Regards,
Alik Khilazhev
Postgres Professional:
http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
