Re: to find table stats for last update time.

From: sivajankan <siva_jankan(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: to find table stats for last update time.
Date: 2011-07-11 14:47:29
Message-ID: 1310395649717-4575271.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I got this help and it worked for me.

1. Find the file node name from the pg_class for your table
select relfilenode from pg_class where relname = 'tablename'

2. Locate the relfilenode file in your system. The last updated system time
of that file node is your last update time of your table.

I hope it works for you.

SIVA JAN KAN

--
View this message in context: http://postgresql.1045698.n5.nabble.com/to-find-table-stats-for-last-update-time-tp2142054p4575271.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Roy's Email 2011-07-11 23:40:04 Creating DB programmatically?
Previous Message JORGE MALDONADO 2011-07-10 18:08:25 pgpass.cong file becomes empty