Redshift Observatory

System Table Tracker

System view pg_catalog.stl_perf_channel_sink version 1.0.51304 / 2023-06-04

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