Redshift Observatory

System Table Tracker

System view pg_catalog.svl_multi_statement_violations version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog svl_multi_statement_violations cmdname char(20)
pg_catalog svl_multi_statement_violations database char(32)
pg_catalog svl_multi_statement_violations endtime timestamp
pg_catalog svl_multi_statement_violations label char(320)
pg_catalog svl_multi_statement_violations pid int4
pg_catalog svl_multi_statement_violations sequence int4
pg_catalog svl_multi_statement_violations starttime timestamp
pg_catalog svl_multi_statement_violations text varchar(200)
pg_catalog svl_multi_statement_violations type varchar(10)
pg_catalog svl_multi_statement_violations userid int4
pg_catalog svl_multi_statement_violations xid int8

View Text

SELECT stl_multi_statement_violations.userid,
       stl_multi_statement_violations.database,
       stl_multi_statement_violations.cmdname,
       stl_multi_statement_violations.xid,
       stl_multi_statement_violations.pid,
       svl_statementtext.label,
       svl_statementtext.starttime,
       svl_statementtext.endtime,
       svl_statementtext.sequence,
       svl_statementtext.type,
       svl_statementtext.text
FROM stl_multi_statement_violations
     LEFT JOIN svl_statementtext ON svl_statementtext.userid = stl_multi_statement_violations.userid
                                AND svl_statementtext.xid = stl_multi_statement_violations.xid
                                AND svl_statementtext.pid = stl_multi_statement_violations.pid
ORDER BY stl_multi_statement_violations.xid,
         svl_statementtext.starttime


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