| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | RAJAMOHAN <garajamohan(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Null database entry in pg_stat_database on pg-12 version |
| Date: | 2021-05-26 07:51:51 |
| Message-ID: | CABUevEzMHzdAQjvpWO6eGSZeg8FKmLLPhdwVoqaOXR8VWnyd8w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, May 26, 2021 at 9:20 AM RAJAMOHAN <garajamohan(at)gmail(dot)com> wrote:
>
> Hello all,
>
> Today I came across this null database entry with oid as 0 in pg_stat_database on postgresql-12 version.
>
> Any particular use case is there for this? It also has some column values, how it is gathering those data and which database is responsible for this?
Yes. This is new in PostgreSQL 12
(https://www.postgresql.org/docs/12/release-12.html) It tracks
accesses to shared objects
(https://www.postgresql.org/docs/12/monitoring-stats.html#PG-STAT-DATABASE-VIEW)
--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 张元超 | 2021-05-26 09:15:00 | An exception about comparison operators |
| Previous Message | RAJAMOHAN | 2021-05-26 07:19:31 | Null database entry in pg_stat_database on pg-12 version |