Hi Tomas, restart the statistics and take 24-hour samples to see if you can
help me
24 gb server memory 6 gb sharred buffers
# select now,
# pg_size_pretty(buffers_checkpoint*8192)AS buffers_checkpoint,
# pg_size_pretty(buffers_clean*8192)AS buffers_clean,
# pg_size_pretty(buffers_backend*8192)AS buffers_backend,
#
(buffers_checkpoint*100)/(buffers_checkpoint+buffers_clean+buffers_backend)AS
buffers_checkpoint_pct,
# (buffers_clean*100)/(buffers_checkpoint+buffers_clean+buffers_backend)AS
buffers_clean_pct,
# (buffers_backend*100)/(buffers_checkpoint+buffers_clean+buffers_backend)AS
buffers_backend_pct,
# pg_size_pretty(buffers_checkpoint * 8192 /(checkpoints_timed +
checkpoints_req)) AS avg_checkpoint_write,
# pg_size_pretty(8192 *(buffers_checkpoint + buffers_clean +
buffers_backend)) AS total_write
# from pg_stat_bgwriter_snapshot
# ;
now | buffers_checkpoint | buffers_clean |
buffers_backend | buffers_checkpoint_pct | buffers_clean_pct |
buffers_backend_pct | avg_checkpoint_write | total_write
---++---+-++---+-+--+-
2019-10-15 15:00:02.070105-03 | 33 MB | 1190 MB | 144 MB
| 2 |87 | 10 | 33 MB
| 1367 MB
2019-10-15 16:00:01.477785-03 | 109 MB | 3543 MB | 393 MB
| 2 |87 | 9 | 36 MB
| 4045 MB
2019-10-15 17:00:01.960162-03 | 179 MB | 6031 MB | 703 MB
| 2 |87 | 10 | 36 MB
| 6913 MB
2019-10-15 18:00:01.558404-03 | 252 MB | 8363 MB | 1000
MB | 2 |86 |
10 | 36 MB| 9615 MB
2019-10-15 19:00:01.170866-03 | 327 MB | 10019 MB | 1232
MB | 2 |86 |
10 | 36 MB| 11 GB
2019-10-15 20:00:01.397473-03 | 417 MB | 11 GB | 1407
MB | 3 |85 |
10 | 38 MB| 13 GB
2019-10-15 21:00:01.211047-03 | 522 MB | 12 GB | 1528
MB | 3 |85 |
11 | 40 MB| 14 GB
2019-10-15 22:00:01.164853-03 | 658 MB | 12 GB | 1691
MB | 4 |83 |
11 | 44 MB| 14 GB
2019-10-15 23:00:01.116564-03 | 782 MB | 13 GB | 1797
MB | 5 |83 |
11 | 46 MB| 15 GB
2019-10-16 00:00:01.19203-03 | 887 MB | 13 GB | 2016
MB | 5 |82 |
12 | 47 MB| 16 GB
2019-10-16 01:00:01.329851-03 | 1003 MB| 14 GB | 2104
MB | 5 |81 |
12 | 48 MB| 17 GB
2019-10-16 02:00:01.518606-03 | 1114 MB| 14 GB |
MB | 6 |81 |
12 | 48 MB| 17 GB
2019-10-16 03:00:01.673498-03 | 1227 MB| 14 GB | 2314
MB | 6 |80 |
12 | 49 MB| 18 GB
2019-10-16 04:00:01.936604-03 | 1354 MB| 15 GB | 2468
MB | 7 |79 |
12 | 50 MB| 19 GB
2019-10-16 05:00:01.854888-03 | 1465 MB| 15 GB | 2518
MB | 7 |79 |
13 | 51 MB| 19 GB
2019-10-16 06:00:01.804182-03 | 1585 MB| 15 GB | 2581
MB | 8 |78 |
13 | 51 MB| 19 GB
2019-10-16 07:00:01.889345-03 | 1677 MB| 15 GB | 2649
MB | 8 |78 |
13 | 51 MB| 20 GB
2019-10-16 08:00:01.248247-03 | 1756 MB| 16 GB | 2707
MB | 8 |78 |
13 | 50 MB| 20 GB
2019-10-16 09:00:01.258408-03 | 1826 MB| 16 GB | 2763
MB | 8 |78 |
13 | 49 MB| 21 GB
2019-10-16 10:00:01.418323-03 | 1881 MB| 17 GB | 2872
MB | 8 |78 |
13 | 48 MB| 21 GB
2019-10-16 11:00:02.077084-03 | 1951 MB| 18 GB |
