The following query lists open PostgreSQL transactions
SELECT
pid,
usename,
datname,
application_name,
client_addr,
state,
backend_start,
xact_start,
query_start,
state_change,
query
FROM
pg_stat_activity
WHERE
state = 'active' AND
xact_start IS NOT NULL
ORDER BY
xact_start;