---
title: blossom database:maintenance:show
url: "/docs/reference/cli/database/maintenance/show/"
canonical_url: https://docs.blossom88.com/docs/reference/cli/database/maintenance/show/
markdown_url: https://docs.blossom88.com/docs/reference/cli/database/maintenance/show.md
summary: Show database maintenance status
categories:
- cli
- reference
---

# blossom database:maintenance:show

Show database maintenance status

## Usage

    blossom database:maintenance:show --id ID

## Flags

| Flag | Description |
| --- | --- |
| `--id (required)` | Database id |

Show the selected PostgreSQL database's maintenance state and latest Activity.

    blossom database:maintenance:show --id database-123

States are `off`, `enabling`, `on`, `disabling` and `failed`. `on` means the last
operation verified connection blocking and disconnected existing clients.
A failed or interrupted operation may still have restrictions in place; follow
the Activity before retrying or disabling maintenance.