Redshift Observatory

System Table Tracker

System view pg_catalog.svl_omnisql_error version 1.0.52931 / 2023-07-07

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