Redshift Research Project

System Table Tracker

System view pg_catalog.svl_multi_statement_violations version 1.0.44903 / 2022-12-19

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