MIME-Version: 1.0
From: blockdump <blockdump13@gmail.com>
Date: Mon, 26 Feb 2024 14:47:38 +0100
Message-ID: 
 <CAJzQbyUCuUNxF8Sv4W5ngtMjWBBfK6dipCgLRLNxQoBhDEu1jQ@mail.gmail.com>
Subject: Reset date for Cumulative Statistics System when not in table
To: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000c821ee0612492735"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJzQbyUCuUNxF8Sv4W5ngtMjWBBfK6dipCgLRLNxQoBhDEu1jQ%40mail.gmail.com>
Precedence: bulk

--000000000000c821ee0612492735
Content-Type: text/plain; charset="UTF-8"

Hello,
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.

cheers
Guenter

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

<div dir=3D"ltr">Hello,=C2=A0<div>I am new to Postgres and started reading =
about the=C2=A0The Cumulative Statistics System.=C2=A0</div><div><a href=3D=
"https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-P=
G-STATIO-ALL-TABLES-VIEW">https://www.postgresql.org/docs/current/monitorin=
g-stats.html#MONITORING-PG-STATIO-ALL-TABLES-VIEW</a></div><div><br></div><=
div>When I came across pg_statio_all_tables I was wondering what is the ref=
erence date for the counters like (heap_blks_read,=C2=A0heap_blks_hit ... )=
 This table does not have a=C2=A0stats_reset column like others.=C2=A0<code=
 class=3D"gmail-structfield" style=3D"box-sizing:border-box;font-family:mon=
ospace,monospace;font-size:14.4px;color:rgb(243,245,249);background-color:r=
gb(33,33,33);border-radius:0.25rem;margin:0px;padding:0px;word-break:unset"=
></code></div><div>So are this numbers accumulating from the creation of th=
e table or since the startup of the cluster=C2=A0?</div><div><br></div><div=
>Maybe someone can drop me a line.</div><div><br></div><div>cheers</div><di=
v>Guenter=C2=A0</div></div>

--000000000000c821ee0612492735--