Re: Obsolete or dead serverconnections after reboot

select pg_stat_reset();

Can you run above function, to check if stats are reset and things are fine
without a pg restart?
I not able to understand how new connection stats are added, along with old
stale states, if I assume stats collector process is having issues , or the
stats folder is corrupt etc.
That would also mean, all table stats would be off or not updated too?
Is that so? Or analyse works fine on tables without a restart?

On Wed, Jul 21, 2021, 6:27 PM Vijaykumar Jain <
vijaykumarjain(dot)github(at)gmail(dot)com> wrote:

>
>
>
>> Is there a way to avoid this (without restarting the service after every
>> reboot). Is this a bug or a normal behavior?
>>
>
>
> I have less knowledge of windows.
> https://www.enterprisedb.com/blog/postgresql-shutdown
>
>
>
> Do you see shutdown/termination messages in the db logs or windows event
> logs when the machine is rebooted?
>
> You get the same pid and query, does it also has the same age( time since
> it started),
> I mean is the stats table updated with new data for stale connections or
> they remain static.
>
> Do you see the same issue when the machine is power cycled.
>
> Maybe windows might be preserving the memory state on disk and reading it
> back on reboot (like sleep) unless there are instructions to shutdown the
> db server on reboot. Idk.
>
> What are the state of the connections in pg_stat_activity abd process
> explorer before and after reboot. The sockets exists and active, or are
> residual in pg stats only.
>
>
>