Redshift Observatory

System Table Tracker

System view pg_catalog.stl_integration_activity_detail version 1.0.71629 / 2024-07-27

schema	name	column	data type
pg_catalog	stl_integration_activity_detail	channel_state	char(128)
pg_catalog	stl_integration_activity_detail	checkpoint_data_size	int8
pg_catalog	stl_integration_activity_detail	checkpoint_name	char(128)
pg_catalog	stl_integration_activity_detail	checkpoint_type	char(16)
pg_catalog	stl_integration_activity_detail	copy_id	int8
pg_catalog	stl_integration_activity_detail	database_name	char(128)
pg_catalog	stl_integration_activity_detail	integration_id	char(128)
pg_catalog	stl_integration_activity_detail	node_id	int4
pg_catalog	stl_integration_activity_detail	record_time	timestamp
pg_catalog	stl_integration_activity_detail	state	char(128)
pg_catalog	stl_integration_activity_detail	table_name	char(128)

View Text

SELECT stll_integration_activity_detail.record_time,
       stll_integration_activity_detail.integration_id,
       stll_integration_activity_detail.database_name,
       stll_integration_activity_detail.node_id,
       stll_integration_activity_detail.checkpoint_name,
       stll_integration_activity_detail.checkpoint_type,
       stll_integration_activity_detail.copy_id,
       stll_integration_activity_detail.table_name,
       stll_integration_activity_detail.checkpoint_data_size,
       stll_integration_activity_detail.state,
       stll_integration_activity_detail.channel_state
FROM stll_integration_activity_detail

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