I don't think so, it's not current active transactions, but number of
active transactions on the CURRENT CONNECTION. No way you get that from
pg_stat_activity. So if your proc had a bunch of embedded BEGIN/END
blocks, it would be that count.
David G. Johnston wrote on 5/29/2021 10:44 AM:
> One transaction per process actively executing a query.