Redshift Observatory

System Table Tracker

System view pg_catalog.stl_kinesis_scan_states version 1.0.54239 / 2023-08-04

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