public inbox for [email protected]  

help / color / mirror / Atom feed

Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why?
2+ messages / 2 participants
[nested] [flat]

* Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why?
@ 2024-11-23 17:49  Greg Sabino Mullane <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Greg Sabino Mullane @ 2024-11-23 17:49 UTC (permalink / raw)
  To: Steeve Boulanger <[email protected]>; +Cc: Ray O'Donnell <[email protected]>; Adrian Klaver <[email protected]>; 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:

ERROR:  function pg_stat_reset() does not exist

Cheers,
Greg


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why?
@ 2024-11-26 02:48  Steeve Boulanger <[email protected]>
  parent: Greg Sabino Mullane <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Steeve Boulanger @ 2024-11-26 02:48 UTC (permalink / raw)
  To: Greg Sabino Mullane <[email protected]>; +Cc: Ray O'Donnell <[email protected]>; Adrian Klaver <[email protected]>; 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 <[email protected]>
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 exist
>
> Cheers,
> Greg
>
>


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-11-26 02:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-23 17:49 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Greg Sabino Mullane <[email protected]>
2024-11-26 02:48 ` Steeve Boulanger <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox