MIME-Version: 1.0
References: 
 <CAJzQbyUCuUNxF8Sv4W5ngtMjWBBfK6dipCgLRLNxQoBhDEu1jQ@mail.gmail.com>
 <0491db9ee6796afacb53a52c43e9f4905e49a188.camel@cybertec.at>
In-Reply-To: <0491db9ee6796afacb53a52c43e9f4905e49a188.camel@cybertec.at>
From: blockdump <blockdump13@gmail.com>
Date: Mon, 26 Feb 2024 17:52:24 +0100
Message-ID: 
 <CAJzQbyWd+xW4LC5L4kpnpApZc5ssaEvBQ2KDywC-AMfP2r5CMA@mail.gmail.com>
Subject: Re: Reset date for Cumulative Statistics System when not in table
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000778f8006124bbc26"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJzQbyWd%2BxW4LC5L4kpnpApZc5ssaEvBQ2KDywC-AMfP2r5CMA%40mail.gmail.com>
Precedence: bulk

--000000000000778f8006124bbc26
Content-Type: text/plain; charset="UTF-8"

Thank you so much for the info!

On Mon, Feb 26, 2024, 16:40 Laurenz Albe <laurenz.albe@cybertec.at> wrote:

> On Mon, 2024-02-26 at 14:47 +0100, blockdump wrote:
> > I am new to Postgres and started reading about the The Cumulative
> Statistics System.
> >
> https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STATIO-ALL-TABLES-VIEW
> >
> > When I came across pg_statio_all_tables I was wondering what is the
> reference date for the
> > counters like (heap_blks_read, heap_blks_hit ... ) This table does not
> have a stats_reset column like others.
> > So are this numbers accumulating from the creation of the table or since
> the startup of the cluster ?
> >
> > Maybe someone can drop me a line.
>
> Statistics survive a restart, but not a crash, so the statistics are
> collected since the table was created, the latest crash happened or the
> statistics were reset; whatever happened last.
>
> Unfurtunately there is no way to find out the time when that happened.
>
> Yours,
> Laurenz Albe
>

--000000000000778f8006124bbc26
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Thank you so much for the info!=C2=A0</div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Feb 26, 2024=
, 16:40 Laurenz Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec.at">lauren=
z.albe@cybertec.at</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote=
" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">O=
n Mon, 2024-02-26 at 14:47 +0100, blockdump wrote:<br>
&gt; I am new to Postgres and started reading about the=C2=A0The Cumulative=
 Statistics System.=C2=A0<br>
&gt; <a href=3D"https://www.postgresql.org/docs/current/monitoring-stats.ht=
ml#MONITORING-PG-STATIO-ALL-TABLES-VIEW" rel=3D"noreferrer noreferrer" targ=
et=3D"_blank">https://www.postgresql.org/docs/current/monitoring-stats.html=
#MONITORING-PG-STATIO-ALL-TABLES-VIEW</a><br>
&gt; <br>
&gt; When I came across pg_statio_all_tables I was wondering what is the re=
ference date for the<br>
&gt; counters like (heap_blks_read,=C2=A0heap_blks_hit ... ) This table doe=
s not have a=C2=A0stats_reset column like others.=C2=A0<br>
&gt; So are this numbers accumulating from the creation of the table or sin=
ce the startup of the cluster=C2=A0?<br>
&gt; <br>
&gt; Maybe someone can drop me a line.<br>
<br>
Statistics survive a restart, but not a crash, so the statistics are<br>
collected since the table was created, the latest crash happened or the<br>
statistics were reset; whatever happened last.<br>
<br>
Unfurtunately there is no way to find out the time when that happened.<br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div>

--000000000000778f8006124bbc26--