SVL_TERMINATE - Amazon Redshift
Table columns
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

SVL_TERMINATE

Records the time when a user cancels or terminates a process.

SELECT PG_TERMINATE_BACKEND(pid), SELECT PG_CANCEL_BACKEND(pid), and CANCEL pid creates a log entry in SVL_TERMINATE.

SVL_TERMINATE is visible only to superusers. For more information, see Visibility of data in system tables and views.

Some or all of the data in this table can also be found in the SYS monitoring view SYS_QUERY_HISTORY. The data in the SYS monitoring view is formatted to be easier to use and understand. We recommend that you use the SYS monitoring view for your queries.

Table columns

Column name Data type Description
pid integer The process ID of the canceled or terminated process.
eventtime timestamp The time when the process is canceled or terminated.
userid integer The user ID of the user running the command.
type string The type of termination. It can be CANCEL or TERMINATE.

The following command shows the latest cancelled query.

select * from svl_terminate order by eventtime desc limit 1;
 pid  |         eventtime          | userid |  type  
------+----------------------------+--------+--------
 8324 | 2020-03-24 09:42:07.298937 |      1 | CANCEL
(1 row)