Redshift Observatory

System Table Tracker

System view pg_catalog.svl_stream_scan_errors version 1.0.43551 / 2022-11-08

schema name column data type
pg_catalog svl_stream_scan_errors err_code int4
pg_catalog svl_stream_scan_errors err_reason char(128)
pg_catalog svl_stream_scan_errors mv_name char(128)
pg_catalog svl_stream_scan_errors partition_id char(128)
pg_catalog svl_stream_scan_errors pid int4
pg_catalog svl_stream_scan_errors position char(128)
pg_catalog svl_stream_scan_errors query int4
pg_catalog svl_stream_scan_errors raw_data char(1024)
pg_catalog svl_stream_scan_errors record_time timestamp
pg_catalog svl_stream_scan_errors schema_name char(128)
pg_catalog svl_stream_scan_errors stream_name char(255)
pg_catalog svl_stream_scan_errors stream_timestamp timestamp
pg_catalog svl_stream_scan_errors timestamp_type char(1)

View Text

SELECT stl_kinesis_scan_errors.query,
       stl_kinesis_scan_errors.pid,
       stl_kinesis_scan_errors.timestamp_type,
       stl_kinesis_scan_errors.arrival_time AS stream_timestamp,
       stl_kinesis_scan_errors.record_time,
       stl_kinesis_scan_errors.mv_name,
       stl_kinesis_scan_errors.schema_name,
       stl_kinesis_scan_errors.stream_name,
       stl_kinesis_scan_errors.shard_id AS partition_id,
       stl_kinesis_scan_errors.seq_num AS position,
       stl_kinesis_scan_errors.err_code,
       stl_kinesis_scan_errors.err_reason,
       stl_kinesis_scan_errors.raw_data
FROM stl_kinesis_scan_errors

UNION ALL

SELECT stl_kafka_scan_errors.query,
       stl_kafka_scan_errors.pid,
       stl_kafka_scan_errors.timestamp_type,
       stl_kafka_scan_errors.kafka_timestamp AS stream_timestamp,
       stl_kafka_scan_errors.record_time,
       stl_kafka_scan_errors.mv_name,
       stl_kafka_scan_errors.schema_name,
       stl_kafka_scan_errors.topic_name AS stream_name,
       CAST(stl_kafka_scan_errors.partition_id AS varchar(128)) AS partition_id,
       CAST(stl_kafka_scan_errors.record_offset AS varchar(128)) AS position,
       stl_kafka_scan_errors.err_code,
       stl_kafka_scan_errors.err_reason,
       stl_kafka_scan_errors.raw_data
FROM stl_kafka_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