Find uncommitted transactions in PostgreSQL

uncommittedTxns.sql

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

i tested it but it does behave as expected
in sql server there is a variable called @@trancount that is able to specify the number of open transaction (uncommitted)
but i can't find a way in postgres to give me the same behavior
Any way thank you

This worked for me
select count(*)
from pg_locks
where pid = pg_backend_pid()
and locktype in ('transactionid')

to find transactions:

SELECT pid, state, query
FROM pg_stat_activity
WHERE state = 'active';

to abort all transactions:

SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE state = 'active';