Re: Help tracking down problem with inserts slowing

Steve Wampler <swampler(at)noao(dot)edu> writes:
> Thanks, Tom. Are there any reasons why it would not appear?:

Oh, I shoulda read the code more carefully. I was looking at the bottom
of lazy_scan_index, where the printout is done, and failed to notice the
test at the top:

/*
* If the index is not partial, skip the scan, and just assume it has
* the same number of tuples as the heap.
*/

So for ordinary indexes, nothing will appear unless vacuum has actual
work to do (that is, it recycled at least one dead tuple in the table).

Short answer: update or delete some row in the table, and then try
vacuum verbose.

Alternatively, you can just look at the pg_class row for the index.
relpages and reltuples will contain the info you are after ... and
they are certainly up to date at this point ;-)

regards, tom lane