inpricise checkpoint stats

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: inpricise checkpoint stats
Date: 2006-03-22 06:35:06
Message-ID: dvqrd5$1qs9$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

test=# set log_statement_stats = on;
SET
test=# checkpoint;
LOG: QUERY STATISTICS
DETAIL: ! system usage stats:
! 0.100725 elapsed 0.000000 user 0.000000 system sec
! [0.000000 user 0.001999 sys total]
! 0/0 [0/0] filesystem blocks in/out
! 0/0 [0/319] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 1/1 [8/6] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer
hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer
hit rate = 0.00%
! Direct blocks: 0 read, 0 written
CHECKPOINT

The problematic line is "0 written" -- this is because we bgwriter is
actually the command exeuctor. So in our process, we got nothing. But maybe
not deserved a fix ...

Regards,
Qingqing

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Kirpa 2006-03-22 12:15:05 BUG #2353: Temporary tables created within trigger function still exist after abend
Previous Message Marinos Yannikos 2006-03-22 04:57:16 Re: BUG #2334: WHERE IN (SUBSELECT) fails when column is null