2025-01-31 00:03:06.705 CET [2132] LOG: automatic vacuum of table "sonex.public.customers": index scans: 1 pages: 0 removed, 172652 remain, 172652 scanned (100.00% of total) tuples: 5374829 removed, 3342070 remain, 0 are dead but not yet removable removable cutoff: 30972, which was 4 XIDs old when operation ended frozen: 2 pages from table (0.00% of total) had 80 tuples frozen index scan needed: 112459 pages from table (65.14% of total) had 5382418 dead item identifiers removed index "customers_pkey": pages: 44738 in total, 21610 newly deleted, 21610 currently deleted, 0 reusable index "idx_customers_order_number": pages: 45125 in total, 21997 newly deleted, 21997 currently deleted, 0 reusable index "idx_customers_name": pages: 13461 in total, 1398 newly deleted, 1405 currently deleted, 659 reusable index "idx_customers_city": pages: 10110 in total, 3940 newly deleted, 4409 currently deleted, 469 reusable index "idx_customers_postal_code": pages: 11939 in total, 794 newly deleted, 804 currently deleted, 10 reusable index "idx_customers_street_address": pages: 12135 in total, 2071 newly deleted, 2277 currently deleted, 784 reusable avg read rate: 5.010 MB/s, avg write rate: 4.382 MB/s buffer usage: 693253 hits, 404659 misses, 353951 dirtied WAL usage: 576896 records, 329742 full page images, 516297656 bytes system usage: CPU: user: 0.95 s, system: 0.15 s, elapsed: 630.98 s 2025-01-31 00:03:13.516 CET [3572] LOG: checkpoint complete: wrote 3534 buffers (21.6%); 0 WAL file(s) added, 0 removed, 24 recycled; write=269.152 s, sync=0.046 s, total=269.657 s; sync files=11, longest=0.009 s, average=0.005 s; distance=398317 kB, estimate=538230 kB; lsn=4/CC994138, redo lsn=4/C25C7818 2025-01-31 00:03:43.504 CET [3572] LOG: checkpoint starting: time 2025-01-31 00:04:33.081 CET [3456] ERROR: canceling statement due to user request 2025-01-31 00:04:33.081 CET [3456] STATEMENT: INSERT INTO customers ( ora_rowscn, order_number, customer_name, attention, street_address, city, postal_code, country_code, language_code, invoice_name, invoice_attention, invoice_address, invoice_city, invoice_postal_code, invoice_country_code, currency_code, phone, phone_secondary, fax_number, email_address, contact_person, region_code, delivery_route, route_sequence ) SELECT * FROM temp_customers ON CONFLICT (order_number) DO UPDATE SET ora_rowscn = EXCLUDED.ora_rowscn, customer_name = EXCLUDED.customer_name, attention = EXCLUDED.attention, street_address = EXCLUDED.street_address, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country_code = EXCLUDED.country_code, language_code = EXCLUDED.language_code, invoice_name = EXCLUDED.invoice_name, invoice_attention = EXCLUDED.invoice_attention, invoice_address = EXCLUDED.invoice_address, invoice_city = EXCLUDED.invoice_city, invoice_postal_code = EXCLUDED.invoice_postal_code, invoice_country_code = EXCLUDED.invoice_country_code, currency_code = EXCLUDED.currency_code, phone = EXCLUDED.phone, phone_secondary = EXCLUDED.phone_secondary, fax_number = EXCLUDED.fax_number, email_address = EXCLUDED.email_address, contact_person = EXCLUDED.contact_person, region_code = EXCLUDED.region_code, delivery_route = EXCLUDED.delivery_route, route_sequence = EXCLUDED.route_sequence 2025-01-31 00:06:23.275 CET [3572] LOG: checkpoint complete: wrote 1248 buffers (7.6%); 0 WAL file(s) added, 0 removed, 10 recycled; write=159.237 s, sync=0.305 s, total=159.772 s; sync files=42, longest=0.025 s, average=0.008 s; distance=167853 kB, estimate=501192 kB; lsn=4/EA59BED0, redo lsn=4/CC9B2D88 2025-01-31 00:07:09.695 CET [3572] LOG: checkpoint starting: wal 2025-01-31 00:11:16.304 CET [1632] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-01-31 00:11:16.304 CET [1632] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-01-31 00:11:39.695 CET [3572] LOG: checkpoint complete: wrote 1052 buffers (6.4%); 0 WAL file(s) added, 0 removed, 33 recycled; write=269.299 s, sync=0.114 s, total=270.001 s; sync files=27, longest=0.015 s, average=0.005 s; distance=530962 kB, estimate=530962 kB; lsn=4/F23A2A40, redo lsn=4/ED0377F8 2025-01-31 00:12:09.682 CET [3572] LOG: checkpoint starting: time 2025-01-31 00:16:39.414 CET [3572] LOG: checkpoint complete: wrote 7122 buffers (43.5%); 0 WAL file(s) added, 0 removed, 5 recycled; write=269.348 s, sync=0.240 s, total=269.733 s; sync files=43, longest=0.021 s, average=0.006 s; distance=85421 kB, estimate=486408 kB; lsn=4/F23A63B8, redo lsn=4/F23A2ED8 2025-01-31 00:21:59.529 CET [196] ERROR: canceling statement due to user request 2025-01-31 00:21:59.529 CET [196] STATEMENT: INSERT INTO customers ( ora_rowscn, order_number, customer_name, attention, street_address, city, postal_code, country_code, language_code, invoice_name, invoice_attention, invoice_address, invoice_city, invoice_postal_code, invoice_country_code, currency_code, phone, phone_secondary, fax_number, email_address, contact_person, region_code, delivery_route, route_sequence ) SELECT * FROM temp_customers ON CONFLICT (order_number) DO UPDATE SET ora_rowscn = EXCLUDED.ora_rowscn, customer_name = EXCLUDED.customer_name, attention = EXCLUDED.attention, street_address = EXCLUDED.street_address, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country_code = EXCLUDED.country_code, language_code = EXCLUDED.language_code, invoice_name = EXCLUDED.invoice_name, invoice_attention = EXCLUDED.invoice_attention, invoice_address = EXCLUDED.invoice_address, invoice_city = EXCLUDED.invoice_city, invoice_postal_code = EXCLUDED.invoice_postal_code, invoice_country_code = EXCLUDED.invoice_country_code, currency_code = EXCLUDED.currency_code, phone = EXCLUDED.phone, phone_secondary = EXCLUDED.phone_secondary, fax_number = EXCLUDED.fax_number, email_address = EXCLUDED.email_address, contact_person = EXCLUDED.contact_person, region_code = EXCLUDED.region_code, delivery_route = EXCLUDED.delivery_route, route_sequence = EXCLUDED.route_sequence 2025-01-31 00:22:09.098 CET [3572] LOG: checkpoint starting: time 2025-01-31 00:26:39.515 CET [3572] LOG: checkpoint complete: wrote 9702 buffers (59.2%); 0 WAL file(s) added, 3 removed, 11 recycled; write=269.944 s, sync=0.176 s, total=270.417 s; sync files=41, longest=0.011 s, average=0.005 s; distance=234122 kB, estimate=461179 kB; lsn=5/3684260, redo lsn=5/845948 2025-01-31 00:28:59.277 CET [5304] ERROR: canceling statement due to user request 2025-01-31 00:28:59.277 CET [5304] STATEMENT: INSERT INTO customers ( ora_rowscn, order_number, customer_name, attention, street_address, city, postal_code, country_code, language_code, invoice_name, invoice_attention, invoice_address, invoice_city, invoice_postal_code, invoice_country_code, currency_code, phone, phone_secondary, fax_number, email_address, contact_person, region_code, delivery_route, route_sequence ) SELECT * FROM temp_customers ON CONFLICT (order_number) DO UPDATE SET ora_rowscn = EXCLUDED.ora_rowscn, customer_name = EXCLUDED.customer_name, attention = EXCLUDED.attention, street_address = EXCLUDED.street_address, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country_code = EXCLUDED.country_code, language_code = EXCLUDED.language_code, invoice_name = EXCLUDED.invoice_name, invoice_attention = EXCLUDED.invoice_attention, invoice_address = EXCLUDED.invoice_address, invoice_city = EXCLUDED.invoice_city, invoice_postal_code = EXCLUDED.invoice_postal_code, invoice_country_code = EXCLUDED.invoice_country_code, currency_code = EXCLUDED.currency_code, phone = EXCLUDED.phone, phone_secondary = EXCLUDED.phone_secondary, fax_number = EXCLUDED.fax_number, email_address = EXCLUDED.email_address, contact_person = EXCLUDED.contact_person, region_code = EXCLUDED.region_code, delivery_route = EXCLUDED.delivery_route, route_sequence = EXCLUDED.route_sequence 2025-01-31 00:32:09.786 CET [3572] LOG: checkpoint starting: time 2025-01-31 00:32:56.686 CET [3436] ERROR: canceling statement due to user request 2025-01-31 00:32:56.686 CET [3436] STATEMENT: INSERT INTO customers ( ora_rowscn, order_number, customer_name, attention, street_address, city, postal_code, country_code, language_code, invoice_name, invoice_attention, invoice_address, invoice_city, invoice_postal_code, invoice_country_code, currency_code, phone, phone_secondary, fax_number, email_address, contact_person, region_code, delivery_route, route_sequence ) SELECT * FROM temp_customers ON CONFLICT (order_number) DO UPDATE SET ora_rowscn = EXCLUDED.ora_rowscn, customer_name = EXCLUDED.customer_name, attention = EXCLUDED.attention, street_address = EXCLUDED.street_address, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country_code = EXCLUDED.country_code, language_code = EXCLUDED.language_code, invoice_name = EXCLUDED.invoice_name, invoice_attention = EXCLUDED.invoice_attention, invoice_address = EXCLUDED.invoice_address, invoice_city = EXCLUDED.invoice_city, invoice_postal_code = EXCLUDED.invoice_postal_code, invoice_country_code = EXCLUDED.invoice_country_code, currency_code = EXCLUDED.currency_code, phone = EXCLUDED.phone, phone_secondary = EXCLUDED.phone_secondary, fax_number = EXCLUDED.fax_number, email_address = EXCLUDED.email_address, contact_person = EXCLUDED.contact_person, region_code = EXCLUDED.region_code, delivery_route = EXCLUDED.delivery_route, route_sequence = EXCLUDED.route_sequence 2025-01-31 00:36:39.569 CET [3572] LOG: checkpoint complete: wrote 3197 buffers (19.5%); 0 WAL file(s) added, 1 removed, 21 recycled; write=269.203 s, sync=0.207 s, total=269.783 s; sync files=45, longest=0.007 s, average=0.005 s; distance=364566 kB, estimate=451518 kB; lsn=5/28078928, redo lsn=5/16C4B210 2025-01-31 00:37:09.564 CET [3572] LOG: checkpoint starting: time 2025-01-31 00:38:27.094 CET [4328] ERROR: canceling statement due to user request 2025-01-31 00:38:27.094 CET [4328] STATEMENT: INSERT INTO customers ( ora_rowscn, order_number, customer_name, attention, street_address, city, postal_code, country_code, language_code, invoice_name, invoice_attention, invoice_address, invoice_city, invoice_postal_code, invoice_country_code, currency_code, phone, phone_secondary, fax_number, email_address, contact_person, region_code, delivery_route, route_sequence ) SELECT * FROM temp_customers ON CONFLICT (order_number) DO UPDATE SET ora_rowscn = EXCLUDED.ora_rowscn, customer_name = EXCLUDED.customer_name, attention = EXCLUDED.attention, street_address = EXCLUDED.street_address, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country_code = EXCLUDED.country_code, language_code = EXCLUDED.language_code, invoice_name = EXCLUDED.invoice_name, invoice_attention = EXCLUDED.invoice_attention, invoice_address = EXCLUDED.invoice_address, invoice_city = EXCLUDED.invoice_city, invoice_postal_code = EXCLUDED.invoice_postal_code, invoice_country_code = EXCLUDED.invoice_country_code, currency_code = EXCLUDED.currency_code, phone = EXCLUDED.phone, phone_secondary = EXCLUDED.phone_secondary, fax_number = EXCLUDED.fax_number, email_address = EXCLUDED.email_address, contact_person = EXCLUDED.contact_person, region_code = EXCLUDED.region_code, delivery_route = EXCLUDED.delivery_route, route_sequence = EXCLUDED.route_sequence 2025-01-31 00:40:30.560 CET [3452] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-01-31 00:40:30.560 CET [3452] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-01-31 00:40:33.649 CET [480] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-01-31 00:40:33.649 CET [480] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-01-31 00:41:39.494 CET [3572] LOG: checkpoint complete: wrote 2720 buffers (16.6%); 0 WAL file(s) added, 3 removed, 15 recycled; write=269.470 s, sync=0.156 s, total=269.931 s; sync files=38, longest=0.012 s, average=0.005 s; distance=282807 kB, estimate=434647 kB; lsn=5/39B7DE18, redo lsn=5/28079150 2025-01-31 00:45:03.482 CET [5740] ERROR: canceling statement due to user request 2025-01-31 00:45:03.482 CET [5740] STATEMENT: INSERT INTO customers ( ora_rowscn, order_number, customer_name, attention, street_address, city, postal_code, country_code, language_code, invoice_name, invoice_attention, invoice_address, invoice_city, invoice_postal_code, invoice_country_code, currency_code, phone, phone_secondary, fax_number, email_address, contact_person, region_code, delivery_route, route_sequence ) SELECT * FROM temp_customers ON CONFLICT (order_number) DO UPDATE SET ora_rowscn = EXCLUDED.ora_rowscn, customer_name = EXCLUDED.customer_name, attention = EXCLUDED.attention, street_address = EXCLUDED.street_address, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country_code = EXCLUDED.country_code, language_code = EXCLUDED.language_code, invoice_name = EXCLUDED.invoice_name, invoice_attention = EXCLUDED.invoice_attention, invoice_address = EXCLUDED.invoice_address, invoice_city = EXCLUDED.invoice_city, invoice_postal_code = EXCLUDED.invoice_postal_code, invoice_country_code = EXCLUDED.invoice_country_code, currency_code = EXCLUDED.currency_code, phone = EXCLUDED.phone, phone_secondary = EXCLUDED.phone_secondary, fax_number = EXCLUDED.fax_number, email_address = EXCLUDED.email_address, contact_person = EXCLUDED.contact_person, region_code = EXCLUDED.region_code, delivery_route = EXCLUDED.delivery_route, route_sequence = EXCLUDED.route_sequence 2025-01-31 00:47:09.092 CET [3572] LOG: checkpoint starting: time 2025-01-31 00:51:40.645 CET [3572] LOG: checkpoint complete: wrote 12518 buffers (76.4%); 0 WAL file(s) added, 0 removed, 32 recycled; write=269.914 s, sync=1.062 s, total=271.553 s; sync files=43, longest=0.529 s, average=0.025 s; distance=530619 kB, estimate=530619 kB; lsn=5/5DB67B28, redo lsn=5/486A7ED0 2025-01-31 00:52:01.464 CET [3572] LOG: checkpoint starting: wal 2025-01-31 00:52:52.194 CET [3572] LOG: checkpoint complete: wrote 3261 buffers (19.9%); 0 WAL file(s) added, 0 removed, 33 recycled; write=48.448 s, sync=1.583 s, total=50.730 s; sync files=15, longest=0.750 s, average=0.106 s; distance=536280 kB, estimate=536280 kB; lsn=5/8772EE20, redo lsn=5/6925E1D8 2025-01-31 00:52:56.865 CET [3572] LOG: checkpoint starting: wal 2025-01-31 00:53:54.463 CET [3572] LOG: checkpoint complete: wrote 1816 buffers (11.1%); 0 WAL file(s) added, 0 removed, 33 recycled; write=55.911 s, sync=1.194 s, total=57.599 s; sync files=14, longest=0.541 s, average=0.086 s; distance=539237 kB, estimate=539237 kB; lsn=5/A85993C0, redo lsn=5/8A0F76C8 2025-01-31 00:53:59.551 CET [3572] LOG: checkpoint starting: wal 2025-01-31 00:54:51.404 CET [3572] LOG: checkpoint complete: wrote 3882 buffers (23.7%); 0 WAL file(s) added, 0 removed, 33 recycled; write=49.389 s, sync=1.937 s, total=51.853 s; sync files=14, longest=0.822 s, average=0.139 s; distance=541792 kB, estimate=541792 kB; lsn=5/C96AFDF0, redo lsn=5/AB20F780 2025-01-31 00:54:55.899 CET [3572] LOG: checkpoint starting: wal 2025-01-31 00:55:53.621 CET [3572] LOG: checkpoint complete: wrote 2135 buffers (13.0%); 0 WAL file(s) added, 0 removed, 33 recycled; write=55.894 s, sync=1.402 s, total=57.722 s; sync files=14, longest=0.473 s, average=0.101 s; distance=541517 kB, estimate=541764 kB; lsn=5/EA5F0630, redo lsn=5/CC2E2BB8 2025-01-31 00:55:57.794 CET [3572] LOG: checkpoint starting: wal 2025-01-31 00:56:47.896 CET [3572] LOG: checkpoint complete: wrote 5006 buffers (30.6%); 0 WAL file(s) added, 0 removed, 33 recycled; write=46.952 s, sync=2.453 s, total=50.102 s; sync files=14, longest=1.208 s, average=0.176 s; distance=539346 kB, estimate=541522 kB; lsn=6/B9F45E0, redo lsn=5/ED197460 2025-01-31 00:56:52.407 CET [3572] LOG: checkpoint starting: wal 2025-01-31 00:57:38.261 CET [3572] LOG: checkpoint complete: wrote 3337 buffers (20.4%); 0 WAL file(s) added, 0 removed, 33 recycled; write=43.109 s, sync=2.222 s, total=45.855 s; sync files=14, longest=1.104 s, average=0.159 s; distance=539912 kB, estimate=541361 kB; lsn=6/2CBF9908, redo lsn=6/E0D9498 2025-01-31 00:57:42.223 CET [3572] LOG: checkpoint starting: wal 2025-01-31 01:00:09.968 CET [3572] LOG: checkpoint complete: wrote 3993 buffers (24.4%); 0 WAL file(s) added, 0 removed, 33 recycled; write=147.022 s, sync=0.172 s, total=147.746 s; sync files=15, longest=0.097 s, average=0.012 s; distance=541729 kB, estimate=541729 kB; lsn=6/4B326C90, redo lsn=6/2F1E18B0 2025-01-31 01:02:42.112 CET [3572] LOG: checkpoint starting: time 2025-01-31 01:03:29.452 CET [3572] LOG: checkpoint complete: wrote 3007 buffers (18.4%); 0 WAL file(s) added, 0 removed, 28 recycled; write=43.038 s, sync=3.430 s, total=47.340 s; sync files=28, longest=2.751 s, average=0.123 s; distance=468963 kB, estimate=534452 kB; lsn=6/6C95CA08, redo lsn=6/4BBDA750 2025-01-31 01:03:29.454 CET [3572] LOG: checkpoint starting: wal 2025-01-31 01:06:00.156 CET [3572] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 1 removed, 33 recycled; write=149.920 s, sync=0.139 s, total=150.703 s; sync files=8, longest=0.035 s, average=0.018 s; distance=558105 kB, estimate=558105 kB; lsn=6/8B8893B0, redo lsn=6/6DCE0E78 2025-01-31 01:06:18.938 CET [3572] LOG: checkpoint starting: wal 2025-01-31 01:07:14.165 CET [3572] LOG: checkpoint complete: wrote 2285 buffers (13.9%); 0 WAL file(s) added, 1 removed, 32 recycled; write=50.243 s, sync=4.322 s, total=55.228 s; sync files=45, longest=2.305 s, average=0.097 s; distance=528837 kB, estimate=555178 kB; lsn=6/AD5D4950, redo lsn=6/8E1524C0 2025-01-31 01:07:17.448 CET [3572] LOG: checkpoint starting: wal 2025-01-31 01:08:21.093 CET [3572] LOG: checkpoint complete: wrote 3411 buffers (20.8%); 0 WAL file(s) added, 0 removed, 33 recycled; write=60.885 s, sync=1.990 s, total=63.646 s; sync files=20, longest=1.230 s, average=0.100 s; distance=539852 kB, estimate=553646 kB; lsn=6/CD9B3278, redo lsn=6/AF085800 2025-01-31 01:08:26.504 CET [3572] LOG: checkpoint starting: wal 2025-01-31 01:09:24.952 CET [3572] LOG: checkpoint complete: wrote 3315 buffers (20.2%); 0 WAL file(s) added, 0 removed, 33 recycled; write=57.375 s, sync=0.585 s, total=58.449 s; sync files=16, longest=0.287 s, average=0.037 s; distance=540520 kB, estimate=552333 kB; lsn=6/EDFC9168, redo lsn=6/D005FA30 2025-01-31 01:09:31.609 CET [3572] LOG: checkpoint starting: wal 2025-01-31 01:10:24.396 CET [3572] LOG: checkpoint complete: wrote 3999 buffers (24.4%); 0 WAL file(s) added, 0 removed, 33 recycled; write=50.925 s, sync=1.370 s, total=52.788 s; sync files=16, longest=0.815 s, average=0.086 s; distance=540904 kB, estimate=551190 kB; lsn=7/FB09288, redo lsn=6/F1099DC8 2025-01-31 01:10:27.359 CET [3572] LOG: checkpoint starting: wal 2025-01-31 01:11:17.388 CET [3572] LOG: checkpoint complete: wrote 4072 buffers (24.9%); 0 WAL file(s) added, 0 removed, 33 recycled; write=48.351 s, sync=1.193 s, total=50.030 s; sync files=15, longest=0.661 s, average=0.080 s; distance=540064 kB, estimate=550078 kB; lsn=7/3038B750, redo lsn=7/12002050 2025-01-31 01:11:22.498 CET [3572] LOG: checkpoint starting: wal 2025-01-31 01:12:20.104 CET [3572] LOG: checkpoint complete: wrote 4548 buffers (27.8%); 0 WAL file(s) added, 0 removed, 33 recycled; write=54.338 s, sync=2.405 s, total=57.607 s; sync files=15, longest=1.260 s, average=0.161 s; distance=542606 kB, estimate=549331 kB; lsn=7/51D4B078, redo lsn=7/331E5AB8 2025-01-31 01:12:24.625 CET [3572] LOG: checkpoint starting: wal 2025-01-31 01:13:12.215 CET [3572] LOG: checkpoint complete: wrote 3413 buffers (20.8%); 0 WAL file(s) added, 0 removed, 33 recycled; write=45.678 s, sync=1.373 s, total=47.590 s; sync files=15, longest=0.795 s, average=0.092 s; distance=539500 kB, estimate=548348 kB; lsn=7/723162C0, redo lsn=7/540C0CF0 2025-01-31 01:13:17.517 CET [3572] LOG: checkpoint starting: wal 2025-01-31 01:14:34.631 CET [3572] LOG: checkpoint complete: wrote 2137 buffers (13.0%); 0 WAL file(s) added, 0 removed, 33 recycled; write=76.520 s, sync=0.085 s, total=77.114 s; sync files=15, longest=0.010 s, average=0.006 s; distance=541523 kB, estimate=547665 kB; lsn=7/9251A410, redo lsn=7/75195C20 2025-01-31 01:18:17.280 CET [3572] LOG: checkpoint starting: time 2025-01-31 01:19:15.793 CET [1500] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-01-31 01:19:15.795 CET [2372] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-01-31 01:19:15.796 CET [1632] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-01-31 01:22:47.799 CET [3572] LOG: checkpoint complete: wrote 12754 buffers (77.8%); 0 WAL file(s) added, 0 removed, 30 recycled; write=269.740 s, sync=0.240 s, total=270.520 s; sync files=46, longest=0.018 s, average=0.006 s; distance=490448 kB, estimate=541943 kB; lsn=7/93089EA0, redo lsn=7/93089E10 2025-01-31 06:41:41.535 CET [5720] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-01-31 06:41:41.535 CET [5720] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-01-31 06:41:59.473 CET [5080] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-01-31 06:41:59.473 CET [5080] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-01-31 06:43:18.112 CET [3572] LOG: checkpoint starting: time 2025-01-31 06:43:51.321 CET [3572] LOG: checkpoint complete: wrote 303 buffers (1.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=32.926 s, sync=0.235 s, total=33.210 s; sync files=42, longest=0.013 s, average=0.006 s; distance=1951 kB, estimate=487944 kB; lsn=7/93271BC0, redo lsn=7/93271B30 2025-01-31 07:08:18.366 CET [3572] LOG: checkpoint starting: time 2025-01-31 07:08:27.119 CET [3572] LOG: checkpoint complete: wrote 79 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.488 s, sync=0.212 s, total=8.753 s; sync files=39, longest=0.011 s, average=0.006 s; distance=412 kB, estimate=439191 kB; lsn=7/932D8E50, redo lsn=7/932D8DC0 2025-01-31 08:42:10.202 CET [5720] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-01-31 08:48:16.233 CET [5080] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host.