Redshift Observatory

System Table Tracker

System view pg_catalog.stl_integration_log version 1.0.57864 / 2023-10-14

schema name column data type
pg_catalog stl_integration_log checkpoint_bytes int8
pg_catalog stl_integration_log checkpoint_name char(128)
pg_catalog stl_integration_log checkpoint_type char(16)
pg_catalog stl_integration_log database_name char(128)
pg_catalog stl_integration_log delay_ms int8
pg_catalog stl_integration_log integration_id char(128)
pg_catalog stl_integration_log integration_start_time timestamp
pg_catalog stl_integration_log integration_type char(128)
pg_catalog stl_integration_log lag_ms int8
pg_catalog stl_integration_log last_commit_timestamp timestamp
pg_catalog stl_integration_log num_failed_tables int4
pg_catalog stl_integration_log num_modified_tables int4
pg_catalog stl_integration_log record_time timestamp
pg_catalog stl_integration_log state char(128)
pg_catalog stl_integration_log status char(128)
pg_catalog stl_integration_log synced_log_coordinate char(128)

View Text

SELECT stll_integration_log.record_time,
       stll_integration_log.integration_id,
       stll_integration_log.integration_type,
       stll_integration_log.state,
       stll_integration_log.status,
       stll_integration_log.database_name,
       stll_integration_log.checkpoint_name,
       stll_integration_log.checkpoint_type,
       stll_integration_log.synced_log_coordinate,
       stll_integration_log.num_modified_tables,
       stll_integration_log.lag_ms,
       stll_integration_log.checkpoint_bytes,
       stll_integration_log.integration_start_time,
       stll_integration_log.last_commit_timestamp,
       stll_integration_log.num_failed_tables,
       stll_integration_log.delay_ms
FROM stll_integration_log


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