---
title: "Database Monitoring: table size, bloat and vacuum state"
method: GET
path: "/api/{org_id}/db_monitoring/table_health"
tags: ["Traces"]
---

# Database Monitoring: table size, bloat and vacuum state

`GET /api/{org_id}/db_monitoring/table_health`

## Request

- Base URL: `https://api.openobserve.ai` (the document declares no server; this is the origin it was published from)
- URL: `https://api.openobserve.ai/api/{org_id}/db_monitoring/table_health`
- Auth: API key in header `Authorization`
- TypeScript: <https://skmtc.dev/openobserve/apis/openobserve-api-http/docs/api/:org_id/db_monitoring/table_health/get.ts> (a function with typed inputs; its response is checked against the schema)

Newest snapshot per relation from the table-stats server-vantage feed (pg_table_stats / mysql_table_stats / mariadb_table_stats). Scan and vacuum counters are LIFETIME totals since the last statistics reset; tuple counts and bloat percentage are planner estimates. Postgres, MySQL and MariaDB.

## Path parameters

- `org_id` string, required

## Query parameters

- `start_time` integer
- `end_time` integer
- `stream` string
- `system` string
- `instance` string
- `limit` integer
- `include_indexes` boolean

## Response `200`

Success

- object

---

[API](https://skmtc.dev/openobserve/apis/openobserve-api-http.md) - [All operations](https://skmtc.dev/openobserve/apis/openobserve-api-http/llms.txt) - [OpenAPI document](https://skmtc.dev/openobserve/apis/openobserve-api-http/revisions/0529b8a10252?raw)