Postgres Pro
Downloads
Home   >   mailing lists

Date range for pg_stat_all_tables? - Mailing list pgsql-admin

From Ronit Allen
Subject Date range for pg_stat_all_tables?
Date
Msg-id CABP1cDPa-vMU-4rVGEE-MZs1zK8rSMujdTn6F=GgtDkvgJxv9w@mail.gmail.com
Whole thread Raw
Responses Re: Date range for pg_stat_all_tables?
List pgsql-admin
Tree view
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


pgsql-admin by date:

Previous
From: Craig Ringer
Date:
Subject: Re: No databases visible on pg 8.3 server
Next
From: "Albe Laurenz"
Date:
Subject: Re: Date range for pg_stat_all_tables?