Redshift Observatory

System Table Tracker

System view pg_catalog.svl_omnisql_error version 1.0.48004 / 2023-03-20

schema	name	column	data type
pg_catalog	svl_omnisql_error	errcode	int4
pg_catalog	svl_omnisql_error	error	text
pg_catalog	svl_omnisql_error	file	text
pg_catalog	svl_omnisql_error	linenum	int4
pg_catalog	svl_omnisql_error	recordtime	timestamp
pg_catalog	svl_omnisql_error	sql	text
pg_catalog	svl_omnisql_error	userid	int4

View Text

SELECT e.userid,
       e.recordtime,
       e.errcode,
       btrim(CAST(e.file AS text)) AS file,
       e.linenum,
       btrim(CAST(e.error AS text)) AS error,
       btrim(CAST(q.querytxt AS text)) AS sql
FROM stl_omnisql_error AS e
     INNER JOIN stl_plan_qid_map AS m ON e.query = m.plan_qid
     INNER JOIN stl_query AS q ON q.query = m.query

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