Re: Table Stats - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Table Stats
Date
Msg-id 3F29EB57.40800@cvc.net
Whole thread Raw
In response to Table Stats  (Jeff Davidson <jeff@panopticpix.com>)
Responses Re: Table Stats
List 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
>


pgsql-general by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: COPY command
Next
From: Richard Huxton
Date:
Subject: Re: Comments in .sql files