Redshift Observatory

System Table Tracker

System view pg_catalog.stl_integration_log version 1.0.76759 / 2024-10-18

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