Re: to find table stats for last update time.

Поиск
Список
Период
Сортировка
От sivajankan
Тема Re: to find table stats for last update time.
Дата
Msg-id 1310395649717-4575271.post@n5.nabble.com
обсуждение исходный текст
Ответ на to find table stats for last update time.  (Shabala Deshpande <de.shabala@gmail.com>)
Список 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.

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

Предыдущее
От: JORGE MALDONADO
Дата:
Сообщение: pgpass.cong file becomes empty
Следующее
От: Roy's Email
Дата:
Сообщение: Creating DB programmatically?