Redshift Research Project

System Table Tracker

System view pg_catalog.stl_cdc_checkpoints version 1.0.44903 / 2022-12-19

schema	name	column	data type
pg_catalog	stl_cdc_checkpoints	checkpoint	char(128)
pg_catalog	stl_cdc_checkpoints	connection_id	char(128)
pg_catalog	stl_cdc_checkpoints	db_name	char(128)
pg_catalog	stl_cdc_checkpoints	num_tables_modified	int4
pg_catalog	stl_cdc_checkpoints	recordtime	timestamp
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
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