Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3retries version 1.0.75672 / 2024-09-28

schema	name	column	data type
pg_catalog	stl_s3retries	connect_retries	int4
pg_catalog	stl_s3retries	connect_time	timestamp
pg_catalog	stl_s3retries	eventtime	timestamp
pg_catalog	stl_s3retries	exectask_time	timestamp
pg_catalog	stl_s3retries	fast_forward_fetch_time	timestamp
pg_catalog	stl_s3retries	fetch_time	timestamp
pg_catalog	stl_s3retries	file_size	int8
pg_catalog	stl_s3retries	length	int8
pg_catalog	stl_s3retries	location	char(256)
pg_catalog	stl_s3retries	message	char(256)
pg_catalog	stl_s3retries	node	int4
pg_catalog	stl_s3retries	query	int4
pg_catalog	stl_s3retries	request_id	char(16)
pg_catalog	stl_s3retries	retries	int4
pg_catalog	stl_s3retries	retry_backoff_ms	int4
pg_catalog	stl_s3retries	scan_type	int4
pg_catalog	stl_s3retries	segment	int4
pg_catalog	stl_s3retries	slice	int4
pg_catalog	stl_s3retries	start_offset	int8
pg_catalog	stl_s3retries	state	int4
pg_catalog	stl_s3retries	successful_fetches	int4
pg_catalog	stl_s3retries	timeout	int8
pg_catalog	stl_s3retries	userid	int4
pg_catalog	stl_s3retries	uuid	char(36)

View Text

SELECT stll_s3retries.userid,
       stll_s3retries.query,
       stll_s3retries.uuid,
       stll_s3retries.segment,
       stll_s3retries.node,
       stll_s3retries.slice,
       stll_s3retries.eventtime,
       stll_s3retries.retries,
       stll_s3retries.successful_fetches,
       stll_s3retries.file_size,
       stll_s3retries.start_offset,
       stll_s3retries.length,
       stll_s3retries.location,
       stll_s3retries.message,
       stll_s3retries.retry_backoff_ms,
       stll_s3retries.scan_type,
       stll_s3retries.timeout,
       stll_s3retries.connect_retries,
       stll_s3retries.connect_time,
       stll_s3retries.exectask_time,
       stll_s3retries.fast_forward_fetch_time,
       stll_s3retries.fetch_time,
       stll_s3retries.request_id,
       stll_s3retries.state
FROM stll_s3retries
WHERE stll_s3retries.access_control = 0
   OR stll_s3retries.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