Redshift Observatory

System Table Tracker

System view pg_catalog.svl_s3log version 1.0.69451 / 2024-06-27

schema	name	column	data type
pg_catalog	svl_s3log	eventtime	timestamp
pg_catalog	svl_s3log	message	text
pg_catalog	svl_s3log	node	int4
pg_catalog	svl_s3log	pid	int4
pg_catalog	svl_s3log	query	int4
pg_catalog	svl_s3log	segment	int4
pg_catalog	svl_s3log	slice	int4
pg_catalog	svl_s3log	step	int4

View Text

SELECT stl_s3log.pid,
       stl_s3log.query,
       stl_s3log.segment,
       stl_s3log.step,
       stl_s3log.node,
       stl_s3log.slice,
       stl_s3log.eventtime,
       btrim(CAST(stl_s3log.message AS text)) AS message
FROM stl_s3log
WHERE stl_s3log.is_internal = 0

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