Date range for pg_stat_all_tables?

From: Ronit Allen <ronit(dot)allen(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Date range for pg_stat_all_tables?
Date: 2012-11-12 22:54:17
Message-ID: CABP1cDPa-vMU-4rVGEE-MZs1zK8rSMujdTn6F=GgtDkvgJxv9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi -

I have the following query on pg_stat_all_tables to look at updates,
inserts, and deletes:

SELECT relname, n_tup_ins, n_tup_upd, n_tup_del FROM pg_stat_all_tables;

How can I add a date range to the WHERE clause to show data from a
specified date range?

I don't see anything in the table or in possible joins that will provide
dates.

Thanks for any assistance that can be provided.

Ronit

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2012-11-13 08:54:26 Re: Date range for pg_stat_all_tables?
Previous Message Craig Ringer 2012-11-11 10:15:39 Re: No databases visible on pg 8.3 server