Skip site navigation (1) Skip section navigation (2)

Re: to find table stats for last update time.

From: Shabala Deshpande <de(dot)shabala(at)gmail(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: to find table stats for last update time.
Date: 2010-01-05 09:37:18
Message-ID: 16b7e2641001050137u691691e1yfb4249c7d352d931@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(dot)kretschmer(at)schollglas(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

In response to

Responses

pgsql-novice by date

Next:From: Intengu TechnologiesDate: 2010-01-05 10:42:34
Subject: Re: Help to dump tables in a database and restore in another database
Previous:From: A. KretschmerDate: 2010-01-05 09:33:41
Subject: Re: to find table stats for last update time.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group