postgres check idle transaction code example

Example: postgres check idle transaction

select * 
from pg_stat_activity
where (state = 'idle in transaction')
    and xact_start is not null;