pg_class : reltuples
Sandeep Joshi <sjoshi@zambeel.com>
From: Sandeep Joshi <sjoshi@Zambeel.com>
To: pgsql-general@postgresql.org
Date: 2000-11-22T20:05:16Z
Lists: pgsql-general
What does "reltuples" from pg_class represent? any comments Here is something that raised this question: --------------------------------------- testdb=# select count(*) from zuser3; count --------- 1000000 (1 row) testdb=# select count(*) from zuser2; count -------- 100000 (1 row) testdb=# select count(*) from zuser1; count ------- 1000select relname,relpages,reltuples from pg_class where relname like 'zuse%'; relname | relpages | reltuples ---------+----------+----------- zuser2 | 10 | 1000 zuser1 | 10 | 1000 zuser3 | 10 | 1000 (3 rows) (1 row)