Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3query version 1.0.68205 / 2024-05-26

schema	name	column	data type
pg_catalog	stl_s3query	avg_request_duration	int8
pg_catalog	stl_s3query	avg_request_parallelism	float8
pg_catalog	stl_s3query	cache_hits	int4
pg_catalog	stl_s3query	endtime	timestamp
pg_catalog	stl_s3query	external_table_name	char(136)
pg_catalog	stl_s3query	file_format	char(16)
pg_catalog	stl_s3query	files	int4
pg_catalog	stl_s3query	has_cell_level_security	int4
pg_catalog	stl_s3query	is_copy	int4
pg_catalog	stl_s3query	is_evr	int4
pg_catalog	stl_s3query	is_governed	int4
pg_catalog	stl_s3query	is_lakeformation	int4
pg_catalog	stl_s3query	is_local	int4
pg_catalog	stl_s3query	is_nested	char(1)
pg_catalog	stl_s3query	is_partitioned	char(1)
pg_catalog	stl_s3query	is_rrscan	char(1)
pg_catalog	stl_s3query	max_allowed_parallelism	int4
pg_catalog	stl_s3query	max_concurrent_slowdown_count	int4
pg_catalog	stl_s3query	max_request_duration	int8
pg_catalog	stl_s3query	max_request_parallelism	int4
pg_catalog	stl_s3query	max_retries	int4
pg_catalog	stl_s3query	max_split_size	int8
pg_catalog	stl_s3query	node	int4
pg_catalog	stl_s3query	peakmem	int8
pg_catalog	stl_s3query	query	int4
pg_catalog	stl_s3query	query_as_of_time	timestamp
pg_catalog	stl_s3query	request_fingerprint	int8
pg_catalog	stl_s3query	s3_billable_scanned_bytes	int8
pg_catalog	stl_s3query	s3query_returned_bytes	int8
pg_catalog	stl_s3query	s3query_returned_rows	int8
pg_catalog	stl_s3query	s3query_returned_uncompressed_bytes	int8
pg_catalog	stl_s3query	s3_scanned_bytes	int8
pg_catalog	stl_s3query	s3_scanned_rows	int8
pg_catalog	stl_s3query	scan_type	int4
pg_catalog	stl_s3query	segment	int4
pg_catalog	stl_s3query	slice	int4
pg_catalog	stl_s3query	slowdown_count	int4
pg_catalog	stl_s3query	splits	int4
pg_catalog	stl_s3query	starttime	timestamp
pg_catalog	stl_s3query	step	int4
pg_catalog	stl_s3query	throttled_requests	int4
pg_catalog	stl_s3query	total_retries	int4
pg_catalog	stl_s3query	total_split_size	int8
pg_catalog	stl_s3query	transaction_id	char(32)
pg_catalog	stl_s3query	userid	int4
pg_catalog	stl_s3query	uuid	char(36)

View Text

SELECT stll_s3query.userid,
       stll_s3query.query,
       stll_s3query.uuid,
       stll_s3query.segment,
       stll_s3query.step,
       stll_s3query.node,
       stll_s3query.slice,
       stll_s3query.starttime,
       stll_s3query.endtime,
       stll_s3query.external_table_name,
       stll_s3query.is_partitioned,
       stll_s3query.is_rrscan,
       stll_s3query.s3_scanned_rows,
       stll_s3query.s3_scanned_bytes,
       stll_s3query.s3query_returned_rows,
       stll_s3query.s3query_returned_bytes,
       stll_s3query.files,
       stll_s3query.total_retries,
       stll_s3query.max_retries,
       stll_s3query.max_request_duration,
       stll_s3query.avg_request_duration,
       stll_s3query.max_request_parallelism,
       stll_s3query.max_allowed_parallelism,
       stll_s3query.avg_request_parallelism,
       stll_s3query.splits,
       stll_s3query.total_split_size,
       stll_s3query.max_split_size,
       stll_s3query.request_fingerprint,
       stll_s3query.file_format,
       stll_s3query.cache_hits,
       stll_s3query.is_copy,
       stll_s3query.is_nested,
       stll_s3query.slowdown_count,
       stll_s3query.max_concurrent_slowdown_count,
       stll_s3query.s3_billable_scanned_bytes,
       stll_s3query.scan_type,
       stll_s3query.s3query_returned_uncompressed_bytes,
       stll_s3query.is_lakeformation,
       stll_s3query.is_governed,
       stll_s3query.transaction_id,
       stll_s3query.query_as_of_time,
       stll_s3query.throttled_requests,
       stll_s3query.peakmem,
       stll_s3query.is_local,
       stll_s3query.is_evr,
       stll_s3query.has_cell_level_security
FROM stll_s3query
WHERE stll_s3query.access_control = 0
   OR stll_s3query.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