X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F09E4D1E14B for ; Fri, 20 Feb 2004 02:34:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 09745-05 for ; Thu, 19 Feb 2004 22:34:16 -0400 (AST) Received: from srv02.shieldhost.com (srv02.shieldhost.com [66.98.168.13]) by svr1.postgresql.org (Postfix) with ESMTP id 724D3D1D1A4 for ; Thu, 19 Feb 2004 22:34:08 -0400 (AST) Received: from DellLaptopDG (adsl-67-123-247-142.dsl.pltn13.pacbell.net [67.123.247.142]) (authenticated (0 bits)) by srv02.shieldhost.com (8.11.6/8.11.6) with ESMTP id i1K3Zdm04243 for ; Thu, 19 Feb 2004 21:35:39 -0600 From: "David B" To: Subject: Row counts/data changes. Any catalog table that has this info? Date: Thu, 19 Feb 2004 18:35:43 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/297 X-Sequence-Number: 16987 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