Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

PG_BACKEND_PID

Returns the process ID (PID) of the server process handling the current session.

Note

The PID is not globally unique. It can be reused over time.

Syntax

Copy
pg_backend_pid()

Return Type

Returns an integer.

Example

You can correlate PG_BACKEND_PID() with log tables to retrieve information for the current session. For example, the following query returns the query ID and a portion of the query text for queries executed in the current session.

Copy
select query, substring(text,1,40) from stl_querytext where pid = PG_BACKEND_PID() order by query desc; query | substring -------+------------------------------------------ 14831 | select query, substring(text,1,40) from 14827 | select query, substring(path,0,80) as pa 14826 | copy category from 's3://dw-tickit/manif 14825 | Count rows in target table 14824 | unload ('select * from category') to 's3 (5 rows)

You can correlate PG_BACKEND_PID() with the pid column in the following log tables (exceptions are noted in parentheses):

On this page: