Re: Table Stats

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: Jeff Davidson <jeff(at)panopticpix(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table Stats
Date: 2003-08-01 04:23:51
Message-ID: 3F29EB57.40800@cvc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Jeff Davidson wrote:

> Hi!
>
> Is there any quick way to determine how many rows exist in a given table?
>
> Thanks!
> ---------------------------------------------
> Jeff Davidson
> Panoptic Pictures
> 6888 Alta Loma Terrace
> Los Angeles, CA 90068
> (310) 395-9300
> (310) 395-9116 fax
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

In response to

  • Table Stats at 2003-07-27 17:08:16 from Jeff Davidson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tambet Matiisen 2003-08-01 07:45:54 COPY and domains
Previous Message Rajesh Kumar Mallah 2003-08-01 04:02:30 Re: COPY command