Redshift Research Project

System Table Tracker

System view pg_catalog.stl_s3client_trace version 1.0.59117 / 2023-11-08

schema	name	column	data type
pg_catalog	stl_s3client_trace	bucket	char(64)
pg_catalog	stl_s3client_trace	col_num	int4
pg_catalog	stl_s3client_trace	flags	int4
pg_catalog	stl_s3client_trace	http_method	char(64)
pg_catalog	stl_s3client_trace	is_partial	int4
pg_catalog	stl_s3client_trace	is_s3commit_write	int4
pg_catalog	stl_s3client_trace	is_wam_write	int4
pg_catalog	stl_s3client_trace	is_xregion	int4
pg_catalog	stl_s3client_trace	key	char(256)
pg_catalog	stl_s3client_trace	message	char(256)
pg_catalog	stl_s3client_trace	node	int4
pg_catalog	stl_s3client_trace	one_perm_rep	int4
pg_catalog	stl_s3client_trace	pid	int4
pg_catalog	stl_s3client_trace	query	int4
pg_catalog	stl_s3client_trace	recordtime	timestamp
pg_catalog	stl_s3client_trace	region	char(64)
pg_catalog	stl_s3client_trace	s3_action	char(64)
pg_catalog	stl_s3client_trace	s3_write_type	char(64)
pg_catalog	stl_s3client_trace	sb_pos	int4
pg_catalog	stl_s3client_trace	slice	int4
pg_catalog	stl_s3client_trace	start_offset	int8
pg_catalog	stl_s3client_trace	table_id	int4
pg_catalog	stl_s3client_trace	userid	int4
pg_catalog	stl_s3client_trace	wam_precommit_id	int4

View Text

SELECT stll_s3client_trace.userid,
       stll_s3client_trace.query,
       stll_s3client_trace.slice,
       stll_s3client_trace.recordtime,
       stll_s3client_trace.pid,
       stll_s3client_trace.http_method,
       stll_s3client_trace.s3_action,
       stll_s3client_trace.bucket,
       stll_s3client_trace.key,
       stll_s3client_trace.message,
       stll_s3client_trace.node,
       stll_s3client_trace.table_id,
       stll_s3client_trace.one_perm_rep,
       stll_s3client_trace.flags,
       stll_s3client_trace.s3_write_type,
       stll_s3client_trace.is_s3commit_write,
       stll_s3client_trace.is_partial,
       stll_s3client_trace.start_offset,
       stll_s3client_trace.col_num,
       stll_s3client_trace.is_wam_write,
       stll_s3client_trace.wam_precommit_id,
       stll_s3client_trace.region,
       stll_s3client_trace.is_xregion,
       stll_s3client_trace.sb_pos
FROM stll_s3client_trace

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