SQL to query running transactions with subtransactions that exceeds 64

From: "Li EF Zhang" <bjzhangl(at)cn(dot)ibm(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: SQL to query running transactions with subtransactions that exceeds 64
Date: 2021-01-05 10:42:18
Message-ID: OFDF3972D7.C7B31878-ON00258654.003A6B40-00258654.003ACE1D@notes.na.collabserv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div dir="ltr" >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!</div></div></div><BR>

Attachment Content-Type Size
unknown_filename text/html 396 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2021-01-05 14:49:06 duplicate key value violates unique constraint pg_default_acl_role_nsp_obj_index
Previous Message Alban Hertroys 2021-01-04 20:34:16 Re: Trigger with conditional predicates