Redshift Observatory

System Table Tracker

System view pg_catalog.stl_comm_capture version 1.0.50708 / 2023-05-19

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