Redshift Observatory

System Table Tracker

System view pg_catalog.stl_aqua_requests version 1.0.43931 / 2022-11-18

schema	name	column	data type
pg_catalog	stl_aqua_requests	aqua_endpoint	char(85)
pg_catalog	stl_aqua_requests	aqua_shard_id	char(10)
pg_catalog	stl_aqua_requests	aqua_table_arn	char(100)
pg_catalog	stl_aqua_requests	duration	int8
pg_catalog	stl_aqua_requests	eventtime	timestamp
pg_catalog	stl_aqua_requests	failed	int4
pg_catalog	stl_aqua_requests	node	int4
pg_catalog	stl_aqua_requests	pid	int4
pg_catalog	stl_aqua_requests	query	int4
pg_catalog	stl_aqua_requests	request_id	char(16)
pg_catalog	stl_aqua_requests	segment	int4
pg_catalog	stl_aqua_requests	slice	int4
pg_catalog	stl_aqua_requests	uuid	char(36)

View Text

SELECT stll_aqua_requests.query,
       stll_aqua_requests.uuid,
       stll_aqua_requests.pid,
       stll_aqua_requests.segment,
       stll_aqua_requests.node,
       stll_aqua_requests.slice,
       stll_aqua_requests.aqua_shard_id,
       stll_aqua_requests.eventtime,
       stll_aqua_requests.duration,
       stll_aqua_requests.aqua_table_arn,
       stll_aqua_requests.aqua_endpoint,
       stll_aqua_requests.failed,
       stll_aqua_requests.request_id
FROM stll_aqua_requests

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