List Table Partitions
pg_list_partitionsList partitioned tables and their child partitions with bounds, size, and row estimates. Filter results by schema or specific parent table.
Instructions
List all partitioned tables and their child partitions with bounds, size, and row estimates.
Args:
schema: Filter to a specific schema (optional)
parent_table: Filter to a specific partitioned table (optional)
response_format: Output format
Returns: JSON: { partitions: PartitionInfo[], parent_tables: string[] } Markdown: grouped by parent table, showing each partition's bounds and size
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Filter to schema (optional) | |
| parent_table | No | Filter to a specific partitioned table (optional) | |
| response_format | No | Output format: 'markdown' for human-readable, 'json' for machine-readable | markdown |