Redshift Observatory

System Table Tracker

System view pg_catalog.stl_integration_log version 1.0.77706 / 2024-11-05

schema name column data type
pg_catalog stl_integration_log channel_state char(128)
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 deleted_rows int8
pg_catalog stl_integration_log export_identifier char(64)
pg_catalog stl_integration_log inserted_rows 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 rows int8
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)
pg_catalog stl_integration_log updated_rows int8

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,
       stll_integration_log.channel_state,
       stll_integration_log.export_identifier,
       stll_integration_log.rows,
       stll_integration_log.inserted_rows,
       stll_integration_log.deleted_rows,
       stll_integration_log.updated_rows
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