Redshift Observatory

System Table Tracker

System view pg_catalog.stl_alert_messages version 1.0.45698 / 2023-01-27

schema	name	column	data type
pg_catalog	stl_alert_messages	code	int4
pg_catalog	stl_alert_messages	context	char(512)
pg_catalog	stl_alert_messages	critical	int4
pg_catalog	stl_alert_messages	error	char(512)
pg_catalog	stl_alert_messages	eventtime	timestamp
pg_catalog	stl_alert_messages	exceptionid	int4
pg_catalog	stl_alert_messages	file	char(512)
pg_catalog	stl_alert_messages	linenumber	int4
pg_catalog	stl_alert_messages	minicore_file	char(1057)
pg_catalog	stl_alert_messages	node_id	int4
pg_catalog	stl_alert_messages	padb	char(32)
pg_catalog	stl_alert_messages	pid	int4
pg_catalog	stl_alert_messages	process	char(64)
pg_catalog	stl_alert_messages	query	int4
pg_catalog	stl_alert_messages	restart_trace_id	char(64)
pg_catalog	stl_alert_messages	tracefile	char(512)
pg_catalog	stl_alert_messages	unique_exception_identifier	char(46)

View Text

SELECT stll_alert_messages.eventtime,
       stll_alert_messages.pid,
       stll_alert_messages.error,
       stll_alert_messages.code,
       stll_alert_messages.context,
       stll_alert_messages.query,
       stll_alert_messages.file,
       stll_alert_messages.linenumber,
       stll_alert_messages.process,
       stll_alert_messages.padb,
       stll_alert_messages.tracefile,
       stll_alert_messages.critical,
       stll_alert_messages.exceptionid,
       stll_alert_messages.unique_exception_identifier,
       stll_alert_messages.minicore_file,
       stll_alert_messages.node_id,
       stll_alert_messages.restart_trace_id
FROM stll_alert_messages

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