I've just run pgBadger on my pg logs and wonder if those checkpoint
statistics is something I should worry about or not?
The highest write time is about 47 minutes but I'm not sure if that's
checkpoint_completion_target*checkpoint_target value or real time between
sending the command to write and getting response?
If that's the first one - then I assume everything is ok because:checkpoint_timeout = 8mincheckpoint_completion_target
=0.9
but I'm not sure which value it is...
Hour Written buffers Write time Sync time Total time
00 104,622 2,510.379s 0.558s 2,511.144s
01 23,549 2,218.747s 0.298s 2,219.199s
02 9,776 919.796s 0.244s 920.281s
03 1,075 107.07s 0.398s 107.667s
04 1,062 105.853s 0.396s 106.384s
05 16,216 1,609.462s 0.576s 1,610.245s
06 38,315 2,137.492s 0.246s 2,137.879s
07 51,504 2,571.057s 0.48s 2,571.7s
08 53,921 2,295.652s 2.071s 2,297.957s
09 18,716 1,116.161s 3.132s 1,119.715s
10 9,000 581.912s 3.866s 586.109s
11 12,795 879.337s 2.427s 882.124s
12 13,872 860.987s 1.127s 862.444s
13 14,883 805.011s 0.866s 806.119s
14 13,172 1,062.677s 1.228s 1,064.188s
15 9,375 620.979s 1.013s 622.632s
16 6,268 626.158s 1.059s 627.721s
17 12,387 613.113s 4.849s 618.534s
18 40,641 1,791.432s 1.571s 1,793.546s
19 38,316 1,946.747s 1.343s 1,948.442s
20 69,564 2,817.917s 1.268s 2,819.678s
21 17,333 1,736.004s 0.812s 1,737.25s
22 9,230 924.742s 0.576s 925.49s
23 118,037 2,150.212s 2.167s 2,152.673s
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general