When an index is created on a populated table, YugabyteDB automatically backfills the existing data into the index.
In most cases, this uses an online schema migration.
You can monitor the index backfill via the YugabyteDB Master UI on the Tasks page.
Example:
You can also monitor an index backfill via the command line using a tool like lynx.
Example (while backfill is running):
[root@localhost ~]# lynx http://yb_master_ip_address:7000/tasks -dump | grep -A 1 -m 1 Backfill
Backfill Index Table kRunning 1.89 s ago 1.89 s Backfilling indexes {
idx2_movements_uuid } for tablet bb6e673270e44e4a9297a71f88e7acc3 from
Example (when backfill is done):
[root@localhost ~]# lynx http://yb_master_ip_address:7000/tasks -dump | grep -A 1 -m 1 Backfill
Backfill Table kComplete 2.78 min ago 31.2 s Backfilling {
idx2_movements_uuid } Done
Have Fun!
