# Monitoring

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

---

LLMS index: [llms.txt](/llms.txt)

---

You can monitor the progress of building a PostgreSQL index by querying the [`pg_stat_progress_create_index`](https://www.postgresql.org/docs/current/progress-reporting.html#CREATE-INDEX-PROGRESS-REPORTING) view.

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

<a id="Reference"></a>
## Reference

<a id="phases"></a>
<a id="Phases"></a>
### 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.

<a id="phases"></a>
<a id="Phases"></a>
### 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.

---

Backlinks:

- [Overview](/docs/getting-started/overview/)