TABLE_STATISTICS
Displays statistics that have been collected for tables and their respective partitions.
Displays statistics that have been collected for tables and their respective partitions.
| Column Name | Data Type | Description |
|---|---|---|
| LOGICAL_STATS_OID | INTEGER | Uniquely identifies a collection of statistics for a given table. |
| TABLE_NAME | VARCHAR | Name of an existing database table. |
|
MIN_PARTITION_KEY, MAX_PARTITION_KEY |
VARCHAR | Statistics for a range of partition keys collected by ANALYZE_STATISTICS_PARTITION, empty if statistics were collected by ANALYZE_STATISTICS. |
| ROW_COUNT | INTEGER | The number of rows analyzed for each statistics collection. |
| STAT_COLLECTION_TIME | TIMESTAMPTZ | The timestamp of each statistics collection. |