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
