# MV\_MILESTONES

This view displays the list of milestones that have been created in the engine. This is the list of points that can be used to perform PITR.

`_first_milestone` , this milestone name is created automatically when a database is created. The other milestone names are created by explicitly using `CREATE MILESTONE`. If a name is not specified in the `CREATE MILESTONE` command, the milestone time will be used as the default milestone name.

`MV_MILESTONES` will not show milestones older than the retention period for unlimited storage databases.

| Column name         | Description                                                                     |
| ------------------- | ------------------------------------------------------------------------------- |
| `MILESTONE_NAME`    | Name of the milestone.                                                          |
| `MILESTONE_TIME`    | Timestamp when milestone was created.                                           |
| `DATABASE_NAME`     | Name of the database for which the milestone is created.                        |
| `DATABASE_LOCATION` | The remote storage location of the database for which the milestone is created. |

Example:

```
SELECT * FROM information_schema.MV_MILESTONES;

```

```output

+----------------------------+----------------------------+---------------+-------------------+
| MILESTONE_NAME             | MILESTONE_TIME             | DATABASE_NAME | DATABASE_LOCATION |
+----------------------------+----------------------------+---------------+-------------------+
| _first_milestone           | 2021-11-10 11:44:25.956998 | x_db          | s3bucket          |
| 2021-11-10 11:44:27.911987 | 2021-11-10 11:44:27.911987 | x_db          | s3bucket          |
| x_db_milestone             | 2021-11-10 11:44:35.175052 | x_db          | s3bucket          |
+----------------------------+----------------------------+---------------+-------------------+
```

***

Modified at: May 26, 2026

Source: [/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-milestones/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-milestones/)

(An index of the documentation is available at /llms.txt)