> 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 - tha
have 150+
databases in our cluster, so perhaps I missed something. I also did a grep
on the netdata directories, but nothing as well.
-Steeve
On Sat, Nov 23, 2024 at 10:19 AM Adrian Klaver
wrote:
> On 11/23/24 05:16, Steeve Boulanger wrote:
> >> Here (Ireland) we sometimes say
gating, but I think that calling the "ghostbusters" is
moving up the list now lol.
On Sat, Nov 23, 2024 at 7:09 AM Ray O'Donnell wrote:
>
> On 23/11/2024 13:06, Steeve Boulanger wrote:
>
>
> > The above is some garden variety select?
>
> Not 100% sure what the
, Nov 22, 2024 at 11:18 AM Adrian Klaver
wrote:
> On 11/21/24 15:50, Steeve Boulanger wrote:
> > > 1) Do the 77 share some trait the other 80 don't.
> >
> > No pattern found yet .. but still verifying a few things
> >
> > > 2) Do the OS system logs reve
f tomorrow we're still seeing the stats reset or not. I can
report back tomorrow on this.
> 5) Is the cluster directly open to the world?
No. It's an on-premise installation. Only local applications can connect to
it.
-Steeve
On Thu, Nov 21, 2024 at 4:32 PM Adrian Klaver
wrote:
&g
t_time() as uptime;
uptime
-
15 days 10:03:44.048383
-Steeve
On Thu, Nov 21, 2024 at 3:30 PM Ron Johnson wrote:
> On Thu, Nov 21, 2024 at 4:12 PM Adrian Klaver
> wrote:
>
>> On 11/21/24 12:57, Steeve Boulanger wrote:
>> >
>> > > Please re
> All I can think to do is look at the logs around the stats_reset times
> for the databases and see if there is anything relevant.
That was already done, but nothing relevant was found unfortunately.
-Steeve
On Thu, Nov 21, 2024 at 3:12 PM Adrian Klaver
wrote:
> On 11/21/24 12:5
ing | pending_restart
-+-+-
log_min_error_statement | error | f
> 2) Did you reload the server when changing?:
yes - pg_reload_conf()
-Steeve
On Thu, Nov 21, 2024 at 2:49 PM Adrian Klaver
wrote:
> On 11/21/24 12:34, Steeve Boulanger wrote:
>
> Please reply to list also.
>
>
Hello,
I have noticed recently that our databases (ie most but not all) have their
stats reset on daily basis:
select count(case when stats_reset > (now() - interval '1 day') then 1 else
null end) db_reset_cnt, count(*) db_total_cnt from pg_stat_database;
db_reset_cnt | db_total_cnt
