Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created June 3, 2024 20:18
Show Gist options
  • Save mdcallag/cc891b4cd1ad1cbdd376d8d422012c84 to your computer and use it in GitHub Desktop.
Save mdcallag/cc891b4cd1ad1cbdd376d8d422012c84 to your computer and use it in GitHub Desktop.
2024-06-02 11:07:38.612 UTC [1340363] LOG: checkpoint starting: immediate force wait
2024-06-02 11:07:38.908 UTC [1340363] LOG: checkpoint complete: wrote 1888 buffers (0.1%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.076 s, sync=0.197 s, total=0.296 s; sync files=621, longest=0.009 s, average=0.001 s; distance=12784 kB, estimate=12784 kB; lsn=0/23A6338, redo lsn=0/23A6300
2024-06-02 11:37:39.041 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 12:04:45.933 UTC [1340363] LOG: checkpoint complete: wrote 1249077 buffers (41.4%); 0 WAL file(s) added, 0 removed, 1308 recycled; write=1620.047 s, sync=0.123 s, total=1626.893 s; sync files=345, longest=0.008 s, average=0.001 s; distance=21429735 kB, estimate=21429735 kB; lsn=7/9BEA7FE0, redo lsn=5/1E320298
2024-06-02 12:07:39.938 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 12:34:42.719 UTC [1340363] LOG: checkpoint complete: wrote 1008384 buffers (33.4%); 0 WAL file(s) added, 0 removed, 711 recycled; write=1619.076 s, sync=0.032 s, total=1622.782 s; sync files=22, longest=0.008 s, average=0.002 s; distance=11651454 kB, estimate=20451907 kB; lsn=8/4BF8EC58, redo lsn=7/E557FE38
2024-06-02 12:37:39.817 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 13:04:39.667 UTC [1340363] LOG: checkpoint complete: wrote 573917 buffers (19.0%); 0 WAL file(s) added, 0 removed, 107 recycled; write=1619.246 s, sync=0.027 s, total=1619.850 s; sync files=21, longest=0.007 s, average=0.002 s; distance=1759948 kB, estimate=18582711 kB; lsn=8/9EEFAD40, redo lsn=8/50C330D0
2024-06-02 13:07:39.765 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 13:34:39.510 UTC [1340363] LOG: checkpoint complete: wrote 592322 buffers (19.6%); 0 WAL file(s) added, 0 removed, 83 recycled; write=1619.246 s, sync=0.031 s, total=1619.745 s; sync files=22, longest=0.007 s, average=0.002 s; distance=1357223 kB, estimate=16860163 kB; lsn=8/F04C78D0, redo lsn=8/A399CE00
2024-06-02 13:37:39.609 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 14:04:39.621 UTC [1340363] LOG: checkpoint complete: wrote 641498 buffers (21.3%); 0 WAL file(s) added, 0 removed, 97 recycled; write=1619.454 s, sync=0.030 s, total=1620.012 s; sync files=21, longest=0.007 s, average=0.002 s; distance=1581900 kB, estimate=15332336 kB; lsn=9/41769978, redo lsn=9/4270180
2024-06-02 14:07:39.717 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 14:08:04.767 UTC [1340363] LOG: checkpoint complete: wrote 631060 buffers (20.9%); 0 WAL file(s) added, 75 removed, 0 recycled; write=24.061 s, sync=0.024 s, total=25.050 s; sync files=22, longest=0.007 s, average=0.002 s; distance=1228555 kB, estimate=13921958 kB; lsn=9/53DB68E8, redo lsn=9/4F232E20
2024-06-02 14:08:04.767 UTC [1340363] LOG: checkpoint starting: immediate force wait
2024-06-02 14:08:04.918 UTC [1340363] LOG: checkpoint complete: wrote 4657 buffers (0.2%); 0 WAL file(s) added, 4 removed, 0 recycled; write=0.068 s, sync=0.023 s, total=0.151 s; sync files=15, longest=0.007 s, average=0.002 s; distance=77326 kB, estimate=12537495 kB; lsn=9/53DB6998, redo lsn=9/53DB6960
2024-06-02 14:38:05.017 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 15:05:05.165 UTC [1340363] LOG: checkpoint complete: wrote 255417 buffers (8.5%); 0 WAL file(s) added, 5 removed, 0 recycled; write=1620.063 s, sync=0.012 s, total=1620.148 s; sync files=20, longest=0.006 s, average=0.001 s; distance=81641 kB, estimate=11291910 kB; lsn=9/5D9644A8, redo lsn=9/58D710D0
2024-06-02 15:08:05.261 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 15:35:05.164 UTC [1340363] LOG: checkpoint complete: wrote 219058 buffers (7.3%); 0 WAL file(s) added, 6 removed, 0 recycled; write=1619.806 s, sync=0.012 s, total=1619.904 s; sync files=19, longest=0.006 s, average=0.001 s; distance=86355 kB, estimate=10171354 kB; lsn=9/62DD2ED0, redo lsn=9/5E1C5CD8
2024-06-02 15:38:05.265 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 16:05:05.085 UTC [1340363] LOG: checkpoint complete: wrote 227455 buffers (7.5%); 0 WAL file(s) added, 5 removed, 0 recycled; write=1619.741 s, sync=0.021 s, total=1619.821 s; sync files=19, longest=0.011 s, average=0.002 s; distance=86544 kB, estimate=9162873 kB; lsn=9/6826A490, redo lsn=9/63649D98
2024-06-02 16:08:05.181 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 16:35:05.111 UTC [1340363] LOG: checkpoint complete: wrote 226743 buffers (7.5%); 0 WAL file(s) added, 5 removed, 0 recycled; write=1619.825 s, sync=0.029 s, total=1619.930 s; sync files=19, longest=0.007 s, average=0.002 s; distance=86600 kB, estimate=8255246 kB; lsn=9/7F36C928, redo lsn=9/68ADBFA0
2024-06-02 16:38:05.211 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 17:05:05.336 UTC [1340363] LOG: checkpoint complete: wrote 509669 buffers (16.9%); 0 WAL file(s) added, 25 removed, 0 recycled; write=1619.786 s, sync=0.030 s, total=1620.126 s; sync files=19, longest=0.007 s, average=0.002 s; distance=412916 kB, estimate=7471013 kB; lsn=9/9A2E3180, redo lsn=9/81E19268
2024-06-02 17:08:05.436 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 17:35:05.448 UTC [1340363] LOG: checkpoint complete: wrote 467173 buffers (15.5%); 0 WAL file(s) added, 27 removed, 0 recycled; write=1619.648 s, sync=0.012 s, total=1620.012 s; sync files=20, longest=0.005 s, average=0.001 s; distance=443243 kB, estimate=6768236 kB; lsn=9/B8EC17A0, redo lsn=9/9CEF4058
2024-06-02 17:38:05.545 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 18:05:05.485 UTC [1340363] LOG: checkpoint complete: wrote 529362 buffers (17.6%); 0 WAL file(s) added, 31 removed, 0 recycled; write=1619.512 s, sync=0.033 s, total=1619.940 s; sync files=22, longest=0.007 s, average=0.002 s; distance=501810 kB, estimate=6141593 kB; lsn=9/D371D590, redo lsn=9/BB900B08
2024-06-02 18:08:05.581 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 18:35:05.301 UTC [1340363] LOG: checkpoint complete: wrote 458470 buffers (15.2%); 0 WAL file(s) added, 27 removed, 0 recycled; write=1619.422 s, sync=0.018 s, total=1619.721 s; sync files=20, longest=0.006 s, average=0.001 s; distance=435061 kB, estimate=5570940 kB; lsn=A/8CB0038, redo lsn=9/D61DE148
2024-06-02 18:38:05.401 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 19:05:05.752 UTC [1340363] LOG: checkpoint complete: wrote 618198 buffers (20.5%); 0 WAL file(s) added, 56 removed, 0 recycled; write=1619.631 s, sync=0.015 s, total=1620.351 s; sync files=23, longest=0.005 s, average=0.001 s; distance=916935 kB, estimate=5105539 kB; lsn=A/42A24F80, redo lsn=A/E14FD98
2024-06-02 19:08:05.801 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 19:35:05.660 UTC [1340363] LOG: checkpoint complete: wrote 637484 buffers (21.1%); 0 WAL file(s) added, 57 removed, 0 recycled; write=1619.195 s, sync=0.031 s, total=1619.859 s; sync files=22, longest=0.007 s, average=0.002 s; distance=948019 kB, estimate=4689787 kB; lsn=A/778913B0, redo lsn=A/47F1CA78
2024-06-02 19:38:05.757 UTC [1340363] LOG: checkpoint starting: time
2024-06-02 20:05:05.627 UTC [1340363] LOG: checkpoint complete: wrote 552946 buffers (18.3%); 0 WAL file(s) added, 53 removed, 0 recycled; write=1619.268 s, sync=0.024 s, total=1619.870 s; sync files=21, longest=0.006 s, average=0.002 s; distance=868675 kB, estimate=4307676 kB; lsn=A/B1200EB0, redo lsn=A/7CF6D6C0
2024-06-02 20:08:05.629 UTC [1340363] LOG: checkpoint starting: time
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment