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