Amazon Redshift - Table Statistics
Imported Statistics
| Statistics | Is imported | Description |
|---|---|---|
| Row count | ✅ | Indicates the number of rows in table |
| Last user query | ✅ | Time of last user SELECT operation on table |
| Number of user queries | ✅ | Number of user SELECT operation on table |
| Last user update | ✅ | Time of last user INSERT, UPDATE and DELETE operations on table |
| Number of user updates | ✅ | Sum of user INSERT, UPDATE and DELETE operations on table |
| Last load time | ✅ | Time of last user COPY command on table |
Requirements
Dataedo requires access to the following tables and views:
- pg_class
- pg_namespace
- SYS_QUERY_DETAIL
- SYS_QUERY_HISTORY
- SVV_TABLE_INFO
Limitations
- Row number in the table is only an estimate used by the planner. It is updated by VACUUM, ANALYZE, and a few DDL commands such as CREATE INDEX. If the table has never yet been vacuumed or analyzed, row count is 0.
- SYS_QUERY_HISTORY is systematically purged by default from two to five days (depends on cluster workload and size)
Learn more
Read more about table statistics import in main article
