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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Li EF Zhang <bjzhangl(at)cn(dot)ibm(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: SQL to query running transactions with subtransactions that exceeds 64
Date: 2021-01-06 04:49:08
Message-ID: 7e49c83b1179e052b415eb0f8f78f5f2c0dec734.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2021-01-06 05:22:37 Re: Declarative partitioning and automatically generated row-IDs using BIGSERIAL
Previous Message H 2021-01-06 02:17:55 Re: PostgreSQL 13 on CentOS 7