2025-01-30 21:47:26.543 CET [4188] LOG:  database system was shut down at 2025-01-30 21:47:22 CET
2025-01-30 21:47:27.827 CET [5780] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 21:47:27.827 CET [5780] 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-30 21:51:33.485 CET [4264] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 21:51:33.485 CET [4264] 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-30 21:51:55.506 CET [5780] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-01-30 21:52:25.970 CET [3572] LOG:  checkpoint starting: time
2025-01-30 21:52:26.274 CET [3572] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.229 s, sync=0.024 s, total=0.305 s; sync files=3, longest=0.013 s, average=0.008 s; distance=0 kB, estimate=0 kB; lsn=0/1A0F8C8, redo lsn=0/1A0F870
2025-01-30 21:56:25.356 CET [2240] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 21:56:25.356 CET [2240] 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-30 21:57:25.271 CET [3572] LOG:  checkpoint starting: time
2025-01-30 21:57:30.595 CET [3572] LOG:  checkpoint complete: wrote 48 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.096 s, sync=0.188 s, total=5.325 s; sync files=39, longest=0.010 s, average=0.005 s; distance=175 kB, estimate=175 kB; lsn=0/1A3B7D8, redo lsn=0/1A3B748
2025-01-30 22:52:25.664 CET [3572] LOG:  checkpoint starting: time
2025-01-30 22:52:26.633 CET [3572] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.863 s, sync=0.051 s, total=0.969 s; sync files=5, longest=0.015 s, average=0.011 s; distance=12 kB, estimate=159 kB; lsn=0/1A3E918, redo lsn=0/1A3E8C0
2025-01-30 22:58:18.118 CET [5204] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 22:58:18.118 CET [5204] 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-30 22:59:35.000 CET [1716] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 22:59:35.000 CET [1716] 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-30 22:59:35.358 CET [3120] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 22:59:35.358 CET [3120] 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-30 23:02:25.645 CET [3572] LOG:  checkpoint starting: time
2025-01-30 23:03:38.301 CET [3572] LOG:  checkpoint complete: wrote 670 buffers (4.1%); 0 WAL file(s) added, 0 removed, 1 recycled; write=72.364 s, sync=0.222 s, total=72.656 s; sync files=36, longest=0.018 s, average=0.007 s; distance=9519 kB, estimate=9519 kB; lsn=0/2A381D0, redo lsn=0/238A8A0
2025-01-30 23:07:25.287 CET [3572] LOG:  checkpoint starting: time
2025-01-30 23:07:52.190 CET [2476] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-01-30 23:08:19.048 CET [5204] ERROR:  syntax error at or near "*" at character 8
2025-01-30 23:08:19.048 CET [5204] STATEMENT:  Delete * from customers;
2025-01-30 23:08:56.480 CET [2748] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 23:08:56.480 CET [2748] 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-30 23:09:24.604 CET [3572] LOG:  checkpoint complete: wrote 1103 buffers (6.7%); 0 WAL file(s) added, 0 removed, 1 recycled; write=119.112 s, sync=0.122 s, total=119.317 s; sync files=21, longest=0.018 s, average=0.006 s; distance=21627 kB, estimate=21627 kB; lsn=0/4698F10, redo lsn=0/38A9820
2025-01-30 23:19:00.589 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:19:51.488 CET [3572] LOG:  checkpoint complete: wrote 12843 buffers (78.4%); 0 WAL file(s) added, 0 removed, 33 recycled; write=50.242 s, sync=0.182 s, total=50.900 s; sync files=19, longest=0.029 s, average=0.010 s; distance=532194 kB, estimate=532194 kB; lsn=0/41EA1798, redo lsn=0/24062030
2025-01-30 23:19:54.959 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:20:33.271 CET [3572] LOG:  checkpoint complete: wrote 14366 buffers (87.7%); 0 WAL file(s) added, 0 removed, 33 recycled; write=37.659 s, sync=0.125 s, total=38.312 s; sync files=10, longest=0.020 s, average=0.013 s; distance=542493 kB, estimate=542493 kB; lsn=0/62E0AE70, redo lsn=0/45229628
2025-01-30 23:20:37.135 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:21:12.750 CET [3572] LOG:  checkpoint complete: wrote 14836 buffers (90.6%); 0 WAL file(s) added, 0 removed, 33 recycled; write=34.897 s, sync=0.156 s, total=35.615 s; sync files=10, longest=0.034 s, average=0.016 s; distance=540356 kB, estimate=542279 kB; lsn=0/83F9FC90, redo lsn=0/661DA628
2025-01-30 23:21:15.936 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:21:54.264 CET [3572] LOG:  checkpoint complete: wrote 14506 buffers (88.5%); 0 WAL file(s) added, 0 removed, 33 recycled; write=37.588 s, sync=0.160 s, total=38.329 s; sync files=10, longest=0.035 s, average=0.016 s; distance=540310 kB, estimate=542082 kB; lsn=0/A4F3B7E0, redo lsn=0/8717FF28
2025-01-30 23:21:57.111 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:22:34.910 CET [3572] LOG:  checkpoint complete: wrote 13838 buffers (84.5%); 0 WAL file(s) added, 0 removed, 33 recycled; write=37.060 s, sync=0.139 s, total=37.799 s; sync files=10, longest=0.025 s, average=0.014 s; distance=540392 kB, estimate=541913 kB; lsn=0/C5F250D0, redo lsn=0/A813A060
2025-01-30 23:22:38.404 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:23:12.646 CET [3572] LOG:  checkpoint complete: wrote 14213 buffers (86.7%); 0 WAL file(s) added, 0 removed, 33 recycled; write=33.422 s, sync=0.157 s, total=34.243 s; sync files=10, longest=0.034 s, average=0.016 s; distance=540500 kB, estimate=541772 kB; lsn=0/E6EE62C0, redo lsn=0/C910F288
2025-01-30 23:23:15.710 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:26:53.339 CET [4656] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 23:26:53.339 CET [4656] 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-30 23:27:19.552 CET [5256] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 23:27:19.552 CET [5256] 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-30 23:27:29.658 CET [4656] ERROR:  canceling statement due to user request
2025-01-30 23:27:29.658 CET [4656] STATEMENT:  SELECT * FROM public.customers
	ORDER BY order_number ASC 
