Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
PG_STATISTIC_INDICATOR
Stores information about the number of rows inserted or deleted since the last ANALYZE. The PG_STATISTIC_INDICATOR table is updated frequently following DML operations, so statistics are approximate.
PG_STATISTIC_INDICATOR is visible only to superusers. For more information, see Visibility of data in system tables and views.
Table columns
| Column name | Data type | Description |
|---|---|---|
| stairelid | oid | Table ID |
| stairows | float | Total number of rows in the table. |
| staiins | float | Number of rows inserted since the last ANALYZE. |
| staidels | float | Number of rows deleted or updated since the last ANALYZE. |
Example
The following example returns information for table changes since the last ANALYZE.
select * from pg_statistic_indicator; stairelid | stairows | staiins | staidels ----------+----------+---------+--------- 108271 | 11 | 0 | 0 108275 | 365 | 0 | 0 108278 | 8798 | 0 | 0 108280 | 91865 | 0 | 100632 108267 | 89981 | 49990 | 9999 108269 | 808 | 606 | 374 108282 | 152220 | 76110 | 248566
