Redshift Observatory

System Table Tracker

System view pg_catalog.stl_cdc_checkpoints version 1.0.74503 / 2024-09-16

schema	name	column	data type
pg_catalog	stl_cdc_checkpoints	bytes_downloaded	int8
pg_catalog	stl_cdc_checkpoints	channel_state	char(128)
pg_catalog	stl_cdc_checkpoints	checkpoint	char(128)
pg_catalog	stl_cdc_checkpoints	connection_id	char(128)
pg_catalog	stl_cdc_checkpoints	content	char(4096)
pg_catalog	stl_cdc_checkpoints	db_name	char(128)
pg_catalog	stl_cdc_checkpoints	export_identifier	char(64)
pg_catalog	stl_cdc_checkpoints	num_tables_modified	int4
pg_catalog	stl_cdc_checkpoints	recordtime	timestamp
pg_catalog	stl_cdc_checkpoints	rows	int8
pg_catalog	stl_cdc_checkpoints	s3_path	char(512)
pg_catalog	stl_cdc_checkpoints	status	char(16)
pg_catalog	stl_cdc_checkpoints	type	char(16)

View Text

SELECT stll_cdc_checkpoints.recordtime,
       stll_cdc_checkpoints.connection_id,
       stll_cdc_checkpoints.db_name,
       stll_cdc_checkpoints.s3_path,
       stll_cdc_checkpoints.checkpoint,
       stll_cdc_checkpoints.type,
       stll_cdc_checkpoints.num_tables_modified,
       stll_cdc_checkpoints.status,
       stll_cdc_checkpoints.bytes_downloaded,
       stll_cdc_checkpoints.channel_state,
       stll_cdc_checkpoints.export_identifier,
       stll_cdc_checkpoints.rows,
       stll_cdc_checkpoints.content
FROM stll_cdc_checkpoints

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