2025-01-30 23:27:29.688 CET [4656] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-01-30 23:27:33.382 CET [3120] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-01-30 23:27:33.383 CET [2240] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-01-30 23:27:33.385 CET [5256] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-01-30 23:27:45.714 CET [3572] LOG:  checkpoint complete: wrote 10422 buffers (63.6%); 0 WAL file(s) added, 0 removed, 33 recycled; write=269.289 s, sync=0.144 s, total=270.005 s; sync files=44, longest=0.008 s, average=0.004 s; distance=540051 kB, estimate=541600 kB; lsn=0/FF7C6FE0, redo lsn=0/EA074048
2025-01-30 23:30:35.596 CET [2372] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 23:30:35.596 CET [2372] 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-30 23:30:50.542 CET [1500] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 23:30:50.542 CET [1500] 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-30 23:36:24.881 CET [468] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 23:36:24.881 CET [468] 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-30 23:36:42.042 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:37:15.599 CET [3572] LOG:  checkpoint complete: wrote 7096 buffers (43.3%); 0 WAL file(s) added, 0 removed, 33 recycled; write=30.800 s, sync=2.215 s, total=33.558 s; sync files=39, longest=0.630 s, average=0.057 s; distance=540828 kB, estimate=541523 kB; lsn=1/29921528, redo lsn=1/B09B3B0
2025-01-30 23:37:17.747 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:37:47.698 CET [3572] LOG:  checkpoint complete: wrote 5642 buffers (34.4%); 0 WAL file(s) added, 1 removed, 32 recycled; write=26.779 s, sync=2.247 s, total=29.952 s; sync files=11, longest=0.640 s, average=0.205 s; distance=540979 kB, estimate=541468 kB; lsn=1/4B00B738, redo lsn=1/2C0E80B8
2025-01-30 23:37:50.745 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:38:22.267 CET [3572] LOG:  checkpoint complete: wrote 5761 buffers (35.2%); 0 WAL file(s) added, 0 removed, 33 recycled; write=29.490 s, sync=1.449 s, total=31.522 s; sync files=11, longest=0.508 s, average=0.132 s; distance=541586 kB, estimate=541586 kB; lsn=1/6BC5D720, redo lsn=1/4D1CCC58
2025-01-30 23:38:24.593 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:38:55.382 CET [3572] LOG:  checkpoint complete: wrote 5553 buffers (33.9%); 0 WAL file(s) added, 1 removed, 32 recycled; write=27.648 s, sync=2.653 s, total=30.789 s; sync files=11, longest=0.858 s, average=0.242 s; distance=540990 kB, estimate=541527 kB; lsn=1/8D2C5258, redo lsn=1/6E21C4D8
2025-01-30 23:38:57.981 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:39:31.411 CET [3572] LOG:  checkpoint complete: wrote 5482 buffers (33.5%); 0 WAL file(s) added, 1 removed, 32 recycled; write=30.733 s, sync=2.000 s, total=33.430 s; sync files=11, longest=0.611 s, average=0.182 s; distance=541061 kB, estimate=541480 kB; lsn=1/AE402060, redo lsn=1/8F27DBD0
2025-01-30 23:39:34.365 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:40:07.345 CET [3572] LOG:  checkpoint complete: wrote 5319 buffers (32.5%); 0 WAL file(s) added, 1 removed, 32 recycled; write=29.617 s, sync=2.218 s, total=32.981 s; sync files=11, longest=0.844 s, average=0.202 s; distance=539605 kB, estimate=541293 kB; lsn=1/CF400238, redo lsn=1/B0173348
2025-01-30 23:40:09.392 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:40:27.243 CET [2588] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 23:40:27.243 CET [2588] 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-30 23:40:44.315 CET [3572] LOG:  checkpoint complete: wrote 4172 buffers (25.5%); 0 WAL file(s) added, 1 removed, 32 recycled; write=31.692 s, sync=2.057 s, total=34.923 s; sync files=11, longest=0.803 s, average=0.187 s; distance=542166 kB, estimate=542166 kB; lsn=1/F02558D8, redo lsn=1/D12E8C78
2025-01-30 23:40:46.482 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:41:18.339 CET [3572] LOG:  checkpoint complete: wrote 4773 buffers (29.1%); 0 WAL file(s) added, 0 removed, 33 recycled; write=29.351 s, sync=1.866 s, total=31.857 s; sync files=12, longest=0.675 s, average=0.156 s; distance=537957 kB, estimate=541745 kB; lsn=2/10C028D0, redo lsn=1/F2042118
2025-01-30 23:41:20.438 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:41:53.802 CET [3572] LOG:  checkpoint complete: wrote 5323 buffers (32.5%); 0 WAL file(s) added, 0 removed, 33 recycled; write=30.783 s, sync=2.005 s, total=33.364 s; sync files=11, longest=0.726 s, average=0.183 s; distance=540639 kB, estimate=541634 kB; lsn=2/31F025A8, redo lsn=2/1303A030
2025-01-30 23:41:56.526 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:42:27.713 CET [3572] LOG:  checkpoint complete: wrote 5528 buffers (33.7%); 0 WAL file(s) added, 1 removed, 32 recycled; write=27.900 s, sync=2.408 s, total=31.188 s; sync files=11, longest=0.759 s, average=0.219 s; distance=540512 kB, estimate=541522 kB; lsn=2/5313C520, redo lsn=2/34012098
2025-01-30 23:42:29.643 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:43:01.222 CET [3572] LOG:  checkpoint complete: wrote 5087 buffers (31.0%); 0 WAL file(s) added, 0 removed, 33 recycled; write=29.092 s, sync=1.890 s, total=31.580 s; sync files=11, longest=0.775 s, average=0.172 s; distance=541596 kB, estimate=541596 kB; lsn=2/73B683A0, redo lsn=2/550F9368
2025-01-30 23:43:03.892 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:43:30.848 CET [2588] ERROR:  deadlock detected
2025-01-30 23:43:30.848 CET [2588] DETAIL:  Process 2588 waits for ShareLock on transaction 30970; blocked by process 468.
	Process 468 waits for ShareLock on transaction 30971; blocked by process 2588.
	Process 2588: UPDATE customers
	SET postal_code = REPLACE(postal_code, ' ', '');
	Process 468: UPDATE customers
	SET order_number = SUBSTRING(order_number FROM 2)
	WHERE order_number LIKE 'W%';
	
