Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pCmcD-0002gb-B0 for pgsql-admin@arkaria.postgresql.org; Tue, 03 Jan 2023 19:06:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pCmcC-0000cq-88 for pgsql-admin@arkaria.postgresql.org; Tue, 03 Jan 2023 19:06:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pCmcB-0000cI-Qs for pgsql-admin@lists.postgresql.org; Tue, 03 Jan 2023 19:06:23 +0000 Received: from mail-pj1-x1031.google.com ([2607:f8b0:4864:20::1031]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pCmc9-0007Dq-Cx for pgsql-admin@postgresql.org; Tue, 03 Jan 2023 19:06:23 +0000 Received: by mail-pj1-x1031.google.com with SMTP id c8-20020a17090a4d0800b00225c3614161so29625864pjg.5 for ; Tue, 03 Jan 2023 11:06:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ardentperf-com.20210112.gappssmtp.com; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=8PUiqmAn5AMKRfwKjBpFz1uZJQ3yZsUmYsjmYLOjXws=; b=wEGMbH2CjblQ1qtk+1Ul+HfJ6oWSvqSxfqTtHEPixW0bNjX1pwRXCxJ9ca2G9OpzMB 4fqumgozE7qpaxzK+QYTdhw5YyRaWzp3FUC3dzHPMM26/+4PJUQoiIc8K5n/ZO9feiHY RHF0kp10md8yz9i7fkAs1XrYIKYiHr4xxqPcmiEQ0JCBKGfvwKxYTz8JpDIQzApOtsh6 r5kGEyxMWozBaenYx6LEEB+OJNWRF6UQIZ+lbS2PYedgR0UQmyrJCACE243pV+43EhIC JNfdXhGEH3S6HVrZInqww2lNP44Gci6fVO4MxX4xA6gkex8VoJ7dtA+wasuvhcpbQnpY 6jqA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=8PUiqmAn5AMKRfwKjBpFz1uZJQ3yZsUmYsjmYLOjXws=; b=CJ1BPmO9236Hv90aCBVF1dDWhYEdI9bsA8wqCbOvpkTc+ewX4lXBiLUPUOmSs5mVLx Jy6LYX4Xfcrzi6oz5/BOHE+uIvC8Ut2p7ldgNJySzY3TRDKmGCWbZMnKMEdQ+52eHHWB hUdYUqo/IMW2CHhZXXr3tSBR6DoozNqvArBMu91raGWb+lty/s6DTZMaTmuRcXhPaFph VsFKr5hPX6JsoY+rMnso/GtXhriG+SPVBy4+xn0wzymvD6MMUH5F9TCw7OMFDOvN6ooR u2Icg+VfGNnPWDMOWL5VcZgzfild1BSxAHRU1hpUkRIB282p3wr12ImQcinhWL5HtGQh lwyA== X-Gm-Message-State: AFqh2kpdmcypAy+PpPmt6qFwJK8eoM/jjfydNv3LkPsKOxLY7/UVG4Bb mbkdhv184zSePWbkexWsptXrKA== X-Google-Smtp-Source: AMrXdXsWWe1ZSf/VG1e0itVXBz16iXA1ETuZVY0fBHzowgH6wts1viUztSiI0gjEG66uTRW6VDq3rQ== X-Received: by 2002:a17:90a:6281:b0:219:b1f3:2401 with SMTP id d1-20020a17090a628100b00219b1f32401mr47981632pjj.13.1672772779181; Tue, 03 Jan 2023 11:06:19 -0800 (PST) Received: from [10.223.244.101] (54-240-196-168.amazon.com. [54.240.196.168]) by smtp.gmail.com with ESMTPSA id om1-20020a17090b3a8100b00218fba260e2sm15050601pjb.43.2023.01.03.11.06.18 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 03 Jan 2023 11:06:18 -0800 (PST) Content-Type: multipart/alternative; boundary="------------kUyFeSrR3az09pwQVWOEonTC" Message-ID: Date: Tue, 3 Jan 2023 11:06:17 -0800 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.6.1 Subject: Re: Subtransactions in PostgreSQL Content-Language: en-US To: Amine Tengilimoglu , pgsql-admin References: From: Jeremy Schneider In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------kUyFeSrR3az09pwQVWOEonTC Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit On 1/3/23 10:10 AM, Amine Tengilimoglu wrote: > Is there any way to detect the main transaction of a subtransaction in > postgres, or any tool that can read the files in pg_subtrans? Would this extension help? https://github.com/bdrouvot/pg_subtrans_infos -- http://about.me/jeremy_schneider --------------kUyFeSrR3az09pwQVWOEonTC Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
On 1/3/23 10:10 AM, Amine Tengilimoglu wrote:
Is there any way to detect the main transaction of a subtransaction in postgres, or any tool that can read the files in pg_subtrans?

Would this extension help?

https://github.com/bdrouvot/pg_subtrans_infos


-- 
http://about.me/jeremy_schneider
--------------kUyFeSrR3az09pwQVWOEonTC--