Re: Findout long unused tables in database

From: Andreas Fröde <andreas(at)spider-net(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Findout long unused tables in database
Date: 2022-09-27 12:12:08
Message-ID: c2b95b94-94cd-64bb-9acb-cf7236fda67a@spider-net.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Andreas,

> no really what you are looking for, i know, but we have
> pg_stat_user_tables. There can you find how often the table was queried
> in the past. Take the data, wait some time, take it again and compare.

Thanks for this idea. i will try it out.

Andreas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2022-09-27 15:39:36 Re: pgbackrest Help Required
Previous Message Julien Rouhaud 2022-09-27 06:58:58 Re: Limiting the operations that client-side code can perform upon its database backend's artifacts