2025-01-30 23:43:30.848 CET [2588] HINT:  See server log for query details.
2025-01-30 23:43:30.848 CET [2588] CONTEXT:  while updating tuple (0,1) in relation "customers"
2025-01-30 23:43:30.848 CET [2588] STATEMENT:  UPDATE customers
	SET postal_code = REPLACE(postal_code, ' ', '');
2025-01-30 23:43:35.197 CET [3572] LOG:  checkpoint complete: wrote 5239 buffers (32.0%); 0 WAL file(s) added, 0 removed, 33 recycled; write=28.795 s, sync=1.908 s, total=31.305 s; sync files=12, longest=0.669 s, average=0.159 s; distance=540364 kB, estimate=541473 kB; lsn=2/94BB0EE0, redo lsn=2/760AC490
2025-01-30 23:43:37.165 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:44:13.053 CET [3572] LOG:  checkpoint complete: wrote 4371 buffers (26.7%); 0 WAL file(s) added, 2 removed, 31 recycled; write=30.865 s, sync=4.211 s, total=35.888 s; sync files=13, longest=1.360 s, average=0.324 s; distance=541909 kB, estimate=541909 kB; lsn=2/B7033150, redo lsn=2/971E1C60
2025-01-30 23:44:13.967 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:44:48.338 CET [3572] LOG:  checkpoint complete: wrote 4836 buffers (29.5%); 0 WAL file(s) added, 1 removed, 32 recycled; write=30.049 s, sync=3.726 s, total=34.372 s; sync files=11, longest=0.900 s, average=0.339 s; distance=539422 kB, estimate=541661 kB; lsn=2/D79676C8, redo lsn=2/B80A94F0
2025-01-30 23:44:50.199 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:45:21.299 CET [3572] LOG:  checkpoint complete: wrote 5159 buffers (31.5%); 0 WAL file(s) added, 1 removed, 32 recycled; write=26.698 s, sync=3.784 s, total=31.100 s; sync files=11, longest=1.174 s, average=0.344 s; distance=540858 kB, estimate=541580 kB; lsn=2/F8A89480, redo lsn=2/D90D8080
2025-01-30 23:45:23.375 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:45:55.885 CET [3572] LOG:  checkpoint complete: wrote 3928 buffers (24.0%); 0 WAL file(s) added, 1 removed, 32 recycled; write=28.335 s, sync=3.500 s, total=32.510 s; sync files=12, longest=1.224 s, average=0.292 s; distance=540096 kB, estimate=541432 kB; lsn=3/199D44F8, redo lsn=2/FA048280
2025-01-30 23:45:57.273 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:46:32.810 CET [3572] LOG:  checkpoint complete: wrote 3726 buffers (22.7%); 0 WAL file(s) added, 3 removed, 30 recycled; write=29.898 s, sync=4.907 s, total=35.538 s; sync files=13, longest=1.629 s, average=0.378 s; distance=540888 kB, estimate=541378 kB; lsn=3/3C058DA0, redo lsn=3/1B07E280
2025-01-30 23:46:32.811 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:46:47.720 CET [468] ERROR:  duplicate key value violates unique constraint "customers_pkey"
2025-01-30 23:46:47.720 CET [468] DETAIL:  Key (order_number)=(812888411) already exists.
2025-01-30 23:46:47.720 CET [468] STATEMENT:  UPDATE customers
	SET order_number = SUBSTRING(order_number FROM 2)
	WHERE order_number LIKE 'W%';
	
