PG_LAST_QUERY_ID
Returns the query ID of the most recently completed query in the current session. If no queries have been run in the current session, PG_LAST_QUERY_ID returns -1. PG_LAST_QUERY_ID does not return the query ID for queries that run exclusively on the leader node. For more information, see Leader node–only functions.
Syntax
pg_last_query_id()
Return type
Returns an integer.
Example
The following query returns the ID of the latest query completed in the current session.
select pg_last_query_id();
Results are the following.
pg_last_query_id ---------------- 5437 (1 row)
The following query returns the query ID and text of the most recently completed query in the current session.
select query, trim(querytxt) as sqlquery from stl_query where query = pg_last_query_id();
Results are the following.
query | sqlquery ------+-------------------------------------------------- 5437 | select name, loadtime from stl_file_scan where loadtime > 1000000; (1 rows)