Redshift Observatory

System Table Tracker

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

View Text

SELECT spcm.userid,
       spc.session_userid,
       spc.pid,
       spc.xid,
       spcm.query,
       spcm.recordtime,
       spcm.loglevel,
       CASE
         WHEN spcm.loglevel = 10
           THEN CAST('DEBUG' AS text)
         WHEN spcm.loglevel = 20
           THEN CAST('LOG' AS text)
         WHEN spcm.loglevel = 30
           THEN CAST('INFO' AS text)
         WHEN spcm.loglevel = 40
           THEN CAST('NOTICE' AS text)
         WHEN spcm.loglevel = 50
           THEN CAST('WARNING' AS text)
         WHEN spcm.loglevel = 60
           THEN CAST('EXCEPTION' AS text)
         ELSE CAST(NULL AS text)
       END AS loglevel_text,
       spcm.message,
       spcm.linenum,
       spc.querytxt,
       spc.label,
       spc.aborted,
       spcm.message_xid
FROM stl_stored_proc_messages AS spcm
     LEFT JOIN stl_stored_proc_call AS spc ON spcm.query = spc.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