2025-01-30 23:47:39.997 CET [3572] LOG:  checkpoint complete: wrote 4444 buffers (27.1%); 0 WAL file(s) added, 3 removed, 30 recycled; write=57.341 s, sync=9.166 s, total=67.186 s; sync files=16, longest=3.494 s, average=0.573 s; distance=549020 kB, estimate=549020 kB; lsn=3/5DB32C80, redo lsn=3/3C8A5588
2025-01-30 23:47:40.000 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:48:29.752 CET [3572] LOG:  checkpoint complete: wrote 4593 buffers (28.0%); 0 WAL file(s) added, 5 removed, 29 recycled; write=36.099 s, sync=12.797 s, total=49.752 s; sync files=17, longest=5.423 s, average=0.753 s; distance=548897 kB, estimate=549008 kB; lsn=3/807041A0, redo lsn=3/5E0ADAE8
2025-01-30 23:48:29.757 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:49:05.538 CET [3572] LOG:  checkpoint complete: wrote 3811 buffers (23.3%); 0 WAL file(s) added, 3 removed, 31 recycled; write=31.610 s, sync=3.594 s, total=35.781 s; sync files=14, longest=1.133 s, average=0.257 s; distance=569320 kB, estimate=569320 kB; lsn=3/A0452E48, redo lsn=3/80CA7E28
2025-01-30 23:49:06.105 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:49:36.992 CET [3572] LOG:  checkpoint complete: wrote 3803 buffers (23.2%); 0 WAL file(s) added, 0 removed, 33 recycled; write=28.070 s, sync=2.198 s, total=30.887 s; sync files=13, longest=0.877 s, average=0.170 s; distance=528208 kB, estimate=565209 kB; lsn=3/BFA52378, redo lsn=3/A107C130
2025-01-30 23:49:39.246 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:50:11.067 CET [3572] LOG:  checkpoint complete: wrote 4551 buffers (27.8%); 0 WAL file(s) added, 2 removed, 31 recycled; write=26.750 s, sync=4.548 s, total=31.822 s; sync files=12, longest=1.430 s, average=0.379 s; distance=541298 kB, estimate=562818 kB; lsn=3/E2544518, redo lsn=3/C2118B08
2025-01-30 23:50:11.613 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:50:39.957 CET [3572] LOG:  checkpoint complete: wrote 5220 buffers (31.9%); 0 WAL file(s) added, 0 removed, 33 recycled; write=25.688 s, sync=2.050 s, total=28.345 s; sync files=12, longest=0.785 s, average=0.171 s; distance=540048 kB, estimate=560541 kB; lsn=4/14E18F8, redo lsn=3/E307CF00
2025-01-30 23:50:42.261 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:51:12.692 CET [3572] LOG:  checkpoint complete: wrote 3400 buffers (20.8%); 0 WAL file(s) added, 0 removed, 33 recycled; write=26.953 s, sync=2.826 s, total=30.432 s; sync files=12, longest=0.956 s, average=0.236 s; distance=540644 kB, estimate=558551 kB; lsn=4/22E44380, redo lsn=4/4076078
2025-01-30 23:51:14.857 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:51:44.776 CET [3572] LOG:  checkpoint complete: wrote 5512 buffers (33.6%); 0 WAL file(s) added, 0 removed, 33 recycled; write=26.675 s, sync=2.714 s, total=29.919 s; sync files=11, longest=1.005 s, average=0.247 s; distance=543293 kB, estimate=557026 kB; lsn=4/43B97D78, redo lsn=4/253057C0
2025-01-30 23:51:48.233 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:52:16.747 CET [3572] LOG:  checkpoint complete: wrote 3934 buffers (24.0%); 0 WAL file(s) added, 1 removed, 32 recycled; write=24.616 s, sync=3.184 s, total=28.514 s; sync files=12, longest=1.294 s, average=0.266 s; distance=541089 kB, estimate=555432 kB; lsn=4/651AD9A8, redo lsn=4/4636DEA0
2025-01-30 23:52:19.035 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:52:35.651 CET [468] ERROR:  canceling statement due to user request
2025-01-30 23:52:35.651 CET [468] STATEMENT:  -- Usuń potencjalne duplikaty przed aktualizacją
	DELETE FROM customers
	WHERE order_number IN (
	    SELECT SUBSTRING(order_number FROM 2)
	    FROM customers
	    WHERE order_number LIKE 'W%'
	) AND order_number LIKE 'W%';
	
	-- Aktualizacja order_number (usunięcie pierwszej litery "W")
	UPDATE customers
	SET order_number = SUBSTRING(order_number FROM 2)
	WHERE order_number LIKE 'W%';
	
