This page has not been translated into your language. Request translation

SVL_TERMINATE

PDFRSS

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)