RE: [16Beta1][doc] pgstat: Track time of the last scan of a relation

From: "Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi(dot)shinoda(at)hpe(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, "dpage(at)pgadmin(dot)org" <dpage(at)pgadmin(dot)org>, "andres(at)anarazel(dot)de" <andres(at)anarazel(dot)de>, "bruce(at)momjian(dot)us" <bruce(at)momjian(dot)us>, "vik(at)postgresfriends(dot)org" <vik(at)postgresfriends(dot)org>
Subject: RE: [16Beta1][doc] pgstat: Track time of the last scan of a relation
Date: 2023-06-05 07:04:38
Message-ID: DM4PR84MB1734C63A08FA03F3DABC676BEE4DA@DM4PR84MB1734.NAMPRD84.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi, David.

> I've now pushed this change.
Thank you so much.

-----Original Message-----
From: David Rowley <dgrowleyml(at)gmail(dot)com>
Sent: Monday, June 5, 2023 2:37 PM
To: Shinoda, Noriyoshi (PN Japan FSIP) <noriyoshi(dot)shinoda(at)hpe(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>; dpage(at)pgadmin(dot)org; andres(at)anarazel(dot)de; bruce(at)momjian(dot)us; vik(at)postgresfriends(dot)org
Subject: Re: [16Beta1][doc] pgstat: Track time of the last scan of a relation

On Wed, 31 May 2023 at 15:57, Shinoda, Noriyoshi (PN Japan FSIP) <noriyoshi(dot)shinoda(at)hpe(dot)com> wrote:
> PostgreSQL 16 Beta1, added last access time to pg_stat_all_tables and pg_stat_all_indexes views by this patch [1].
> According to the documentation [2], the data type of the columns added to these views is 'timestamptz'.
> However, columns of the same data type in pg_stat_all_tables.last_vacuum, last_analyze and other tables are unified to 'timestamp with time zone'. The attached patch changes the data type of the added column from timestamptz to timestamp with time zone.

I've now pushed this change.

David

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gurjeet Singh 2023-06-05 07:22:15 Re: Mark a transaction uncommittable
Previous Message jiye 2023-06-05 05:50:20 Re: confusion about this commit "Revert "Skip redundant anti-wraparound vacuums""