Redshift Observatory

System Table Tracker

System view pg_catalog.stl_perf_channel_sink version 1.0.50300 / 2023-05-09

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_sink_init_us	int8
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_sample_max_ns	int8
pg_catalog	stl_perf_channel_sink	queue_delay_sample_total_ns	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_kb_sec	int8
pg_catalog	stl_perf_channel_sink	xoff_max_ns	int8
pg_catalog	stl_perf_channel_sink	xoff_total_ns	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_kb_sec,
       stll_perf_channel_sink.xoff_total_ns,
       stll_perf_channel_sink.xoff_max_ns,
       stll_perf_channel_sink.queue_delay_sample_total_ns,
       stll_perf_channel_sink.queue_delay_sample_max_ns,
       stll_perf_channel_sink.rexmit_total_count,
       stll_perf_channel_sink.rexmit_max_count,
       stll_perf_channel_sink.channel_sink_init_us
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