Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_transmit_metrics version 1.0.56242 / 2023-09-15

schema	name	column	data type
pg_catalog	stl_query_transmit_metrics	pid	int4
pg_catalog	stl_query_transmit_metrics	query	int4
pg_catalog	stl_query_transmit_metrics	recv_bytes	int8
pg_catalog	stl_query_transmit_metrics	recv_bytes_raw	int8
pg_catalog	stl_query_transmit_metrics	recv_endtime	timestamp
pg_catalog	stl_query_transmit_metrics	recv_starttime	timestamp
pg_catalog	stl_query_transmit_metrics	recv_time_spent_usec	int8
pg_catalog	stl_query_transmit_metrics	send_bytes	int8
pg_catalog	stl_query_transmit_metrics	send_bytes_raw	int8
pg_catalog	stl_query_transmit_metrics	send_endtime	timestamp
pg_catalog	stl_query_transmit_metrics	send_rows	int8
pg_catalog	stl_query_transmit_metrics	send_starttime	timestamp
pg_catalog	stl_query_transmit_metrics	send_time_spent_usec	int8
pg_catalog	stl_query_transmit_metrics	userid	int4
pg_catalog	stl_query_transmit_metrics	xid	int8

View Text

SELECT stll_query_transmit_metrics.userid,
       stll_query_transmit_metrics.xid,
       stll_query_transmit_metrics.pid,
       stll_query_transmit_metrics.query,
       stll_query_transmit_metrics.send_starttime,
       stll_query_transmit_metrics.send_endtime,
       stll_query_transmit_metrics.send_time_spent_usec,
       stll_query_transmit_metrics.send_bytes,
       stll_query_transmit_metrics.send_rows,
       stll_query_transmit_metrics.recv_starttime,
       stll_query_transmit_metrics.recv_endtime,
       stll_query_transmit_metrics.recv_time_spent_usec,
       stll_query_transmit_metrics.recv_bytes,
       stll_query_transmit_metrics.send_bytes_raw,
       stll_query_transmit_metrics.recv_bytes_raw
FROM stll_query_transmit_metrics

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