pg_table_stats
Get table size, index size, and estimated row count for a PostgreSQL table by specifying table name and optional schema.
Instructions
Get statistics for a given table in the specified schema, including table size, index size, and estimated row count.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| schema | No | Schema to filter by. Defaults to the connection's defaultSchema (or 'public'). | |
| connectionId | No | Id of the postgres connection to use, from databases.config.yml. Optional when only one postgres connection is configured. |