Table stats
table_statsRetrieve live/dead row counts, sequential versus index scan counts, and table/index sizes for a PostgreSQL table to assess performance and maintenance needs.
Instructions
Statistics for one table: live/dead rows, sequential vs index scan counts, and table/index sizes.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>"
},
"name": "table_stats"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name, e.g. "orders". | |
| schema | No | Schema name. Defaults to "public". |