Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3client_internal version 1.0.105722 / 2025-01-19

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

View Text

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

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace System Table Tracker The Known Universe White Papers