From: | Steve Lane <slane(at)moyergroup(dot)com> |
---|---|
To: | PostgreSQL general list <pgsql-general(at)postgresql(dot)org> |
Subject: | No stats visible? |
Date: | 2003-03-03 04:04:41 |
Message-ID: | BA883079.24F3B%slane@moyergroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
The server does get restarted daily but there's definitely been activity
today. Stats logging should be working because I have not changed this in
postgresql.conf and in case I can see the stats-related instances of
postmaster when I look at current processes.
Any ideas?
-- sgl
=======================================================
Steve Lane
Vice President
The Moyer Group
14 North Peoria St Suite 2H
Voice: (312) 433-2421 Email: slane(at)moyergroup(dot)com
Fax: (312) 850-3930 Web: http://www.moyergroup.com
=======================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2003-03-03 04:04:58 | Re: selects possible in VALUES() claueses? |
Previous Message | bob parker | 2003-03-03 03:19:06 | Re: [GENERAL] Was 26 votes - now still need 10 |