Monitoring

You can monitor the progress of building a PostgreSQL index by querying the pg_stat_progress_create_index view.

SELECT command, phase, round(100.0 * blocks_done / nullif(blocks_total, 0), 1) AS "%" FROM pg_stat_progress_create_index;

Reference

Phases 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 K-means clustering 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

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.