How to get active table within a transaction.

From: Hubert Zhang <hzhang(at)pivotal(dot)io>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: How to get active table within a transaction.
Date: 2018-09-20 04:08:11
Message-ID: CAB0yremURAktYYCiycHJ-h=EWshvYXv4QyLcN-w0OtE2+nZnww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

I have a requirement to get the active table list in a child postmaster
process.

We are able to get the active table list after corresponding transaction
ends by using stat collector. Each postgres process will gather the table
change information locally, but only send the stat info to collector after
transaction end(become idle).

As an enhancement, we also want to get the active table while the
transaction inserting the table is in progress. Delay is acceptable.

Is there any existing ways in PG to support it?

--
Thanks

Hubert Zhang

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Lepikhov 2018-09-20 04:35:43 Re: [WIP] [B-Tree] Retail IndexTuple deletion
Previous Message Pavel Stehule 2018-09-20 03:54:43 Re: Query is over 2x slower with jit=on