Re: Table Stats

On 1 Aug 2003 at 9:14, Ron Johnson wrote:

> On Thu, 2003-07-31 at 23:23, Dennis Gearon wrote:
> > It will only be at a given point in time, since datasbases are by
> > design, realtime/concurrent applications.
> >
> > do:
> >
> > SELECT COUNT(*) FROM table_name;
> >
> > Should give you what you want.
>
> It'll give him what he wants, but not quickly, if it's a 10/20/etc
> M row table.
>
> One hack is:
> CREATE TABLE T_CARDINALITY (
> RELATION_NAME CHAR(31) PRIMARY KEY,
> CARDINALITY BIGINT );

How about

select reltuples from pg_class where relname='mytablename';

It is as accurate as your last vacuum..

Bye
Shridhar

--
Strategy: A long-range plan whose merit cannot be evaluated until sometime
after those creating it have left the organization.