Redshift Observatory

System Table Tracker

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

schema name column data type
pg_catalog stl_comm_capture ack_reply int4
pg_catalog stl_comm_capture ack_xon int4
pg_catalog stl_comm_capture channel int4
pg_catalog stl_comm_capture cmd_code int4
pg_catalog stl_comm_capture dst_ip char(15)
pg_catalog stl_comm_capture dst_mac char(18)
pg_catalog stl_comm_capture dst_port int4
pg_catalog stl_comm_capture dst_slice int4
pg_catalog stl_comm_capture fragment int4
pg_catalog stl_comm_capture host_ip char(15)
pg_catalog stl_comm_capture ip_frag_offset int4
pg_catalog stl_comm_capture ip_frags int4
pg_catalog stl_comm_capture ip_id int4
pg_catalog stl_comm_capture ip_len int4
pg_catalog stl_comm_capture is_bcast int4
pg_catalog stl_comm_capture len int4
pg_catalog stl_comm_capture recordtime timestamp
pg_catalog stl_comm_capture seqnum int8
pg_catalog stl_comm_capture src_ip char(15)
pg_catalog stl_comm_capture src_mac char(18)
pg_catalog stl_comm_capture src_port int4
pg_catalog stl_comm_capture src_slice int4
pg_catalog stl_comm_capture sync_msg int4

View Text

SELECT stll_comm_capture.host_ip,
       stll_comm_capture.recordtime,
       stll_comm_capture.src_mac,
       stll_comm_capture.src_ip,
       stll_comm_capture.src_port,
       stll_comm_capture.dst_mac,
       stll_comm_capture.dst_ip,
       stll_comm_capture.dst_port,
       stll_comm_capture.ip_id,
       stll_comm_capture.ip_len,
       stll_comm_capture.ip_frags,
       stll_comm_capture.ip_frag_offset,
       stll_comm_capture.cmd_code,
       stll_comm_capture.seqnum,
       stll_comm_capture.channel,
       stll_comm_capture.src_slice,
       stll_comm_capture.dst_slice,
       stll_comm_capture.len,
       stll_comm_capture.is_bcast,
       stll_comm_capture.ack_reply,
       stll_comm_capture.ack_xon,
       stll_comm_capture.sync_msg,
       stll_comm_capture.fragment
FROM stll_comm_capture


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