Multiple open transactions in idle instance

SELECT at.transaction_id, 
       at.transaction_begin_time, 
       at.transaction_state,
       at.transaction_status,
       at.transaction_status2,
       at.dtc_state,
       at.dtc_status,
       st.session_id,
       STH.text
FROM sys.dm_tran_active_transactions at
LEFT JOIN sys.dm_tran_session_transactions st 
LEFT JOIN sys.dm_exec_connections CN ON CN.session_id = st.session_id
    ON at.transaction_id = st.transaction_id
CROSS APPLY sys.dm_exec_sql_text(CN.most_recent_sql_handle) AS STH
ORDER BY transaction_begin_time;

SELECT count(*) FROM sys.sysprocesses t where t.open_tran=1;

select * from pg_stat_activity;
select count(*) from pg_locks;