Re: monitoring CREATE INDEX [CONCURRENTLY]
| От | Alvaro Herrera |
|---|---|
| Тема | Re: monitoring CREATE INDEX [CONCURRENTLY] |
| Дата | |
| Msg-id | 20190401221446.GA32478@alvherre.pgsql обсуждение исходный текст |
| Ответ на | Re: monitoring CREATE INDEX [CONCURRENTLY] (Rahila Syed <rahila.syed@2ndquadrant.com>) |
| Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления:
Следующее
От: Peter GeogheganДата:
Сообщение: Re: Making all nbtree entries unique by having heap TIDs participatein comparisons