| From: | "David B" <postgresql(at)thegatelys(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Row counts/data changes. Any catalog table that has this info? |
| Date: | 2004-02-20 02:35:43 |
| Message-ID: | GOEGKICPFOPNLIEIHGFJEEOPCHAA.postgresql@thegatelys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JWDougherty | 2004-02-20 03:07:10 | pg_hba.conf problem |
| Previous Message | joseph speigle | 2004-02-20 01:17:24 | outputting commands to spool |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 2000info | 2004-02-20 03:24:46 | pg_restore - don´t restore. Why? |
| Previous Message | Yudie | 2004-02-20 00:16:31 | Re: Help refining/eliminating recursive selects |