Redshift Observatory

System Table Tracker

System view pg_catalog.svv_integration version 1.0.76230 / 2024-10-12

schema	name	column	data type
pg_catalog	svv_integration	creation_time	timestamp
pg_catalog	svv_integration	current_lag	int8
pg_catalog	svv_integration	integration_id	char(128)
pg_catalog	svv_integration	last_replicated_checkpoint	char(128)
pg_catalog	svv_integration	refresh_interval	int4
pg_catalog	svv_integration	source	char(128)
pg_catalog	svv_integration	source_database	char(128)
pg_catalog	svv_integration	state	char(128)
pg_catalog	svv_integration	target_database	char(128)
pg_catalog	svv_integration	total_tables_failed	int4
pg_catalog	svv_integration	total_tables_replicated	int4

View Text

SELECT stv_integration.integration_id,
       stv_integration.database_name AS target_database,
       stv_integration.integration_type AS source,
       stv_integration.state,
       stv_integration.lag_ms AS current_lag,
       stv_integration.synced_log_coordinate AS last_replicated_checkpoint,
       stv_integration.total_tables_replicated,
       stv_integration.total_tables_failed,
       stv_integration.creation_time,
       stv_integration.refresh_interval,
       stv_integration.source_database
FROM stv_integration

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