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

2023-06-05 Thread Shinoda, Noriyoshi (PN Japan FSIP)
ends.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) wrote: > PostgreSQL 16 Beta1, added last access time to pg_stat_all_tables and > pg_stat_all_indexes views by this patch [1]. >

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

2023-06-04 Thread David Rowley
On Wed, 31 May 2023 at 15:57, Shinoda, Noriyoshi (PN Japan FSIP) 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 'timestampt

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

2023-06-01 Thread Shinoda, Noriyoshi (PN Japan FSIP)
- From: David Rowley Sent: Wednesday, May 31, 2023 3:14 PM To: Shinoda, Noriyoshi (PN Japan FSIP) Cc: PostgreSQL-development ; dp...@pgadmin.org; and...@anarazel.de; br...@momjian.us; v...@postgresfriends.org Subject: Re: [16Beta1][doc] pgstat: Track time of the last scan of a relation On W

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

2023-05-30 Thread David Rowley
On Wed, 31 May 2023 at 15:57, Shinoda, Noriyoshi (PN Japan FSIP) wrote: > 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 unif