Row counts/data changes. Any catalog table that has this info?

Поиск
Список
Период
Сортировка
От David B
Тема Row counts/data changes. Any catalog table that has this info?
Дата
Msg-id GOEGKICPFOPNLIEIHGFJEEOPCHAA.postgresql@thegatelys.com
обсуждение исходный текст
Ответы Re: Row counts/data changes. Any catalog table that has this info?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-sql
Folks,

Is there a catalog table or location where I can go to find data counts for
tables?

It would be nice if I could do a query which returned something like:

table_name    #Rows
cust          1000
order         5000
order_detail  9500

without having to have the overhead of querying each table in turn.

If there is such a source then is it accurate as of now or last vacuum or
???

On a related note...any location where I can see the most recent date a
table was changed (insert/update/delete).


Tx in advance...
D
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.574 / Virus Database: 364 - Release Date: 1/29/2004



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

Предыдущее
От: "Yudie"
Дата:
Сообщение: Re: Help refining/eliminating recursive selects
Следующее
От: "2000info"
Дата:
Сообщение: pg_restore - don´t restore. Why?