Postgres Pro
Downloads
Home   >   mailing lists

Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why?
Date
Msg-id CAKAnmmLnTkwgpbmjafjWcxci29Jn24nF8gqUp4kmbBv_YFASCQ@mail.gmail.com
Whole thread Raw
In response to Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why?  (Steeve Boulanger <sboulanger29@gmail.com>)
Responses Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why?
List pgsql-general
Tree view
As a superuser, rename pg_stat_reset inside one of the commonly affected databases:

alter function pg_stat_reset rename to hey_stop_running_pg_stat_reset_already;

Then see who starts complaining. Additionally, your server log will get helpful entries like this:

ERROR:  function pg_stat_reset() does not exist

Cheers,
Greg

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why?
Next
From: Bruce Momjian
Date:
Subject: Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10