From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Identifying "cold" data
Date: Thu, 24 Feb 2022 20:48:32 -0600
Message-ID: <9f1103cf-6073-4552-fb0e-84862bb226c3@gmail.com> (raw)
In-Reply-To: <CAHs7QM87xwc=h6+p-WpBEvbbJKF8wp2a7NgP-0Qv3W-bgbRhnw@mail.gmail.com>
References: <CAHs7QM87xwc=h6+p-WpBEvbbJKF8wp2a7NgP-0Qv3W-bgbRhnw@mail.gmail.com>
On 2/24/22 12:37 PM, Joseph Hammerman wrote:
> Hi postgresql-admins,
>
> Has anyone put any thought or effort into figuring out how to measure the
> total volume of data in a database against *how much of it is hot*? I'm
> looking for some automatable approaches. Similarly, is there a way to
> measure rarely queried columns, or unused functions & triggers?
https://www.postgresql.org/docs/9.6/monitoring-stats.html
pg_stat_user_tables tells you how many records have been inserted, updated
and deleted since the instance was started. It does not, though, say *which*
records were updated,
--
Angular momentum makes the world go 'round.
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-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Identifying "cold" data
In-Reply-To: <9f1103cf-6073-4552-fb0e-84862bb226c3@gmail.com>
* 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