From: | "Nasby, Jim" <nasbyj(at)amazon(dot)com> |
---|---|
To: | Hubert Zhang <hzhang(at)pivotal(dot)io> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: How to get active table within a transaction. |
Date: | 2018-09-21 18:45:11 |
Message-ID: | 01BCA76D-A36D-4225-BEF2-C54FDBD62845@amazon.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> On Sep 19, 2018, at 11:08 PM, Hubert Zhang <hzhang(at)pivotal(dot)io> wrote:
>
> 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?
You might be able to use pg_stat_xact_all_tables for that.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-09-21 19:29:14 | Re: adding tab completions |
Previous Message | Joe Conway | 2018-09-21 17:51:04 | Re: doc - add missing documentation for "acldefault" |