Search Postgresql Archives

Re: Null database entry in pg_stat_database on pg-12 version

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, May 26, 2021 at 9:20 AM RAJAMOHAN <garajamohan@xxxxxxxxx> 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/





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux