Re: SQL to query running transactions with subtransactions that exceeds 64

On Tue, 2021-01-05 at 10:42 +0000, Li EF Zhang wrote:
> I am new to postgresql and sql. I want to check running transactions whose
>  subtransactions exceeds 64. Is there any SQL statement or other method can
>  do this? Thanks!

You may want to read
https://www.cybertec-postgresql.com/en/subtransactions-and-performance-in-postgresql/

You could export a snapshot with pg_export_snapshot() and see if the resulting file
contains the line "sof:1".

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com