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
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 |