Re: [SQL] Row counts/data changes. Any catalog table that has this info? - Mailing list pgsql-novice

From daq
Subject Re: [SQL] Row counts/data changes. Any catalog table that has this info?
Date
Msg-id 121164827738.20040220084449@ugyvitelszolgaltato.hu
Whole thread Raw
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql hangs after "drop table ..."
Next
From: Bruno LEVEQUE
Date:
Subject: Re: commenting sql code