Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3log version 1.0.76832 / 2024-10-24

schema	name	column	data type
pg_catalog	stl_s3log	error_type	int4
pg_catalog	stl_s3log	eventtime	timestamp
pg_catalog	stl_s3log	is_internal	int4
pg_catalog	stl_s3log	message	char(512)
pg_catalog	stl_s3log	node	int4
pg_catalog	stl_s3log	pid	int4
pg_catalog	stl_s3log	query	int4
pg_catalog	stl_s3log	request_id	char(16)
pg_catalog	stl_s3log	scan_type	int4
pg_catalog	stl_s3log	segment	int4
pg_catalog	stl_s3log	slice	int4
pg_catalog	stl_s3log	spectrum_error_code	int4
pg_catalog	stl_s3log	step	int4
pg_catalog	stl_s3log	userid	int4
pg_catalog	stl_s3log	user_query_id	int8
pg_catalog	stl_s3log	uuid	char(36)

View Text

SELECT stll_s3log.userid,
       stll_s3log.is_internal,
       stll_s3log.pid,
       stll_s3log.query,
       stll_s3log.uuid,
       stll_s3log.segment,
       stll_s3log.step,
       stll_s3log.node,
       stll_s3log.slice,
       stll_s3log.eventtime,
       stll_s3log.message,
       stll_s3log.scan_type,
       stll_s3log.request_id,
       stll_s3log.error_type,
       stll_s3log.spectrum_error_code,
       stll_s3log.user_query_id
FROM stll_s3log
WHERE stll_s3log.access_control = 0
   OR stll_s3log.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