Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why?
| От | Steeve Boulanger |
|---|---|
| Тема | Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? |
| Дата | |
| Msg-id | CAAiSvx8-2MNZ=t1o_PU9R-Z84kL8c-nNGq4FMmdy9jc7z-M7FA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? (Greg Sabino Mullane <htamfids@gmail.com>) |
| Список | pgsql-general |
> 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:
Thanks for the tip Greg - that's very clever! I've done this just now, and will check back tomorrow to see if there's any corresponding error message.
NB: I hadn't originally realized that the system functions (ie pg_*) were created for each database, so I had renamed only the one in the postgres database, thinking it was global (ie I'll blame this on my Oracle days ;-)).
Now I renamed the function under one database that had been verified as getting its stats reset on a daily basis. Hopefully tomorrow we'll get more interesting info!
-Steeve
On Sat, Nov 23, 2024 at 11:50 AM Greg Sabino Mullane <htamfids@gmail.com> wrote:
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 existCheers,Greg
В списке pgsql-general по дате отправления: