Redshift Observatory

System Table Tracker

System view pg_catalog.svl_terminate version 1.0.60854 / 2023-12-12

schema	name	column	data type
pg_catalog	svl_terminate	eventtime	timestamp
pg_catalog	svl_terminate	pid	int4
pg_catalog	svl_terminate	type	text
pg_catalog	svl_terminate	userid	int4

View Text

SELECT stl_terminate.pid,
       stl_terminate.eventtime,
       stl_terminate.userid,
       CASE
         WHEN stl_terminate.signal = 2
           THEN CAST('CANCEL' AS text)
         WHEN stl_terminate.signal = 15
           THEN CAST('TERMINATE' AS text)
         ELSE CAST('UNKNOWN' AS text)
       END AS type
FROM stl_terminate

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