Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_awsclient_requests	access_key_id	char(36)
pg_catalog	stl_awsclient_requests	amzn_request_id	char(36)
pg_catalog	stl_awsclient_requests	canonical_query_string	char(1024)
pg_catalog	stl_awsclient_requests	canonical_uri	char(1024)
pg_catalog	stl_awsclient_requests	endpoint	char(128)
pg_catalog	stl_awsclient_requests	http_method	char(64)
pg_catalog	stl_awsclient_requests	network_namespace	int4
pg_catalog	stl_awsclient_requests	operation_name	char(128)
pg_catalog	stl_awsclient_requests	pid	int4
pg_catalog	stl_awsclient_requests	query	int4
pg_catalog	stl_awsclient_requests	recordtime	timestamp
pg_catalog	stl_awsclient_requests	response_code	int4
pg_catalog	stl_awsclient_requests	slice	int4
pg_catalog	stl_awsclient_requests	userid	int4

View Text

SELECT stll_awsclient_requests.userid,
       stll_awsclient_requests.query,
       stll_awsclient_requests.slice,
       stll_awsclient_requests.recordtime,
       stll_awsclient_requests.pid,
       stll_awsclient_requests.http_method,
       stll_awsclient_requests.endpoint,
       stll_awsclient_requests.amzn_request_id,
       stll_awsclient_requests.response_code,
       stll_awsclient_requests.operation_name,
       stll_awsclient_requests.canonical_uri,
       stll_awsclient_requests.canonical_query_string,
       stll_awsclient_requests.network_namespace,
       stll_awsclient_requests.access_key_id
FROM stll_awsclient_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