I did this (I should stop c&p'ing this silly little setup code sometime):
create table t (a int) partition by hash (a);
create table t1 partition of t for values with (modulus 10, remainder 0);
create table t2 partition of t for values with (modulus 10, remainder 1);
create table t3 partition of t for values with (modulus 10, remainder 2);
create table t4 partition of t for values with (modulus 10, remainder 3);
create table t5 partition of t for values with (modulus 10, remainder 4);
create table t6 partition of t for values with (modulus 10, remainder 5);
create table t7 partition of t for values with (modulus 10, remainder 6);
create table t8 partition of t for values with (modulus 10, remainder 7);
create table t9 partition of t for values with (modulus 10, remainder 8);
create table t10 partition of t for values with (modulus 10, remainder 9);
insert into t select * from generate_series(1, 100 * 1000 * 1000);
Here's a complete report for CIC on a partition (since partitioned tables don't
support CIC anyway):
select relid::regclass, phase,
format('lockers: %s/%s (%s)', lockers_done, lockers_total,
current_locker_pid) as lockers,
format('blocks: %s/%s', blocks_done, blocks_total) as blocks,
format('tuples: %s/%s', tuples_done, tuples_total) as tuples,
format('partitions: %s/%s', partitions_done, partitions_total) as
partitions
from pg_stat_progress_create_index
\watch 0,1
lun 01 abr 2019 19:02:31 -03 (cada 0,1s)
relid | phase | lockers | blocks |
tuples | partitions
-------+--------------------------------+------------------+------------------+-------------+-----------------
t2 | building index: scanning table | lockers: 0/0 (0) | blocks: 86/44254 |
tuples: 0/0 | partitions: 0/0
t2 | building index: scanning table | lockers: 0/0 (0) | blocks: 4639/44254
| tuples: 0/0 | partitions: 0/0
t2 | building index: scanning table | lockers: 0/0 (0) | blocks:
10890/44254 | tuples: 0/0 | partitions: 0/0
t2 | building index: scanning table | lockers: 0/0 (0) | blocks:
17841/44254 | tuples: 0/0 | partitions: 0/0
t2 | building index: scanning table | lockers: 0/0 (0) | blocks:
22899/44254 | tuples: 0/0 | partitions: 0/0
t2 | building index: scanning table | lockers: 0/0 (0) | blocks:
29668/44254 | tuples: 0/0 | partitions: 0/0
t2 | building index: scanning table | lockers: 0/0 (0) | blocks:
35531/44254 | tuples: 0/0 | partitions: 0/0
t2 | building index: scanning table | lockers: 0/0 (0) | blocks:
41375/44254 | tuples: 0/0 | partitions: 0/0
t2 | building index: scanning table | lockers: 0/0 (0) | blocks:
44254/44254 | tuples: 0/0 | partitions: 0/0
t2 | building index: scanning table | lockers: 0/0 (0) | blocks:
44254/44254 | tuples: 0/0 | partitions: 0/0
t2 | building index: scanning table | lockers: 0/0 (0) | blocks:
44254/44254 | tuples: 0/0 | partitions: 0/0
t2 | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 291737/10001366 | partitions: 0/0
t2 | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1652429/10001366 | partitions: 0/0
t2 | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2984365/10001366 | partitions: 0/0
t2 | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4139066/10001366 | partitions: 0/0
t2 | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5463784/10001366 | partitions: 0/0
t2 | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6699498/10001366 | partitions: 0/0
t2 | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7947694/10001366 | partitions: 0/0
t2 | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9311113/10001366 | partitions: 0/0
t2 | index validation: scan index | lockers: 0/0 (0) | blocks: 2542/27426 |
tuples: 0/0 | partitions: 0/0
t2 | index validation: scan index | lockers: 0/0 (0) | blocks: 7667/27426 |
tuples: 0/0 | partitions: 0/0
t2 | index validation: scan index | lockers: 0/0 (0) | blocks: 15334/27426
| tuples: 0/0 | partitions: 0/0
t2 | index validation: scan index | lockers: 0/0 (0) | blocks: 23001/27426
| tuples: 0/0 | partitions: 0/0
t2 | index validation: sort index scan results | lockers: 0/0 (0) | blocks:
0/0 | tuples: 0/0 | partitions: 0/0
t2 | index validation: scan heap | lockers: 0/0 (0) | blocks: 2586/44254 |
tuples: 0/0 | partitions: 0/0
t2 | index validation: scan heap | lockers: 0/0 (0) | blocks: 8180/44254 |
tuples: 0/0 | partitions: 0/0
t2 | index validation: scan heap | lockers: 0/0 (0) | blocks: 13807/44254 |
tuples: 0/0 | partitions: 0/0
t2 | index validation: scan heap | lockers: 0/0 (0) | blocks: 19365/44254 |
tuples: 0/0 | partitions: 0/0
t2 | index validation: scan heap | lockers: 0/0 (0) | blocks: 24990/44254 |
tuples: 0/0 | partitions: 0/0
t2 | index validation: scan heap | lockers: 0/0 (0) | blocks: 30943/44254 |
tuples: 0/0 | partitions: 0/0
t2 | index validation: scan heap | lockers: 0/0 (0) | blocks: 36817/44254 |
tuples: 0/0 | partitions: 0/0
t2 | index validation: scan heap | lockers: 0/0 (0) | blocks: 43025/44254 |
tuples: 0/0 | partitions: 0/0
Here's the report for building the index on the partitioned table, same query,
this time \watch 0,05:
t | building index: scanning table | lockers: 0/0 (0) | blocks:
168/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
2022/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
4378/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
6419/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
8599/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
10955/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
12976/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
15627/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
17389/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
20213/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
22351/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
24788/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
26880/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
29382/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
31289/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
33826/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
35815/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
38415/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
40335/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
43002/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 361108/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1054447/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1749066/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2433169/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3129578/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3626695/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4308212/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5001391/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5698987/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6391459/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6894091/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7593037/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8286403/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8974321/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9667525/9996429 | partitions: 0/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9996429/9996429 | partitions: 0/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
2476/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
4639/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
6717/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
8952/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
11245/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
13361/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
15777/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
17716/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
20335/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
22114/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
24831/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
26529/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
29405/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
31153/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
33981/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
35595/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
38511/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
40114/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
43040/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44254/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44254/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44254/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44254/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44254/44254 | tuples: 0/0 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44254/44254 | tuples: 0/0 | partitions: 1/10
t | building index: sorting live tuples | lockers: 0/0 (0) | blocks:
0/0 | tuples: 0/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 500779/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1201309/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1883508/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2582863/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3258358/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3750979/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4430740/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5105701/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5798905/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6484789/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6992211/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7689065/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8391543/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9087049/10001366 | partitions: 1/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9764485/10001366 | partitions: 1/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
269/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
2861/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
4639/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
6016/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
8266/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
9916/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
12793/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
14423/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
17302/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
18936/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
21837/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
23480/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
26369/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
27993/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
30891/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
32525/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
35357/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
37096/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
39846/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
41645/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44276/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44276/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44276/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44276/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44276/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44276/44276 | tuples: 0/0 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44276/44276 | tuples: 0/0 | partitions: 2/10
t | building index: sorting live tuples | lockers: 0/0 (0) | blocks:
0/0 | tuples: 0/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 663688/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1355654/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2057087/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2764765/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3377603/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3987118/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4685206/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5387918/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6091400/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6694322/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7304995/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7984067/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8672517/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9351567/10006231 | partitions: 2/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 10006230/10006231 | partitions: 2/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
1178/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
3833/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
5288/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
8125/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
9760/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
12663/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
14323/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
17252/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
18880/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
21807/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
23444/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
26360/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
28008/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
30932/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
32587/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
35375/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
37090/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
39827/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
41657/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44255/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44255/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44255/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44255/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44255/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44255/44255 | tuples: 0/0 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44255/44255 | tuples: 0/0 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 118053/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 820650/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1512165/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2201720/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2883192/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3388429/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4077607/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4770319/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5453432/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6130568/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6725569/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7327477/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7989790/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8685547/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9365865/10001417 | partitions: 3/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9981553/10001417 | partitions: 3/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
1060/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
3570/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
4880/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
7585/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
9172/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
12060/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
13670/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
16529/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
18132/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
20976/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
22557/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
25393/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
26973/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
29800/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
31372/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
34214/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
35789/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
38667/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
39728/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
40861/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
43730/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 4/10
t | building index: sorting live tuples | lockers: 0/0 (0) | blocks:
0/0 | tuples: 0/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 518863/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1211461/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1907959/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2597929/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3285807/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3804693/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4495350/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5195042/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5890039/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6587559/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7097473/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7786066/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8480443/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9174157/10002444 | partitions: 4/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9855283/10002444 | partitions: 4/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
559/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
3158/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
4639/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
7416/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
9069/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
11908/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
13567/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
16473/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
18147/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
21024/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
22690/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
25582/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
27239/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
30148/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
31812/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
34722/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
36378/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
39290/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
40959/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
43844/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44249/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44249/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44249/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44249/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44249/44249 | tuples: 0/0 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44249/44249 | tuples: 0/0 | partitions: 5/10
t | building index: sorting live tuples | lockers: 0/0 (0) | blocks:
0/0 | tuples: 0/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 701199/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1386576/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2026138/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2686458/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3328278/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3886189/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4566129/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5250205/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5936354/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6632954/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7131820/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7801535/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8472974/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9122825/10000082 | partitions: 5/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9801504/10000082 | partitions: 5/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
429/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
3011/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
4639/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
7332/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
8987/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
11878/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
13537/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
16425/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
18106/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
21040/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
22718/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
25635/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
27312/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
30215/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
31876/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
34800/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
36455/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
39359/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
41032/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
43943/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44220/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44220/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44220/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44220/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44220/44220 | tuples: 0/0 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44220/44220 | tuples: 0/0 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 25987/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 732379/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1424513/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2081443/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2704663/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3342516/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3812257/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4489696/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5146693/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5833638/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6524497/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7029547/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7715519/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8417783/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9099477/9993603 | partitions: 6/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9781549/9993603 | partitions: 6/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
368/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
2921/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
4639/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
7160/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
8878/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
11603/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
13265/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
16175/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
17962/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
20751/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
22442/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
25320/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
26957/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
29858/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
31467/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
34382/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
36023/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
38874/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
40532/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
43439/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44259/44259 | tuples: 0/0 | partitions: 7/10
t | building index: sorting live tuples | lockers: 0/0 (0) | blocks:
0/0 | tuples: 0/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 560347/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1248199/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1947121/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2634011/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3308164/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3829093/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4522592/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5201695/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5894625/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6592741/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7108453/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7782573/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8433007/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9098304/10002524 | partitions: 7/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9769812/10002524 | partitions: 7/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
300/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
2880/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
4639/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
7121/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
8974/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
11610/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
13440/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
16136/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
17879/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
20700/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
22293/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
25260/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
26863/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
29775/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
31406/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
34318/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
35974/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
38869/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
40507/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
43431/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44232/44232 | tuples: 0/0 | partitions: 8/10
t | building index: sorting live tuples | lockers: 0/0 (0) | blocks:
0/0 | tuples: 0/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 556257/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1261969/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1962859/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2666023/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3351782/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3870067/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4467186/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5040844/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5596873/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6273009/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6744020/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7260343/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7836896/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8362115/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8982007/9996288 | partitions: 8/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9683282/9996288 | partitions: 8/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
257/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
2853/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
4639/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
7071/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
8961/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
11536/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
13377/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
16115/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
17798/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
20649/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
22334/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
25185/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
26818/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
29740/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
31283/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
34208/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
35835/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
38531/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
39637/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
41722/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44082/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44247/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44247/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44247/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44247/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44247/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44247/44247 | tuples: 0/0 | partitions: 9/10
t | building index: scanning table | lockers: 0/0 (0) | blocks:
44247/44247 | tuples: 0/0 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 89251/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 724681/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1352185/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 1978963/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 2545165/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3116125/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 3495200/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4038079/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 4612813/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5239737/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 5738502/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6336605/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 6779349/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 7417770/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8041496/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 8722536/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9142846/9999616 | partitions: 9/10
t | building index: loading tuples in tree | lockers: 0/0 (0) | blocks:
0/0 | tuples: 9782646/9999616 | partitions: 9/10
I think this is working well enough.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
