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

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: (view raw, whole thread or download thread mbox)
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.


View this message in context:
Sent from the PostgreSQL - novice mailing list archive at

In response to

pgsql-novice by date

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

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