Redshift Observatory

System Table Tracker

System view pg_catalog.stl_kinesis_scan_states version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	stl_kinesis_scan_states	latest_seq_num	char(128)
pg_catalog	stl_kinesis_scan_states	max_arrival_time	timestamp
pg_catalog	stl_kinesis_scan_states	millis_behind_latest	int8
pg_catalog	stl_kinesis_scan_states	min_arrival_time	timestamp
pg_catalog	stl_kinesis_scan_states	mv_name	char(128)
pg_catalog	stl_kinesis_scan_states	node	int4
pg_catalog	stl_kinesis_scan_states	num_bytes	int8
pg_catalog	stl_kinesis_scan_states	num_records	int8
pg_catalog	stl_kinesis_scan_states	num_skipped_records	int8
pg_catalog	stl_kinesis_scan_states	pid	int4
pg_catalog	stl_kinesis_scan_states	query	int8
pg_catalog	stl_kinesis_scan_states	queue_bytes	int8
pg_catalog	stl_kinesis_scan_states	record_time	timestamp
pg_catalog	stl_kinesis_scan_states	request_duration	int8
pg_catalog	stl_kinesis_scan_states	scheduling_period	int8
pg_catalog	stl_kinesis_scan_states	schema_name	char(128)
pg_catalog	stl_kinesis_scan_states	segment	int4
pg_catalog	stl_kinesis_scan_states	shard_id	char(128)
pg_catalog	stl_kinesis_scan_states	slice	int4
pg_catalog	stl_kinesis_scan_states	stream_name	char(128)
pg_catalog	stl_kinesis_scan_states	tardiness	int8
pg_catalog	stl_kinesis_scan_states	transaction_id	int8
pg_catalog	stl_kinesis_scan_states	worker_bytes	int8

View Text

SELECT stll_kinesis_scan_states.query,
       stll_kinesis_scan_states.node,
       stll_kinesis_scan_states.slice,
       stll_kinesis_scan_states.segment,
       stll_kinesis_scan_states.pid,
       stll_kinesis_scan_states.record_time,
       stll_kinesis_scan_states.schema_name,
       stll_kinesis_scan_states.stream_name,
       stll_kinesis_scan_states.shard_id,
       stll_kinesis_scan_states.num_records,
       stll_kinesis_scan_states.num_skipped_records,
       stll_kinesis_scan_states.num_bytes,
       stll_kinesis_scan_states.latest_seq_num,
       stll_kinesis_scan_states.millis_behind_latest,
       stll_kinesis_scan_states.worker_bytes,
       stll_kinesis_scan_states.queue_bytes,
       stll_kinesis_scan_states.scheduling_period,
       stll_kinesis_scan_states.request_duration,
       stll_kinesis_scan_states.tardiness,
       stll_kinesis_scan_states.min_arrival_time,
       stll_kinesis_scan_states.max_arrival_time,
       stll_kinesis_scan_states.mv_name,
       stll_kinesis_scan_states.transaction_id
FROM stll_kinesis_scan_states

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