Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_kinesis_scan_errors	arrival_time	timestamp
pg_catalog	stl_kinesis_scan_errors	err_code	int4
pg_catalog	stl_kinesis_scan_errors	err_reason	char(128)
pg_catalog	stl_kinesis_scan_errors	mv_name	char(128)
pg_catalog	stl_kinesis_scan_errors	node	int4
pg_catalog	stl_kinesis_scan_errors	pid	int4
pg_catalog	stl_kinesis_scan_errors	query	int8
pg_catalog	stl_kinesis_scan_errors	raw_data	char(1024)
pg_catalog	stl_kinesis_scan_errors	record_time	timestamp
pg_catalog	stl_kinesis_scan_errors	schema_name	char(128)
pg_catalog	stl_kinesis_scan_errors	segment	int4
pg_catalog	stl_kinesis_scan_errors	seq_num	char(128)
pg_catalog	stl_kinesis_scan_errors	shard_id	char(128)
pg_catalog	stl_kinesis_scan_errors	slice	int4
pg_catalog	stl_kinesis_scan_errors	stream_name	char(128)
pg_catalog	stl_kinesis_scan_errors	timestamp_type	char(1)
pg_catalog	stl_kinesis_scan_errors	transaction_id	int8

View Text

SELECT stll_kinesis_scan_errors.query,
       stll_kinesis_scan_errors.node,
       stll_kinesis_scan_errors.slice,
       stll_kinesis_scan_errors.segment,
       stll_kinesis_scan_errors.pid,
       stll_kinesis_scan_errors.arrival_time,
       stll_kinesis_scan_errors.record_time,
       stll_kinesis_scan_errors.schema_name,
       stll_kinesis_scan_errors.stream_name,
       stll_kinesis_scan_errors.shard_id,
       stll_kinesis_scan_errors.seq_num,
       stll_kinesis_scan_errors.err_code,
       stll_kinesis_scan_errors.err_reason,
       stll_kinesis_scan_errors.raw_data,
       stll_kinesis_scan_errors.mv_name,
       stll_kinesis_scan_errors.timestamp_type,
       stll_kinesis_scan_errors.transaction_id
FROM stll_kinesis_scan_errors

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