| From: | "Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi(dot)shinoda(at)hpe(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | "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: | [16Beta1][doc] pgstat: Track time of the last scan of a relation |
| Date: | 2023-05-31 03:56:51 |
| Message-ID: | DM4PR84MB17348EA11FA90A9BE896AF89EE489@DM4PR84MB1734.NAMPRD84.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi, hackers.
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.
[1] pgstat: Track time of the last scan of a relation
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c037471832e1ec3327f81eebbd8892e5c1042fe0
[2] pg_stat_activity view
https://www.postgresql.org/docs/16/monitoring-stats.html#MONITORING-PG-STAT-ALL-TABLES-VIEW
Regards,
Noriyoshi Shinoda
| Attachment | Content-Type | Size |
|---|---|---|
| pg_stat_all_tables_doc_v1.diff | application/octet-stream | 1.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Drouvot, Bertrand | 2023-05-31 05:52:05 | Re: BF animal dikkop reported a failure in 035_standby_logical_decoding |
| Previous Message | Richard Guo | 2023-05-31 02:47:03 | Re: ERROR: wrong varnullingrels (b 3) (expected (b)) for Var 2/1 |