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
