Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_perf_channel_source	borrow_max_ns	int8
pg_catalog	stl_perf_channel_source	borrow_total_ns	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_source_init_us	int8
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_sample_max_ns	int8
pg_catalog	stl_perf_channel_source	queue_delay_sample_total_ns	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_kb_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_kb_sec,
       stll_perf_channel_source.borrow_total_ns,
       stll_perf_channel_source.borrow_max_ns,
       stll_perf_channel_source.queue_delay_sample_total_ns,
       stll_perf_channel_source.queue_delay_sample_max_ns,
       stll_perf_channel_source.channel_source_init_us
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