Redshift Observatory

System Table Tracker

System view pg_catalog.svl_omnisql_error version 1.0.47470 / 2023-03-11

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