Redshift Observatory

System Table Tracker

System view pg_catalog.stl_stored_proc_messages version 1.0.69065 / 2024-06-27

schema	name	column	data type
pg_catalog	stl_stored_proc_messages	linenum	int4
pg_catalog	stl_stored_proc_messages	loglevel	int4
pg_catalog	stl_stored_proc_messages	message	char(1024)
pg_catalog	stl_stored_proc_messages	message_xid	int8
pg_catalog	stl_stored_proc_messages	query	int4
pg_catalog	stl_stored_proc_messages	recordtime	timestamp
pg_catalog	stl_stored_proc_messages	userid	int4

View Text

SELECT stll_stored_proc_messages.userid,
       stll_stored_proc_messages.query,
       stll_stored_proc_messages.loglevel,
       stll_stored_proc_messages.message,
       stll_stored_proc_messages.linenum,
       stll_stored_proc_messages.recordtime,
       stll_stored_proc_messages.message_xid
FROM stll_stored_proc_messages
WHERE stll_stored_proc_messages.access_control = 0
   OR stll_stored_proc_messages.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