Statistical tracking issue

From: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Statistical tracking issue
Date: 2009-07-03 21:23:28
Message-ID: F4E6A2751A2823418A21D4A160B689883FCA5C@fletch.stackdump.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am running 8.3.7 on FreeBSD 7.0/amd64.

It appears that at some point about 2 weeks ago statistics tracking
ceased.

I have the following query which I use to track cache hits, and it is
not being updated:

SELECT pg_stat_database.datname, pg_stat_database.blks_read,
pg_stat_database.blks_hit, round((pg_stat_database.blks_hit::double
precision / (pg_stat_database.blks_read + pg_stat_database.blks_hit +
1)::double precision * 100::double precision)::numeric, 2) AS
cachehitratio

FROM pg_stat_database

WHERE pg_stat_database.datname !~ '^(template(0|1)|postgres)$'::text

ORDER BY round((pg_stat_database.blks_hit::double precision /
(pg_stat_database.blks_read + pg_stat_database.blks_hit + 1)::double
precision * 100::double precision)::numeric, 2) DESC;

blks_hit and blks_read values have not changed.

track_activities and track_counts is on. The result of the query is
shown below, but the values remain static. Same is the case with values
such as

"sessions";1819965;219050729;99.18

"ishield";12291564297;38928261045;76.00

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2009-07-03 21:33:48 Re: Statistical tracking issue
Previous Message Kevin Grittner 2009-07-03 18:35:43 Re: pg_check_queries.pl: an ineffective way to check for slow queries?