Postgres Pro
Downloads
Home   >   mailing lists

Re: [16Beta1][doc] pgstat: Track time of the last scan of a relation - Mailing list pgsql-hackers

From David Rowley
Subject Re: [16Beta1][doc] pgstat: Track time of the last scan of a relation
Date
Msg-id CAApHDvqRvjNtt0H=7Oid0QMz3Pw0TaTUJ78tpvVSonJgU0rOYw@mail.gmail.com
Whole thread Raw
In response to [16Beta1][doc] pgstat: Track time of the last scan of a relation  ("Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi.shinoda@hpe.com>)
Responses RE: [16Beta1][doc] pgstat: Track time of the last scan of a relation
List pgsql-hackers
Tree view 
On Wed, 31 May 2023 at 15:57, Shinoda, Noriyoshi (PN Japan FSIP)
<noriyoshi.shinoda@hpe.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
timestampwith time zone.
 

I've now pushed this change.

David

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: confusion about this commit "Revert "Skip redundant anti-wraparound vacuums""
Next
From: jiye
Date:
Subject: Re: confusion about this commit "Revert "Skip redundant anti-wraparound vacuums""