2025-01-30 23:52:40.032 CET [2588] ERROR:  canceling statement due to user request
2025-01-30 23:52:40.032 CET [2588] STATEMENT:  UPDATE customers
	SET postal_code = REPLACE(postal_code, ' ', '');
2025-01-30 23:52:57.650 CET [4236] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-01-30 23:52:57.650 CET [4236] 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-30 23:53:25.758 CET [3572] LOG:  checkpoint complete: wrote 3251 buffers (19.8%); 0 WAL file(s) added, 1 removed, 32 recycled; write=64.568 s, sync=1.084 s, total=66.723 s; sync files=12, longest=0.834 s, average=0.091 s; distance=537656 kB, estimate=553654 kB; lsn=4/864000D8, redo lsn=4/6707C0A8
2025-01-30 23:53:26.169 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:53:43.763 CET [3572] LOG:  checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 3 removed, 30 recycled; write=11.970 s, sync=4.368 s, total=17.596 s; sync files=12, longest=2.130 s, average=0.364 s; distance=544272 kB, estimate=552716 kB; lsn=4/A90125B0, redo lsn=4/88400218
2025-01-30 23:53:43.763 CET [3572] LOG:  checkpoints are occurring too frequently (17 seconds apart)
2025-01-30 23:53:43.763 CET [3572] HINT:  Consider increasing the configuration parameter "max_wal_size".
2025-01-30 23:53:43.764 CET [3572] LOG:  checkpoint starting: wal
2025-01-30 23:56:51.875 CET [4264] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-01-30 23:58:13.662 CET [3572] LOG:  checkpoint complete: wrote 269 buffers (1.6%); 0 WAL file(s) added, 0 removed, 34 recycled; write=269.170 s, sync=0.077 s, total=269.899 s; sync files=9, longest=0.032 s, average=0.009 s; distance=553776 kB, estimate=553776 kB; lsn=4/BE91DDE8, redo lsn=4/AA0CC388
2025-01-30 23:58:43.859 CET [3572] LOG:  checkpoint starting: time