Monitoring
You can monitor the progress of building a PostgreSQL index by querying the pgstatprogresscreateindex view.
You can monitor the progress of building a PostgreSQL index by querying the pg_stat_progress_create_index view.
Reference
Phases (vchordrq)
vchordrq
There are 5 steps in the index construction process of vchordrq. The phase name of each step are as follows:
| Step | Message | Description | Waiting time |
|---|---|---|---|
| 1 | initializing |
Start building index | Short |
| 2 | initializing index, by default build |
This step is only for default build | Short |
| 2 | initializing index, by internal build |
This step is only for internal build. It involves table sampling and performing partitioning to obtain centroids | Long |
| 2 | initializing index, by external build |
This step is only for external build. It loads centroids from a specified table | Short |
| 3 | initializing index |
Initialize the data structure and storage of the index | Short |
| 4 | inserting tuples from table to index |
Assign all vectors to their corresponding lists | Long |
| 5 | compacting tuples in index |
Optimize the structure of the vector index to enhance performance | Medium |
The 4th step, inserting tuples from table to index, takes up the majority of the time during index construction. The tuples_done, blocks_done and blocks_total columns indicate the progress of this step.
Phases (vchordg)
vchordg
There are 2 steps in the index construction process of vchordg. The phase name of each step are as follows:
| Step | Message | Description | Waiting time |
|---|---|---|---|
| 1 | initializing |
Start building index | Short |
| 2 | inserting tuples from table to index |
Insert all vectors into the graph | Long |
The 2nd step, inserting tuples from table to index, takes up the majority of the time during index construction. The tuples_done, blocks_done and blocks_total columns indicate the progress of this step.