Redshift Observatory

System Table Tracker

System view pg_catalog.svv_integration_table_state version 1.0.106073 / 2025-01-23

View Text

SELECT i.integration_id,
       i.database_name AS target_database,
       i.schema_name,
       i.table_name,
       CASE
         WHEN i.state = CAST('Historical' AS bpchar)
           THEN CAST('DroppedSource' AS bpchar)
         ELSE i.state
       END AS table_state,
       i.synced_log_coordinate AS table_last_replicated_checkpoint,
       i.reason,
       i.last_updated AS last_updated_timestamp,
       COALESCE(s.sum_rows,
                CAST(0 AS bigint)) AS table_rows,
       COALESCE(s.sum_blocks,
                CAST(0 AS bigint)) AS table_size,
       CASE
         WHEN i.is_history_mode = CAST('t' AS bpchar)
           THEN TRUE
         ELSE FALSE
       END AS is_history_mode
FROM stv_integration_table_state AS i
     LEFT JOIN (SELECT d.datname AS database_name,
                       p.id AS table_id,
                       sum(p.rows) AS sum_rows,
                       sum(p.block_count) AS sum_blocks
                FROM stv_tbl_perm AS p
                     INNER JOIN pg_database AS d ON CAST(p.db_id AS oid) = d.oid
                GROUP BY d.datname, p.id) AS s ON s.table_id = i.table_id
                                              AND s.database_name = CAST(i.database_name AS name)

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace System Table Tracker The Known Universe White Papers