Redshift Observatory

System Table Tracker

System view pg_catalog.stl_stream_info version 1.0.118447 / 2025-08-02

schema	name	column	data type
pg_catalog	stl_stream_info	action	char(128)
pg_catalog	stl_stream_info	cust_traffic_mode	char(128)
pg_catalog	stl_stream_info	database_name	char(128)
pg_catalog	stl_stream_info	eskind	int4
pg_catalog	stl_stream_info	esoptions	char(4096)
pg_catalog	stl_stream_info	external_schema_name	char(128)
pg_catalog	stl_stream_info	metadata	char(4096)
pg_catalog	stl_stream_info	mv_name	char(128)
pg_catalog	stl_stream_info	mvoid	int8
pg_catalog	stl_stream_info	pid	int4
pg_catalog	stl_stream_info	record_time	timestamp
pg_catalog	stl_stream_info	refresh_type	char(32)
pg_catalog	stl_stream_info	schema_name	char(128)
pg_catalog	stl_stream_info	stream_name	char(128)
pg_catalog	stl_stream_info	user_id	int4
pg_catalog	stl_stream_info	xid	int8

View Text

SELECT stll_stream_info.record_time,
       stll_stream_info.pid,
       stll_stream_info.xid,
       stll_stream_info.user_id,
       stll_stream_info.mvoid,
       stll_stream_info.eskind,
       stll_stream_info.action,
       stll_stream_info.database_name,
       stll_stream_info.schema_name,
       stll_stream_info.external_schema_name,
       stll_stream_info.stream_name,
       stll_stream_info.mv_name,
       stll_stream_info.refresh_type,
       stll_stream_info.cust_traffic_mode,
       stll_stream_info.esoptions,
       stll_stream_info.metadata
FROM stll_stream_info

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers