Reset date for Cumulative Statistics System when not in table

From: blockdump <blockdump13(at)gmail(dot)com>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Reset date for Cumulative Statistics System when not in table
Date: 2024-02-26 13:47:38
Message-ID: CAJzQbyUCuUNxF8Sv4W5ngtMjWBBfK6dipCgLRLNxQoBhDEu1jQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Laurenz Albe 2024-02-26 15:40:53 Re: Reset date for Cumulative Statistics System when not in table
Previous Message GERALD CHEVES 2024-02-11 23:01:56 Re: ER diagram tools?