Re: No stats visible?

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Steve Lane <slane(at)moyergroup(dot)com>
Cc: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: No stats visible?
Date: 2003-03-04 20:02:04
Message-ID: m31y1mq4sj.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Steve Lane <slane(at)moyergroup(dot)com> writes:

> Hello all:
>
> I've been looking at Postgres' statistics tables to try to get some sense of
> why my database server seems to be running slowly. Oddly, the stats tables
> seem to be recording no activity! pg_stat_get_tuples_inserted on one of my
> main tables says no tuples have been inserted. I also get lots of zeroes for
> all the main numbers on most of the other tables.

Are you running ANALYZE regularly? Are you VACUUMing?

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Kriger 2003-03-04 20:06:12 administering connections to a database?
Previous Message Doug McNaught 2003-03-04 20:01:03 Re: two concurrency questions