Re: to find table stats for last update time.

Поиск
Список
Период
Сортировка
От Shabala Deshpande
Тема Re: to find table stats for last update time.
Дата
Msg-id 16b7e2641001050137u691691e1yfb4249c7d352d931@mail.gmail.com
обсуждение исходный текст
Ответ на Re: to find table stats for last update time.  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Ответы Re: to find table stats for last update time.  (Greg Stark <gsstark@mit.edu>)
Список pgsql-novice
Дерево обсуждения
Thanks Andreas.

I was trying to figure out if i could use any system tables info... but seems i have to take the tiggers way out...

Thanks and Regards,

Shabala Deshpande.

On Tue, Jan 5, 2010 at 3:03 PM, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
In response to Shabala Deshpande :
> Hi All,
>
> Is there any way to find out the most recent update time for a table in
> postgres like the mysql equivalent :


No.


>
> I need to figure out the way to check whether the table is active insertions/
> updates in last 15 mins?
>
> Any way out??

Write a TRIGGER for INSERT and UPDATE and store the timestamp in an extra table.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: to find table stats for last update time.
Следующее
От: Intengu Technologies
Дата:
Сообщение: Re: Help to dump tables in a database and restore in another database