Redshift Observatory

System Table Tracker

System view pg_catalog.svl_stored_proc_messages version 1.0.46806 / 2023-02-21

schema name column data type
pg_catalog svl_stored_proc_messages aborted int4
pg_catalog svl_stored_proc_messages label char(320)
pg_catalog svl_stored_proc_messages linenum int4
pg_catalog svl_stored_proc_messages loglevel int4
pg_catalog svl_stored_proc_messages loglevel_text text
pg_catalog svl_stored_proc_messages message char(1024)
pg_catalog svl_stored_proc_messages pid int4
pg_catalog svl_stored_proc_messages query int4
pg_catalog svl_stored_proc_messages querytxt char(500)
pg_catalog svl_stored_proc_messages recordtime timestamp
pg_catalog svl_stored_proc_messages session_userid int4
pg_catalog svl_stored_proc_messages userid int4
pg_catalog svl_stored_proc_messages xid int8

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
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