Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3client version 1.0.75655 / 2024-10-04

schema	name	column	data type
pg_catalog	stl_s3client	app_connect_time	int8
pg_catalog	stl_s3client	bucket	char(64)
pg_catalog	stl_s3client	col_num	int4
pg_catalog	stl_s3client	compression_time	int8
pg_catalog	stl_s3client	connect_time	int8
pg_catalog	stl_s3client	data_size	int8
pg_catalog	stl_s3client	end_time	int8
pg_catalog	stl_s3client	extended_request_id	char(128)
pg_catalog	stl_s3client	flags	int4
pg_catalog	stl_s3client	http_method	char(64)
pg_catalog	stl_s3client	ip_address	char(64)
pg_catalog	stl_s3client	is_partial	int4
pg_catalog	stl_s3client	is_s3commit_write	int4
pg_catalog	stl_s3client	is_spectrum_request	int4
pg_catalog	stl_s3client	is_wam_write	int4
pg_catalog	stl_s3client	is_xregion	int4
pg_catalog	stl_s3client	key	char(256)
pg_catalog	stl_s3client	node	int4
pg_catalog	stl_s3client	one_perm_rep	int4
pg_catalog	stl_s3client	original_start_time_us	int8
pg_catalog	stl_s3client	pid	int4
pg_catalog	stl_s3client	query	int4
pg_catalog	stl_s3client	recordtime	timestamp
pg_catalog	stl_s3client	region	char(64)
pg_catalog	stl_s3client	request_id	char(32)
pg_catalog	stl_s3client	retries	int4
pg_catalog	stl_s3client	s3_action	char(64)
pg_catalog	stl_s3client	s3_write_type	char(64)
pg_catalog	stl_s3client	sb_pos	int4
pg_catalog	stl_s3client	segnum	int8
pg_catalog	stl_s3client	slice	int4
pg_catalog	stl_s3client	start_offset	int8
pg_catalog	stl_s3client	start_time	int8
pg_catalog	stl_s3client	tbl_id	int4
pg_catalog	stl_s3client	thread_id	int4
pg_catalog	stl_s3client	total_transfer_time_us_with_retries	int8
pg_catalog	stl_s3client	transfer_size	int8
pg_catalog	stl_s3client	transfer_time	int8
pg_catalog	stl_s3client	userid	int4
pg_catalog	stl_s3client	wam_precommit_id	int4

View Text

SELECT stll_s3client.userid,
       stll_s3client.query,
       stll_s3client.slice,
       stll_s3client.recordtime,
       stll_s3client.pid,
       stll_s3client.http_method,
       stll_s3client.s3_action,
       stll_s3client.bucket,
       stll_s3client.key,
       stll_s3client.transfer_size,
       stll_s3client.data_size,
       stll_s3client.start_time,
       stll_s3client.end_time,
       stll_s3client.transfer_time,
       stll_s3client.compression_time,
       stll_s3client.connect_time,
       stll_s3client.app_connect_time,
       stll_s3client.retries,
       stll_s3client.request_id,
       stll_s3client.extended_request_id,
       stll_s3client.ip_address,
       stll_s3client.thread_id,
       stll_s3client.original_start_time_us,
       stll_s3client.total_transfer_time_us_with_retries,
       stll_s3client.node,
       stll_s3client.tbl_id,
       stll_s3client.one_perm_rep,
       stll_s3client.flags,
       stll_s3client.s3_write_type,
       stll_s3client.is_s3commit_write,
       stll_s3client.is_partial,
       stll_s3client.start_offset,
       stll_s3client.col_num,
       stll_s3client.is_wam_write,
       stll_s3client.wam_precommit_id,
       stll_s3client.region,
       stll_s3client.is_xregion,
       stll_s3client.is_spectrum_request,
       stll_s3client.segnum,
       stll_s3client.sb_pos
FROM stll_s3client
WHERE stll_s3client.access_control = 0
   OR stll_s3client.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

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