Re: [SQL] Row counts/data changes. Any catalog table that has this info?

From: daq <daq(at)ugyvitelszolgaltato(dot)hu>
To: "David B" <postgresql(at)thegatelys(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [SQL] Row counts/data changes. Any catalog table that has this info?
Date: 2004-02-20 07:44:49
Message-ID: 121164827738.20040220084449@ugyvitelszolgaltato.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql


DB> Folks,

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

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

DB> table_name #Rows
DB> cust 1000
DB> order 5000
DB> order_detail 9500

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

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

The pg_class table has a reltuples field but only the vacuum process updates it.

DAQ

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno LEVEQUE 2004-02-20 11:13:23 Re: commenting sql code
Previous Message Tom Lane 2004-02-20 04:30:41 Re: psql hangs after "drop table ..."

Browse pgsql-sql by date

  From Date Subject
Next Message Sumita Biswas 2004-02-20 08:43:55 Re: Function
Previous Message Sumita Biswas 2004-02-20 06:39:18 Re: Function