Redshift Observatory

System Table Tracker

System view pg_catalog.svl_omnisql_error version 1.0.81462 / 2025-01-09

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 Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers