Hi,

Shridhar Daithankar wrote:


select relpages,reltuples from pg_class where relname=<tablename>;


Assuming the stats are recent enough, it would be much faster and accurate..

this needs an analyze <tablename>; before select from pg_class, cause only after analyze will update pg the pg_class


C.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to