From: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
To: RECHTÉ Marc <marc.rechte@meteo.fr>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Inconsitancies in pg_stat_bgwriter and pg_stat_database returned values
Date: Wed, 16 Sep 2020 17:31:24 +0200
Message-ID: <20200916173124.297baa41@firost> (raw)
In-Reply-To: <721986302.8509039.1600268805471.JavaMail.zimbra@meteo.fr>
References: <721986302.8509039.1600268805471.JavaMail.zimbra@meteo.fr>
On Wed, 16 Sep 2020 17:06:45 +0200 (CEST)
RECHTÉ Marc <marc.rechte@meteo.fr> wrote:
> Hello,
>
> On one particular PG12.3 instance (same behaviour with PG12.4) we are
> experimenting occasional strange values in the above tables.
>
> For instance looping (10s. period) over this request:
>
> SELECT current_timestamp, checkpoints_timed,
> checkpoints_req,
> checkpoint_write_time,
> checkpoint_sync_time,
> buffers_checkpoint,
> buffers_clean,
> maxwritten_clean,
> buffers_backend,
> buffers_backend_fsync,
> buffers_alloc
> FROM pg_stat_bgwriter
>
> Gives: [...]
>
> One can see that some columns that are supposed to increase only are not
> always. For instance checkpoints_timed suddenly jumps from 438 to 3291, then
> back to 438.
>
> We experiment the same issue in pg_stat_database.
The full row are different in your example, not just a few fields. It looks
like mixed values from different instance.
Could you share some more informations about the context and how to reproduce
it?
Regards,
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: jgdr@dalibo.com, marc.rechte@meteo.fr, pgsql-bugs@lists.postgresql.org
Subject: Re: Inconsitancies in pg_stat_bgwriter and pg_stat_database returned values
In-Reply-To: <20200916173124.297baa41@firost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox