Re: Date range for pg_stat_all_tables?

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Date range for pg_stat_all_tables?
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C208AF06AF@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Date range for pg_stat_all_tables?  (Ronit Allen <ronit.allen@gmail.com>)
Ответы Re: Date range for pg_stat_all_tables?  (Ronit Allen <ronit.allen@gmail.com>)
Список pgsql-admin
Ronit Allen wrote:
> 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.

If you want that, you will have to take regular snapshots
of the table (e.g. with a cron job).
Then you can calculate differences.

Yours,
Laurenz Albe


В списке pgsql-admin по дате отправления:

Предыдущее
От: Ronit Allen
Дата:
Сообщение: Date range for pg_stat_all_tables?
Следующее
От: Aaron Bono
Дата:
Сообщение: Postgre Eating Up Too Much RAM