# Vacuum

Reclaim storage space.

```edgeql-synopsis
administer vacuum "("
  [<type_link_or_property> [, ...]]
  [, full := {true | false}]
  [, statistics_update := {true | false}]
")"
```

## Description

Cleans and reclaims storage by removing obsolete data.

`<type_link_or_property>`:
If a type name or a path to a link or property are specified, that data will be targeted for the vacuum operation. If omitted, all user-accessible data will be targeted.



`full := {true | false}`:
If set to `true`, an exclusive lock is obtained and reclaimed space is returned to the operating system. If set to `false` or if not set, the command can operate alongside normal reading and writing of the database and reclaimed space is kept available for reuse in the database, reducing the rate of growth of the database.



`statistics_update := {true | false}`:
If set to `true`, updates statistics used by the planner to determine the most efficient way to execute queries on specified data. See also [administer statistics_update()](https://docs.geldata.com/reference/running/admin/statistics_update.md#ref-admin-statistics-update).



## Examples

Vacuum the type `SomeType`:

```edgeql
administer vacuum(SomeType);
```

Vacuum the type `SomeType` and the link `OtherType.ptr` and return reclaimed space to the operating system:

```edgeql
administer vacuum(SomeType, OtherType.ptr, full := true);
```

Vacuum everything that is user-accessible in the database:

```edgeql
administer vacuum();
```