Skip site navigation (1) Skip section navigation (2)

Re: pg_stats not getting updated....

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Himanshu Baweja <himanshubaweja(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_stats not getting updated....
Date: 2005-06-03 14:34:08
Message-ID: 4827.1117809248@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Himanshu Baweja <himanshubaweja(at)yahoo(dot)com> writes:
> "SELECT pg_stat_get_db_blocks_fetched(764755937),
> pg_stat_get_db_blocks_hit(764755937);"
> gives be constantly increasing stats and

> "SELECT relname,heap_blks_read from
> pg_statio_user_tables order by heap_blks_read DESC
> LIMIT 15;"

> is still showing me all zero 4 mins into the test
> until i first vacuum analyze is done....

Um, looking at the view definition, heap_blks_read is the *difference*
between blocks_fetched and blocks_hit ... is it possible your test is
testing a 100%-cached situation, such that those two numbers increase
in lockstep?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Gevik BabakhaniDate: 2005-06-03 15:57:32
Subject: Re: PostgreSQL Developer Network
Previous:From: Himanshu BawejaDate: 2005-06-03 14:21:45
Subject: Re: pg_stats not getting updated....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group