Redshift Observatory

System Table Tracker

System view pg_catalog.stl_perf_channel_sink version 1.0.46534 / 2023-02-21

schema	name	column	data type
pg_catalog	stl_perf_channel_sink	bytes_transferred	int8
pg_catalog	stl_perf_channel_sink	channel_id	int4
pg_catalog	stl_perf_channel_sink	channel_type	int4
pg_catalog	stl_perf_channel_sink	close_time	timestamp
pg_catalog	stl_perf_channel_sink	first_packet_time	timestamp
pg_catalog	stl_perf_channel_sink	last_packet_time	timestamp
pg_catalog	stl_perf_channel_sink	packet_count	int8
pg_catalog	stl_perf_channel_sink	query_id	int4
pg_catalog	stl_perf_channel_sink	queue_delay_max_time	int8
pg_catalog	stl_perf_channel_sink	queue_delay_total_time	int8
pg_catalog	stl_perf_channel_sink	rexmit_max_count	int8
pg_catalog	stl_perf_channel_sink	rexmit_total_count	int8
pg_catalog	stl_perf_channel_sink	segment_number	int4
pg_catalog	stl_perf_channel_sink	slice_number	int4
pg_catalog	stl_perf_channel_sink	throughput_kilobytes_per_sec	int8
pg_catalog	stl_perf_channel_sink	xoff_max_time	int8
pg_catalog	stl_perf_channel_sink	xoff_total_time	int8

View Text

SELECT stll_perf_channel_sink.query_id,
       stll_perf_channel_sink.segment_number,
       stll_perf_channel_sink.slice_number,
       stll_perf_channel_sink.packet_count,
       stll_perf_channel_sink.bytes_transferred,
       stll_perf_channel_sink.channel_type,
       stll_perf_channel_sink.channel_id,
       stll_perf_channel_sink.first_packet_time,
       stll_perf_channel_sink.last_packet_time,
       stll_perf_channel_sink.close_time,
       stll_perf_channel_sink.throughput_kilobytes_per_sec,
       stll_perf_channel_sink.xoff_total_time,
       stll_perf_channel_sink.xoff_max_time,
       stll_perf_channel_sink.queue_delay_total_time,
       stll_perf_channel_sink.queue_delay_max_time,
       stll_perf_channel_sink.rexmit_total_count,
       stll_perf_channel_sink.rexmit_max_count
FROM stll_perf_channel_sink

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