Redshift Observatory

System Table Tracker

System view pg_catalog.svv_integration_table_state version 1.0.74998 / 2024-09-20

View Text

SELECT i.integration_id,
       i.database_name AS target_database,
       i.schema_name,
       i.table_name,
       i.state 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
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 Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers