Redshift Observatory

System Table Tracker

System view pg_catalog.stl_perf_channel_source version 1.0.43720 / 2022-11-13

schema	name	column	data type
pg_catalog	stl_perf_channel_source	borrow_max_time	int8
pg_catalog	stl_perf_channel_source	borrow_total_time	int8
pg_catalog	stl_perf_channel_source	bytes_transferred	int8
pg_catalog	stl_perf_channel_source	channel_id	int4
pg_catalog	stl_perf_channel_source	channel_type	int4
pg_catalog	stl_perf_channel_source	close_time	timestamp
pg_catalog	stl_perf_channel_source	first_packet_time	timestamp
pg_catalog	stl_perf_channel_source	last_packet_time	timestamp
pg_catalog	stl_perf_channel_source	packet_count	int8
pg_catalog	stl_perf_channel_source	query_id	int4
pg_catalog	stl_perf_channel_source	queue_delay_max_time	int8
pg_catalog	stl_perf_channel_source	queue_delay_total_time	int8
pg_catalog	stl_perf_channel_source	segment_number	int4
pg_catalog	stl_perf_channel_source	slice_number	int4
pg_catalog	stl_perf_channel_source	throughput_kilobytes_per_sec	int8

View Text

SELECT stll_perf_channel_source.query_id,
       stll_perf_channel_source.segment_number,
       stll_perf_channel_source.slice_number,
       stll_perf_channel_source.packet_count,
       stll_perf_channel_source.bytes_transferred,
       stll_perf_channel_source.channel_type,
       stll_perf_channel_source.channel_id,
       stll_perf_channel_source.first_packet_time,
       stll_perf_channel_source.last_packet_time,
       stll_perf_channel_source.close_time,
       stll_perf_channel_source.throughput_kilobytes_per_sec,
       stll_perf_channel_source.borrow_total_time,
       stll_perf_channel_source.borrow_max_time,
       stll_perf_channel_source.queue_delay_total_time,
       stll_perf_channel_source.queue_delay_max_time
FROM stll_perf_channel_source

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