Redshift Observatory

System Table Tracker

System view pg_catalog.stl_integration_scan version 1.0.60854 / 2023-12-12

schema	name	column	data type
pg_catalog	stl_integration_scan	dt_table_id	int4
pg_catalog	stl_integration_scan	is_remote_scan	int4
pg_catalog	stl_integration_scan	num_dt_table_rows	int8
pg_catalog	stl_integration_scan	num_table_rows	int8
pg_catalog	stl_integration_scan	query	int4
pg_catalog	stl_integration_scan	record_time	timestamp
pg_catalog	stl_integration_scan	synced_log_coordinate	char(128)
pg_catalog	stl_integration_scan	table_id	int4
pg_catalog	stl_integration_scan	table_name	char(128)
pg_catalog	stl_integration_scan	table_state	char(128)
pg_catalog	stl_integration_scan	user_id	int4

View Text

SELECT stll_integration_scan.record_time,
       stll_integration_scan.user_id,
       stll_integration_scan.query,
       stll_integration_scan.table_name,
       stll_integration_scan.table_id,
       stll_integration_scan.dt_table_id,
       stll_integration_scan.num_table_rows,
       stll_integration_scan.num_dt_table_rows,
       stll_integration_scan.is_remote_scan,
       stll_integration_scan.table_state,
       stll_integration_scan.synced_log_coordinate
FROM stll_integration_scan

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