Redshift Observatory

System Table Tracker

System view pg_catalog.stl_integration_stats version 1.0.60353 / 2023-11-24

schema	name	column	data type
pg_catalog	stl_integration_stats	cdc_bytes_ingested	int8
pg_catalog	stl_integration_stats	database_name	char(128)
pg_catalog	stl_integration_stats	failed_table_count	int4
pg_catalog	stl_integration_stats	integration_id	char(128)
pg_catalog	stl_integration_stats	integration_state	char(128)
pg_catalog	stl_integration_stats	integration_type	char(16)
pg_catalog	stl_integration_stats	max_delay	int4
pg_catalog	stl_integration_stats	max_lag	int4
pg_catalog	stl_integration_stats	max_resync_cdc_time_secs	int4
pg_catalog	stl_integration_stats	max_resync_pe_time_secs	int4
pg_catalog	stl_integration_stats	max_seed_pe_time_secs	int4
pg_catalog	stl_integration_stats	num_cdc_checkpoints_processed	int4
pg_catalog	stl_integration_stats	num_cdc_ddl_checkpoints_processed	int4
pg_catalog	stl_integration_stats	num_commits	int4
pg_catalog	stl_integration_stats	num_del_merges	int4
pg_catalog	stl_integration_stats	num_pe_tables	int4
pg_catalog	stl_integration_stats	num_resyncs_initiated	int4
pg_catalog	stl_integration_stats	num_resyncs_source_initiated	int4
pg_catalog	stl_integration_stats	num_soft_commits	int4
pg_catalog	stl_integration_stats	pe_bytes_ingested	int8
pg_catalog	stl_integration_stats	record_time	timestamp
pg_catalog	stl_integration_stats	resync_table_count	int4
pg_catalog	stl_integration_stats	schema_count	int4
pg_catalog	stl_integration_stats	total_table_count	int4

View Text

SELECT stll_integration_stats.record_time,
       stll_integration_stats.integration_type,
       stll_integration_stats.integration_id,
       stll_integration_stats.database_name,
       stll_integration_stats.integration_state,
       stll_integration_stats.schema_count,
       stll_integration_stats.total_table_count,
       stll_integration_stats.failed_table_count,
       stll_integration_stats.resync_table_count,
       stll_integration_stats.num_resyncs_initiated,
       stll_integration_stats.num_resyncs_source_initiated,
       stll_integration_stats.num_cdc_checkpoints_processed,
       stll_integration_stats.num_cdc_ddl_checkpoints_processed,
       stll_integration_stats.num_pe_tables,
       stll_integration_stats.max_seed_pe_time_secs,
       stll_integration_stats.max_resync_pe_time_secs,
       stll_integration_stats.max_resync_cdc_time_secs,
       stll_integration_stats.pe_bytes_ingested,
       stll_integration_stats.cdc_bytes_ingested,
       stll_integration_stats.num_commits,
       stll_integration_stats.num_soft_commits,
       stll_integration_stats.num_del_merges,
       stll_integration_stats.max_lag,
       stll_integration_stats.max_delay
FROM stll_integration_stats

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