On Thu, Oct 28, 2010 at 11:36 AM, Ozz Nixon <ozzni...@gmail.com> wrote: > How/where do I query this? > > My script does not need a 100% accurate count - just a recently valid count - > so I can verify the web crawlers are still crawling :-)
you can do this: select reltuples from pg_class where relname = 'your_table' and relkind = 'r'; that will give you accurate count as of the last analyze, which is going to be driven by table usage and/or manual analyze. Probably much better in your particular case is to do this: select * from pg_stat_all_tables where relname = 'your_table'; and look at the n_tup_ins, del, etc. and make sure they are changing (those numbers are reset when server resets, fyi). merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
