Re: Findout long unused tables in database - Mailing list pgsql-general

From Andreas Fröde
Subject Re: Findout long unused tables in database
Date
Msg-id c2b95b94-94cd-64bb-9acb-cf7236fda67a@spider-net.de
Whole thread Raw
In response to Re: Findout long unused tables in database  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List 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



pgsql-general by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Limiting the operations that client-side code can perform upon its database backend's artifacts
Next
From: Stephen Frost
Date:
Subject: Re: pgbackrest Help Required