search

dataegret / pgcompacttable

BSD 3-Clause "New" or "Revised" License
314 stars 48 forks source link

Can not process the big table. #36

Closed Claud closed 3 years ago

Claud commented 3 years ago

Command: ./pgcompacttable -h localhost -U postgres -d .... -v -s --reindex-lock-timeout 2000 -t products

How can I fix it? Sorry about the big log. 

Mon Nov 16 01:20:01 MSK 2020
[Mon Nov 16 01:20:01 2020] (ww_de_furniture) Connecting to database
[Mon Nov 16 01:20:01 2020] (ww_de_furniture) Postgres backend pid: 11539
[Mon Nov 16 01:20:01 2020] (ww_de_furniture) It is recommended to set ionice -c 3 for pgcompacttable: ionice -c 3 -p 11539
[Mon Nov 16 01:20:01 2020] (ww_de_furniture) Handling tables. Attempt 1
[Mon Nov 16 01:20:01 2020] (ww_de_furniture:public.products) Start handling table public.products
[Mon Nov 16 01:20:01 2020] (ww_de_furniture:public.products) Skipping processing: another instance is working with table public.products
[Mon Nov 16 01:20:01 2020] (ww_de_furniture:public.products) Finish handling table public.products
[Mon Nov 16 01:20:01 2020] (ww_de_furniture) Processing complete.
[Mon Nov 16 01:20:01 2020] (ww_de_furniture) Processing results: size reduced by 0.000B (0.000B including toasts and indexes) in total.
[Mon Nov 16 01:20:01 2020] (ww_de_furniture) Disconnecting from database
[Mon Nov 16 01:20:01 2020] Processing complete: 1 retries to process has been done
[Mon Nov 16 01:20:01 2020] Processing results: size reduced by 0.000B (0.000B including toasts and indexes) in total.
[Mon Nov 16 01:20:32 2020] (ww_de_furniture:public.products) Progress: 66%,  893550 pages completed.
[Mon Nov 16 01:21:33 2020] (ww_de_furniture:public.products) Progress: 66%,  894140 pages completed.
[Mon Nov 16 01:22:33 2020] (ww_de_furniture:public.products) Progress: 66%,  894670 pages completed.
[Mon Nov 16 01:23:33 2020] (ww_de_furniture:public.products) Progress: 66%,  895460 pages completed.
[Mon Nov 16 01:24:33 2020] (ww_de_furniture:public.products) Progress: 66%,  896190 pages completed.
[Mon Nov 16 01:25:34 2020] (ww_de_furniture:public.products) Progress: 66%,  896960 pages completed.
[Mon Nov 16 01:26:34 2020] (ww_de_furniture:public.products) Progress: 66%,  897640 pages completed.
[Mon Nov 16 01:27:34 2020] (ww_de_furniture:public.products) Progress: 66%,  898320 pages completed.
[Mon Nov 16 01:28:34 2020] (ww_de_furniture:public.products) Progress: 66%,  899060 pages completed.
[Mon Nov 16 01:29:35 2020] (ww_de_furniture:public.products) Progress: 66%,  899870 pages completed.
[Mon Nov 16 01:30:35 2020] (ww_de_furniture:public.products) Progress: 66%,  900585 pages completed.
[Mon Nov 16 01:31:35 2020] (ww_de_furniture:public.products) Progress: 66%,  901315 pages completed.
[Mon Nov 16 01:32:36 2020] (ww_de_furniture:public.products) Progress: 66%,  901930 pages completed.
[Mon Nov 16 01:33:38 2020] (ww_de_furniture:public.products) Progress: 66%,  902170 pages completed.
[Mon Nov 16 01:34:38 2020] (ww_de_furniture:public.products) Progress: 66%,  902635 pages completed.
[Mon Nov 16 01:35:38 2020] (ww_de_furniture:public.products) Progress: 67%,  903335 pages completed.
[Mon Nov 16 01:36:38 2020] (ww_de_furniture:public.products) Progress: 67%,  904105 pages completed.
[Mon Nov 16 01:37:39 2020] (ww_de_furniture:public.products) Progress: 67%,  904770 pages completed.
[Mon Nov 16 01:38:39 2020] (ww_de_furniture:public.products) Progress: 67%,  905635 pages completed.
[Mon Nov 16 01:40:07 2020] (ww_de_furniture:public.products) Progress: 67%,  906530 pages completed.
[Mon Nov 16 01:41:08 2020] (ww_de_furniture:public.products) Progress: 67%,  907545 pages completed.
[Mon Nov 16 01:42:08 2020] (ww_de_furniture:public.products) Progress: 67%,  908575 pages completed.
[Mon Nov 16 01:43:08 2020] (ww_de_furniture:public.products) Progress: 67%,  909530 pages completed.
[Mon Nov 16 01:44:08 2020] (ww_de_furniture:public.products) Progress: 67%,  910510 pages completed.
[Mon Nov 16 01:45:08 2020] (ww_de_furniture:public.products) Progress: 67%,  911320 pages completed.
[Mon Nov 16 01:46:08 2020] (ww_de_furniture:public.products) Progress: 67%,  912365 pages completed.
[Mon Nov 16 01:47:10 2020] (ww_de_furniture:public.products) Progress: 67%,  913125 pages completed.
[Mon Nov 16 01:48:13 2020] (ww_de_furniture:public.products) Progress: 67%,  913820 pages completed.
[Mon Nov 16 01:49:14 2020] (ww_de_furniture:public.products) Progress: 67%,  914300 pages completed.
[Mon Nov 16 01:50:14 2020] (ww_de_furniture:public.products) Progress: 67%,  914740 pages completed.
[Mon Nov 16 01:51:14 2020] (ww_de_furniture:public.products) Progress: 67%,  915510 pages completed.
[Mon Nov 16 01:52:14 2020] (ww_de_furniture:public.products) Progress: 67%,  916335 pages completed.
[Mon Nov 16 01:53:15 2020] (ww_de_furniture:public.products) Progress: 68%,  917045 pages completed.
[Mon Nov 16 01:54:15 2020] (ww_de_furniture:public.products) Progress: 68%,  917875 pages completed.
[Mon Nov 16 01:55:15 2020] (ww_de_furniture:public.products) Progress: 68%,  918795 pages completed.
[Mon Nov 16 01:56:15 2020] (ww_de_furniture:public.products) Progress: 68%,  919820 pages completed.
[Mon Nov 16 01:57:15 2020] (ww_de_furniture:public.products) Progress: 68%,  920865 pages completed.
[Mon Nov 16 01:58:16 2020] (ww_de_furniture:public.products) Progress: 68%,  921590 pages completed.
[Mon Nov 16 01:59:16 2020] (ww_de_furniture:public.products) Progress: 68%,  922210 pages completed.
[Mon Nov 16 02:00:16 2020] (ww_de_furniture:public.products) Progress: 68%,  922890 pages completed.
[Mon Nov 16 02:01:35 2020] (ww_de_furniture:public.products) Progress: 68%,  922990 pages completed.
[Mon Nov 16 02:02:35 2020] (ww_de_furniture:public.products) Progress: 68%,  923795 pages completed.
[Mon Nov 16 02:03:36 2020] (ww_de_furniture:public.products) Progress: 68%,  924515 pages completed.
[Mon Nov 16 02:04:39 2020] (ww_de_furniture:public.products) Progress: 68%,  924905 pages completed.
[Mon Nov 16 02:05:39 2020] (ww_de_furniture:public.products) Progress: 68%,  925345 pages completed.
[Mon Nov 16 02:06:39 2020] (ww_de_furniture:public.products) Progress: 68%,  925965 pages completed.
[Mon Nov 16 02:07:39 2020] (ww_de_furniture:public.products) Progress: 68%,  926700 pages completed.
[Mon Nov 16 02:08:40 2020] (ww_de_furniture:public.products) Progress: 68%,  927560 pages completed.
[Mon Nov 16 02:09:41 2020] (ww_de_furniture:public.products) Progress: 68%,  928320 pages completed.
[Mon Nov 16 02:10:41 2020] (ww_de_furniture:public.products) Progress: 68%,  929115 pages completed.
[Mon Nov 16 02:11:41 2020] (ww_de_furniture:public.products) Progress: 68%,  930045 pages completed.
[Mon Nov 16 02:12:48 2020] (ww_de_furniture:public.products) Progress: 69%,  930950 pages completed.
[Mon Nov 16 02:13:59 2020] (ww_de_furniture:public.products) Progress: 69%,  931730 pages completed.
[Mon Nov 16 02:14:59 2020] (ww_de_furniture:public.products) Progress: 69%,  932635 pages completed.
[Mon Nov 16 02:15:59 2020] (ww_de_furniture:public.products) Progress: 69%,  933595 pages completed.
[Mon Nov 16 02:17:00 2020] (ww_de_furniture:public.products) Progress: 69%,  934200 pages completed.
[Mon Nov 16 02:18:00 2020] (ww_de_furniture:public.products) Progress: 69%,  934875 pages completed.
[Mon Nov 16 02:19:00 2020] (ww_de_furniture:public.products) Progress: 69%,  935715 pages completed.
[Mon Nov 16 02:21:12 2020] (ww_de_furniture:public.products) Progress: 69%,  936110 pages completed.
[Mon Nov 16 02:22:12 2020] (ww_de_furniture:public.products) Progress: 69%,  936610 pages completed.
[Mon Nov 16 02:23:12 2020] (ww_de_furniture:public.products) Progress: 69%,  937730 pages completed.
[Mon Nov 16 02:24:12 2020] (ww_de_furniture:public.products) Progress: 69%,  939715 pages completed.
[Mon Nov 16 02:25:12 2020] (ww_de_furniture:public.products) Progress: 69%,  940980 pages completed.
[Mon Nov 16 02:26:12 2020] (ww_de_furniture:public.products) Progress: 69%,  942480 pages completed.
[Mon Nov 16 02:27:13 2020] (ww_de_furniture:public.products) Progress: 69%,  943340 pages completed.
[Mon Nov 16 02:28:13 2020] (ww_de_furniture:public.products) Progress: 70%,  944330 pages completed.
[Mon Nov 16 02:29:13 2020] (ww_de_furniture:public.products) Progress: 70%,  945290 pages completed.
[Mon Nov 16 02:30:14 2020] (ww_de_furniture:public.products) Progress: 70%,  946355 pages completed.
[Mon Nov 16 02:31:14 2020] (ww_de_furniture:public.products) Progress: 70%,  947390 pages completed.
[Mon Nov 16 02:32:14 2020] (ww_de_furniture:public.products) Progress: 70%,  948195 pages completed.
[Mon Nov 16 02:33:14 2020] (ww_de_furniture:public.products) Progress: 70%,  948955 pages completed.
[Mon Nov 16 02:34:15 2020] (ww_de_furniture:public.products) Progress: 70%,  949920 pages completed.
[Mon Nov 16 02:35:15 2020] (ww_de_furniture:public.products) Progress: 70%,  950635 pages completed.
[Mon Nov 16 02:36:15 2020] (ww_de_furniture:public.products) Progress: 70%,  951120 pages completed.
[Mon Nov 16 02:37:15 2020] (ww_de_furniture:public.products) Progress: 70%,  951550 pages completed.
[Mon Nov 16 02:38:15 2020] (ww_de_furniture:public.products) Progress: 70%,  952525 pages completed.
[Mon Nov 16 02:39:15 2020] (ww_de_furniture:public.products) Progress: 70%,  953485 pages completed.
[Mon Nov 16 02:40:16 2020] (ww_de_furniture:public.products) Progress: 70%,  954605 pages completed.
[Mon Nov 16 02:41:16 2020] (ww_de_furniture:public.products) Progress: 70%,  955450 pages completed.
[Mon Nov 16 02:42:16 2020] (ww_de_furniture:public.products) Progress: 70%,  956470 pages completed.
[Mon Nov 16 02:43:16 2020] (ww_de_furniture:public.products) Progress: 71%,  957630 pages completed.
[Mon Nov 16 02:44:17 2020] (ww_de_furniture:public.products) Progress: 71%,  958415 pages completed.
[Mon Nov 16 02:45:17 2020] (ww_de_furniture:public.products) Progress: 71%,  959710 pages completed.
[Mon Nov 16 02:46:17 2020] (ww_de_furniture:public.products) Progress: 71%,  961165 pages completed.
[Mon Nov 16 02:47:17 2020] (ww_de_furniture:public.products) Progress: 71%,  962100 pages completed.
[Mon Nov 16 02:48:17 2020] (ww_de_furniture:public.products) Progress: 71%,  963435 pages completed.
[Mon Nov 16 02:49:17 2020] (ww_de_furniture:public.products) Progress: 71%,  965165 pages completed.
[Mon Nov 16 02:50:17 2020] (ww_de_furniture:public.products) Progress: 71%,  966485 pages completed.
[Mon Nov 16 02:51:17 2020] (ww_de_furniture:public.products) Progress: 71%,  967435 pages completed.
[Mon Nov 16 02:52:17 2020] (ww_de_furniture:public.products) Progress: 71%,  968405 pages completed.
[Mon Nov 16 02:53:18 2020] (ww_de_furniture:public.products) Progress: 71%,  969200 pages completed.
[Mon Nov 16 02:54:19 2020] (ww_de_furniture:public.products) Progress: 71%,  969605 pages completed.
[Mon Nov 16 02:55:19 2020] (ww_de_furniture:public.products) Progress: 71%,  970120 pages completed.
[Mon Nov 16 02:56:20 2020] (ww_de_furniture:public.products) Progress: 72%,  970925 pages completed.
[Mon Nov 16 02:57:59 2020] (ww_de_furniture:public.products) Progress: 72%,  971585 pages completed.
[Mon Nov 16 02:58:59 2020] (ww_de_furniture:public.products) Progress: 72%,  972100 pages completed.
[Mon Nov 16 02:59:59 2020] (ww_de_furniture:public.products) Progress: 72%,  972860 pages completed.
[Mon Nov 16 03:00:59 2020] (ww_de_furniture:public.products) Progress: 72%,  973250 pages completed.
[Mon Nov 16 03:02:00 2020] (ww_de_furniture:public.products) Progress: 72%,  973650 pages completed.
[Mon Nov 16 03:03:00 2020] (ww_de_furniture:public.products) Progress: 72%,  974035 pages completed.
[Mon Nov 16 03:04:01 2020] (ww_de_furniture:public.products) Progress: 72%,  974790 pages completed.
[Mon Nov 16 03:05:01 2020] (ww_de_furniture:public.products) Progress: 72%,  975590 pages completed.
[Mon Nov 16 03:06:01 2020] (ww_de_furniture:public.products) Progress: 72%,  976385 pages completed.
[Mon Nov 16 03:07:01 2020] (ww_de_furniture:public.products) Progress: 72%,  977125 pages completed.
[Mon Nov 16 03:08:01 2020] (ww_de_furniture:public.products) Progress: 72%,  977735 pages completed.
[Mon Nov 16 03:09:01 2020] (ww_de_furniture:public.products) Progress: 72%,  978425 pages completed.
[Mon Nov 16 03:10:02 2020] (ww_de_furniture:public.products) Progress: 72%,  979180 pages completed.
[Mon Nov 16 03:11:25 2020] (ww_de_furniture:public.products) Progress: 72%,  979605 pages completed.
[Mon Nov 16 03:12:25 2020] (ww_de_furniture:public.products) Progress: 72%,  980050 pages completed.
[Mon Nov 16 03:13:26 2020] (ww_de_furniture:public.products) Progress: 72%,  980485 pages completed.
[Mon Nov 16 03:14:26 2020] (ww_de_furniture:public.products) Progress: 72%,  981315 pages completed.
[Mon Nov 16 03:15:26 2020] (ww_de_furniture:public.products) Progress: 72%,  982125 pages completed.
[Mon Nov 16 03:16:27 2020] (ww_de_furniture:public.products) Progress: 72%,  982710 pages completed.
[Mon Nov 16 03:17:27 2020] (ww_de_furniture:public.products) Progress: 72%,  983225 pages completed.
[Mon Nov 16 03:18:27 2020] (ww_de_furniture:public.products) Progress: 72%,  983750 pages completed.
[Mon Nov 16 03:19:27 2020] (ww_de_furniture:public.products) Progress: 73%,  984190 pages completed.
[Mon Nov 16 03:20:28 2020] (ww_de_furniture:public.products) Progress: 73%,  984650 pages completed.
[Mon Nov 16 03:21:28 2020] (ww_de_furniture:public.products) Progress: 73%,  985160 pages completed.
[Mon Nov 16 03:22:28 2020] (ww_de_furniture:public.products) Progress: 73%,  985480 pages completed.
[Mon Nov 16 03:23:29 2020] (ww_de_furniture:public.products) Progress: 73%,  986020 pages completed.
[Mon Nov 16 03:24:29 2020] (ww_de_furniture:public.products) Progress: 73%,  986620 pages completed.
[Mon Nov 16 03:25:30 2020] (ww_de_furniture:public.products) Progress: 73%,  987295 pages completed.
[Mon Nov 16 03:26:30 2020] (ww_de_furniture:public.products) Progress: 73%,  987790 pages completed.
[Mon Nov 16 03:27:30 2020] (ww_de_furniture:public.products) Progress: 73%,  988295 pages completed.
[Mon Nov 16 03:28:31 2020] (ww_de_furniture:public.products) Progress: 73%,  988720 pages completed.
[Mon Nov 16 03:29:31 2020] (ww_de_furniture:public.products) Progress: 73%,  989345 pages completed.
[Mon Nov 16 03:30:31 2020] (ww_de_furniture:public.products) Progress: 73%,  990000 pages completed.
[Mon Nov 16 03:31:31 2020] (ww_de_furniture:public.products) Progress: 73%,  990580 pages completed.
[Mon Nov 16 03:32:31 2020] (ww_de_furniture:public.products) Progress: 73%,  991430 pages completed.
[Mon Nov 16 03:33:31 2020] (ww_de_furniture:public.products) Progress: 73%,  991985 pages completed.
[Mon Nov 16 03:34:32 2020] (ww_de_furniture:public.products) Progress: 73%,  992580 pages completed.
[Mon Nov 16 03:35:32 2020] (ww_de_furniture:public.products) Progress: 73%,  992975 pages completed.
[Mon Nov 16 03:36:32 2020] (ww_de_furniture:public.products) Progress: 73%,  993360 pages completed.
[Mon Nov 16 03:37:33 2020] (ww_de_furniture:public.products) Progress: 73%,  994190 pages completed.
[Mon Nov 16 03:38:33 2020] (ww_de_furniture:public.products) Progress: 73%,  994890 pages completed.
[Mon Nov 16 03:40:13 2020] (ww_de_furniture:public.products) Progress: 73%,  995330 pages completed.
[Mon Nov 16 03:41:13 2020] (ww_de_furniture:public.products) Progress: 73%,  996015 pages completed.
[Mon Nov 16 03:42:14 2020] (ww_de_furniture:public.products) Progress: 73%,  996905 pages completed.
[Mon Nov 16 03:43:14 2020] (ww_de_furniture:public.products) Progress: 74%,  997660 pages completed.
[Mon Nov 16 03:44:14 2020] (ww_de_furniture:public.products) Progress: 74%,  998350 pages completed.
[Mon Nov 16 03:45:15 2020] (ww_de_furniture:public.products) Progress: 74%,  999005 pages completed.
[Mon Nov 16 03:46:15 2020] (ww_de_furniture:public.products) Progress: 74%,  999595 pages completed.
[Mon Nov 16 03:47:15 2020] (ww_de_furniture:public.products) Progress: 74%,  1000310 pages completed.
[Mon Nov 16 03:48:15 2020] (ww_de_furniture:public.products) Progress: 74%,  1001000 pages completed.
[Mon Nov 16 03:49:16 2020] (ww_de_furniture:public.products) Progress: 74%,  1001570 pages completed.
[Mon Nov 16 03:50:16 2020] (ww_de_furniture:public.products) Progress: 74%,  1002420 pages completed.
[Mon Nov 16 03:51:16 2020] (ww_de_furniture:public.products) Progress: 74%,  1003295 pages completed.
[Mon Nov 16 03:52:16 2020] (ww_de_furniture:public.products) Progress: 74%,  1004190 pages completed.
[Mon Nov 16 03:53:26 2020] (ww_de_furniture:public.products) Progress: 74%,  1005030 pages completed.
[Mon Nov 16 03:54:26 2020] (ww_de_furniture:public.products) Progress: 74%,  1005495 pages completed.
[Mon Nov 16 03:55:26 2020] (ww_de_furniture:public.products) Progress: 74%,  1005840 pages completed.
[Mon Nov 16 03:56:27 2020] (ww_de_furniture:public.products) Progress: 74%,  1006730 pages completed.
[Mon Nov 16 03:57:27 2020] (ww_de_furniture:public.products) Progress: 74%,  1007440 pages completed.
[Mon Nov 16 03:58:27 2020] (ww_de_furniture:public.products) Progress: 74%,  1008100 pages completed.
[Mon Nov 16 03:59:27 2020] (ww_de_furniture:public.products) Progress: 74%,  1008750 pages completed.
[Mon Nov 16 04:00:27 2020] (ww_de_furniture:public.products) Progress: 74%,  1009280 pages completed.
[Mon Nov 16 04:01:28 2020] (ww_de_furniture:public.products) Progress: 74%,  1009890 pages completed.
[Mon Nov 16 04:02:28 2020] (ww_de_furniture:public.products) Progress: 74%,  1010565 pages completed.
[Mon Nov 16 04:03:28 2020] (ww_de_furniture:public.products) Progress: 75%,  1011310 pages completed.
[Mon Nov 16 04:04:28 2020] (ww_de_furniture:public.products) Progress: 75%,  1012030 pages completed.
[Mon Nov 16 04:05:29 2020] (ww_de_furniture:public.products) Progress: 75%,  1012815 pages completed.
[Mon Nov 16 04:06:29 2020] (ww_de_furniture:public.products) Progress: 75%,  1013540 pages completed.
[Mon Nov 16 04:07:29 2020] (ww_de_furniture:public.products) Progress: 75%,  1014150 pages completed.
[Mon Nov 16 04:08:30 2020] (ww_de_furniture:public.products) Progress: 75%,  1015225 pages completed.
[Mon Nov 16 04:09:30 2020] (ww_de_furniture:public.products) Progress: 75%,  1015695 pages completed.
[Mon Nov 16 04:10:30 2020] (ww_de_furniture:public.products) Progress: 75%,  1016380 pages completed.
[Mon Nov 16 04:11:30 2020] (ww_de_furniture:public.products) Progress: 75%,  1018105 pages completed.
[Mon Nov 16 04:12:31 2020] (ww_de_furniture:public.products) Progress: 75%,  1018990 pages completed.
[Mon Nov 16 04:13:31 2020] (ww_de_furniture:public.products) Progress: 75%,  1019720 pages completed.
[Mon Nov 16 04:14:33 2020] (ww_de_furniture:public.products) Progress: 75%,  1020480 pages completed.
[Mon Nov 16 04:15:33 2020] (ww_de_furniture:public.products) Progress: 75%,  1020985 pages completed.
[Mon Nov 16 04:16:34 2020] (ww_de_furniture:public.products) Progress: 75%,  1021470 pages completed.
[Mon Nov 16 04:17:34 2020] (ww_de_furniture:public.products) Progress: 75%,  1021875 pages completed.
[Mon Nov 16 04:18:34 2020] (ww_de_furniture:public.products) Progress: 75%,  1022495 pages completed.
[Mon Nov 16 04:19:34 2020] (ww_de_furniture:public.products) Progress: 75%,  1023355 pages completed.
[Mon Nov 16 04:20:35 2020] (ww_de_furniture:public.products) Progress: 75%,  1024170 pages completed.
[Mon Nov 16 04:21:35 2020] (ww_de_furniture:public.products) Progress: 76%,  1024910 pages completed.
[Mon Nov 16 04:22:35 2020] (ww_de_furniture:public.products) Progress: 76%,  1025595 pages completed.
[Mon Nov 16 04:23:36 2020] (ww_de_furniture:public.products) Progress: 76%,  1026300 pages completed.
[Mon Nov 16 04:24:36 2020] (ww_de_furniture:public.products) Progress: 76%,  1026890 pages completed.
[Mon Nov 16 04:25:36 2020] (ww_de_furniture:public.products) Progress: 76%,  1027535 pages completed.
[Mon Nov 16 04:26:36 2020] (ww_de_furniture:public.products) Progress: 76%,  1028170 pages completed.
[Mon Nov 16 04:27:36 2020] (ww_de_furniture:public.products) Progress: 76%,  1028885 pages completed.
[Mon Nov 16 04:28:36 2020] (ww_de_furniture:public.products) Progress: 76%,  1029520 pages completed.
[Mon Nov 16 04:29:37 2020] (ww_de_furniture:public.products) Progress: 76%,  1030220 pages completed.
[Mon Nov 16 04:30:37 2020] (ww_de_furniture:public.products) Progress: 76%,  1030745 pages completed.
[Mon Nov 16 04:31:38 2020] (ww_de_furniture:public.products) Progress: 76%,  1031395 pages completed.
[Mon Nov 16 04:32:38 2020] (ww_de_furniture:public.products) Progress: 76%,  1032225 pages completed.
[Mon Nov 16 04:33:38 2020] (ww_de_furniture:public.products) Progress: 76%,  1033275 pages completed.
[Mon Nov 16 04:34:38 2020] (ww_de_furniture:public.products) Progress: 76%,  1034125 pages completed.
[Mon Nov 16 04:35:39 2020] (ww_de_furniture:public.products) Progress: 76%,  1034835 pages completed.
[Mon Nov 16 04:36:39 2020] (ww_de_furniture:public.products) Progress: 76%,  1035525 pages completed.
[Mon Nov 16 04:37:39 2020] (ww_de_furniture:public.products) Progress: 76%,  1036230 pages completed.
[Mon Nov 16 04:38:40 2020] (ww_de_furniture:public.products) Progress: 76%,  1036760 pages completed.
[Mon Nov 16 04:39:40 2020] (ww_de_furniture:public.products) Progress: 76%,  1037175 pages completed.
[Mon Nov 16 04:40:41 2020] (ww_de_furniture:public.products) Progress: 76%,  1037845 pages completed.
[Mon Nov 16 04:41:41 2020] (ww_de_furniture:public.products) Progress: 77%,  1038415 pages completed.
[Mon Nov 16 04:42:41 2020] (ww_de_furniture:public.products) Progress: 77%,  1039255 pages completed.
[Mon Nov 16 04:43:41 2020] (ww_de_furniture:public.products) Progress: 77%,  1040145 pages completed.
[Mon Nov 16 04:44:42 2020] (ww_de_furniture:public.products) Progress: 77%,  1042555 pages completed.
[Mon Nov 16 04:45:42 2020] (ww_de_furniture:public.products) Progress: 77%,  1043325 pages completed.
[Mon Nov 16 04:46:42 2020] (ww_de_furniture:public.products) Progress: 77%,  1044110 pages completed.
[Mon Nov 16 04:47:42 2020] (ww_de_furniture:public.products) Progress: 77%,  1044930 pages completed.
[Mon Nov 16 04:48:43 2020] (ww_de_furniture:public.products) Progress: 77%,  1045880 pages completed.
[Mon Nov 16 04:49:43 2020] (ww_de_furniture:public.products) Progress: 77%,  1046655 pages completed.
[Mon Nov 16 04:50:43 2020] (ww_de_furniture:public.products) Progress: 77%,  1047455 pages completed.
[Mon Nov 16 04:51:43 2020] (ww_de_furniture:public.products) Progress: 77%,  1048255 pages completed.
[Mon Nov 16 04:53:29 2020] (ww_de_furniture:public.products) Progress: 77%,  1048670 pages completed.
[Mon Nov 16 04:54:29 2020] (ww_de_furniture:public.products) Progress: 77%,  1049515 pages completed.
[Mon Nov 16 04:55:29 2020] (ww_de_furniture:public.products) Progress: 77%,  1050450 pages completed.
[Mon Nov 16 04:56:30 2020] (ww_de_furniture:public.products) Progress: 77%,  1051340 pages completed.
[Mon Nov 16 04:57:30 2020] (ww_de_furniture:public.products) Progress: 78%,  1052200 pages completed.
[Mon Nov 16 05:11:24 2020] (ww_de_furniture:public.products) Progress: 78%,  1052975 pages completed.
[Mon Nov 16 05:12:24 2020] (ww_de_furniture:public.products) Progress: 78%,  1053940 pages completed.
[Mon Nov 16 05:13:25 2020] (ww_de_furniture:public.products) Progress: 78%,  1054410 pages completed.
[Mon Nov 16 05:14:25 2020] (ww_de_furniture:public.products) Progress: 78%,  1055165 pages completed.
[Mon Nov 16 05:15:25 2020] (ww_de_furniture:public.products) Progress: 78%,  1056030 pages completed.
[Mon Nov 16 05:16:25 2020] (ww_de_furniture:public.products) Progress: 78%,  1056795 pages completed.
[Mon Nov 16 05:17:25 2020] (ww_de_furniture:public.products) Progress: 78%,  1057720 pages completed.
[Mon Nov 16 05:18:25 2020] (ww_de_furniture:public.products) Progress: 78%,  1058570 pages completed.
[Mon Nov 16 05:20:10 2020] (ww_de_furniture:public.products) Progress: 78%,  1059110 pages completed.
[Mon Nov 16 05:21:10 2020] (ww_de_furniture:public.products) Progress: 78%,  1059525 pages completed.
[Mon Nov 16 05:22:10 2020] (ww_de_furniture:public.products) Progress: 78%,  1060110 pages completed.
[Mon Nov 16 05:23:10 2020] (ww_de_furniture:public.products) Progress: 78%,  1061100 pages completed.
[Mon Nov 16 05:24:11 2020] (ww_de_furniture:public.products) Progress: 78%,  1061890 pages completed.
[Mon Nov 16 05:25:11 2020] (ww_de_furniture:public.products) Progress: 78%,  1062610 pages completed.
[Mon Nov 16 05:26:11 2020] (ww_de_furniture:public.products) Progress: 78%,  1063535 pages completed.
[Mon Nov 16 05:27:11 2020] (ww_de_furniture:public.products) Progress: 78%,  1064215 pages completed.
[Mon Nov 16 05:28:11 2020] (ww_de_furniture:public.products) Progress: 79%,  1065275 pages completed.
[Mon Nov 16 05:29:11 2020] (ww_de_furniture:public.products) Progress: 79%,  1066455 pages completed.
[Mon Nov 16 05:31:46 2020] (ww_de_furniture:public.products) Progress: 79%,  1066855 pages completed.
[Mon Nov 16 05:32:46 2020] (ww_de_furniture:public.products) Progress: 79%,  1070495 pages completed.
[Mon Nov 16 05:33:46 2020] (ww_de_furniture:public.products) Progress: 79%,  1073375 pages completed.
[Mon Nov 16 05:34:46 2020] (ww_de_furniture:public.products) Progress: 79%,  1076235 pages completed.
[Mon Nov 16 05:35:46 2020] (ww_de_furniture:public.products) Progress: 80%,  1079685 pages completed.
[Mon Nov 16 05:36:46 2020] (ww_de_furniture:public.products) Progress: 80%,  1082840 pages completed.
[Mon Nov 16 05:37:46 2020] (ww_de_furniture:public.products) Progress: 80%,  1086020 pages completed.
[Mon Nov 16 05:38:47 2020] (ww_de_furniture:public.products) Progress: 80%,  1089310 pages completed.
[Mon Nov 16 05:39:47 2020] (ww_de_furniture:public.products) Progress: 81%,  1092945 pages completed.
[Mon Nov 16 05:40:47 2020] (ww_de_furniture:public.products) Progress: 81%,  1096195 pages completed.
[Mon Nov 16 05:41:47 2020] (ww_de_furniture:public.products) Progress: 81%,  1099070 pages completed.
[Mon Nov 16 05:42:47 2020] (ww_de_furniture:public.products) Progress: 81%,  1101280 pages completed.
[Mon Nov 16 05:43:47 2020] (ww_de_furniture:public.products) Progress: 81%,  1103685 pages completed.
[Mon Nov 16 05:44:47 2020] (ww_de_furniture:public.products) Progress: 82%,  1106795 pages completed.
[Mon Nov 16 05:45:47 2020] (ww_de_furniture:public.products) Progress: 82%,  1109565 pages completed.
[Mon Nov 16 05:46:47 2020] (ww_de_furniture:public.products) Progress: 82%,  1111980 pages completed.
[Mon Nov 16 05:47:47 2020] (ww_de_furniture:public.products) Progress: 82%,  1114475 pages completed.
[Mon Nov 16 05:48:47 2020] (ww_de_furniture:public.products) Progress: 82%,  1116775 pages completed.
[Mon Nov 16 05:49:47 2020] (ww_de_furniture:public.products) Progress: 83%,  1119175 pages completed.
[Mon Nov 16 05:50:48 2020] (ww_de_furniture:public.products) Progress: 83%,  1121730 pages completed.
[Mon Nov 16 05:51:48 2020] (ww_de_furniture:public.products) Progress: 83%,  1124055 pages completed.
[Mon Nov 16 05:52:48 2020] (ww_de_furniture:public.products) Progress: 83%,  1126330 pages completed.
[Mon Nov 16 05:53:48 2020] (ww_de_furniture:public.products) Progress: 83%,  1128905 pages completed.
[Mon Nov 16 05:54:48 2020] (ww_de_furniture:public.products) Progress: 83%,  1130735 pages completed.
[Mon Nov 16 05:55:48 2020] (ww_de_furniture:public.products) Progress: 84%,  1133760 pages completed.
[Mon Nov 16 05:56:48 2020] (ww_de_furniture:public.products) Progress: 84%,  1136815 pages completed.
[Mon Nov 16 05:57:48 2020] (ww_de_furniture:public.products) Progress: 84%,  1140130 pages completed.
[Mon Nov 16 05:58:48 2020] (ww_de_furniture:public.products) Progress: 84%,  1143640 pages completed.
[Mon Nov 16 05:59:48 2020] (ww_de_furniture:public.products) Progress: 85%,  1145860 pages completed.
[Mon Nov 16 06:00:48 2020] (ww_de_furniture:public.products) Progress: 85%,  1146935 pages completed.
[Mon Nov 16 06:01:48 2020] (ww_de_furniture:public.products) Progress: 85%,  1148060 pages completed.
[Mon Nov 16 06:02:49 2020] (ww_de_furniture:public.products) Progress: 85%,  1149680 pages completed.
[Mon Nov 16 06:03:49 2020] (ww_de_furniture:public.products) Progress: 85%,  1151640 pages completed.
[Mon Nov 16 06:04:49 2020] (ww_de_furniture:public.products) Progress: 85%,  1153380 pages completed.
[Mon Nov 16 06:05:49 2020] (ww_de_furniture:public.products) Progress: 85%,  1155845 pages completed.
[Mon Nov 16 06:06:49 2020] (ww_de_furniture:public.products) Progress: 85%,  1158310 pages completed.
[Mon Nov 16 06:07:49 2020] (ww_de_furniture:public.products) Progress: 86%,  1160305 pages completed.
[Mon Nov 16 06:08:49 2020] (ww_de_furniture:public.products) Progress: 86%,  1162430 pages completed.
[Mon Nov 16 06:09:49 2020] (ww_de_furniture:public.products) Progress: 86%,  1165850 pages completed.
[Mon Nov 16 06:10:50 2020] (ww_de_furniture:public.products) Progress: 86%,  1170235 pages completed.
[Mon Nov 16 06:11:50 2020] (ww_de_furniture:public.products) Progress: 86%,  1172390 pages completed.
[Mon Nov 16 06:12:50 2020] (ww_de_furniture:public.products) Progress: 87%,  1175660 pages completed.
[Mon Nov 16 06:13:50 2020] (ww_de_furniture:public.products) Progress: 87%,  1177985 pages completed.
[Mon Nov 16 06:14:50 2020] (ww_de_furniture:public.products) Progress: 87%,  1180845 pages completed.
[Mon Nov 16 06:15:50 2020] (ww_de_furniture:public.products) Progress: 87%,  1182655 pages completed.
[Mon Nov 16 06:16:50 2020] (ww_de_furniture:public.products) Progress: 87%,  1184710 pages completed.
[Mon Nov 16 06:26:07 2020] (ww_de_furniture:public.products) Vacuum final: cannot clean 1185436 pages, 1922769 pages left, duration 531.897 seconds.
[Mon Nov 16 06:26:45 2020] (ww_de_furniture:public.products) Analyze final: duration 37.215 second.
[Mon Nov 16 06:30:39 2020] (ww_de_furniture:public.products) Bloat statistics with pgstattuple: duration 234.622 seconds.
[Mon Nov 16 07:32:54 2020] (ww_de_furniture:public.products) Reindex: public.products__checked_broken_images_at, initial size 47 pages(376.000KB), has been reduced by 34% (128.000KB), duration 3734 seconds, attempts 0.
[Mon Nov 16 07:32:54 2020] (ww_de_furniture:public.products) Reindex queries: public.products__checked_broken_images_at, initial size 47 pages (376.000KB), will be reduced by 49% (185.368KB)
[Mon Nov 16 07:32:54 2020] (ww_de_furniture:public.products) CREATE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (checked_broken_images_at) TABLESPACE pg_default WHERE ((checked_broken_images_at IS NOT NULL) AND (broken_images = true)); --ww_de_furniture
[Mon Nov 16 07:32:54 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER INDEX "public"."products__checked_broken_images_at" RENAME TO "tmp_84437558";
ALTER INDEX "public".pgcompact_index_3035 RENAME TO "products__checked_broken_images_at";
END;
DROP INDEX CONCURRENTLY "public"."tmp_84437558";; --ww_de_furniture
[Mon Nov 16 08:24:07 2020] (ww_de_furniture:public.products) Reindex: public.products__broken_images, initial size 58 pages(464.000KB), has been reduced by 46% (216.000KB), duration 3072 seconds, attempts 0.
[Mon Nov 16 08:24:07 2020] (ww_de_furniture:public.products) Reindex queries: public.products__broken_images, initial size 58 pages (464.000KB), will be reduced by 43% (201.892KB)
[Mon Nov 16 08:24:07 2020] (ww_de_furniture:public.products) CREATE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (broken_images) TABLESPACE pg_default WHERE ((broken_images = true) OR (broken_images IS NULL)); --ww_de_furniture
[Mon Nov 16 08:24:07 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER INDEX "public"."products__broken_images" RENAME TO "tmp_65522692";
ALTER INDEX "public".pgcompact_index_3035 RENAME TO "products__broken_images";
END;
DROP INDEX CONCURRENTLY "public"."tmp_65522692";; --ww_de_furniture
[Mon Nov 16 09:10:00 2020] (ww_de_furniture:public.products) Reindex: public.products__need_reindex, initial size 1664 pages(13.000MB), has been reduced by 90% (11.719MB), duration 2752 seconds, attempts 0.
[Mon Nov 16 09:10:00 2020] (ww_de_furniture:public.products) Reindex queries: public.products__need_reindex, initial size 1664 pages (13.000MB), will be reduced by 46% (6.098MB)
[Mon Nov 16 09:10:00 2020] (ww_de_furniture:public.products) CREATE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (need_reindex) TABLESPACE pg_default WHERE (need_reindex = true); --ww_de_furniture
[Mon Nov 16 09:10:00 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER INDEX "public"."products__need_reindex" RENAME TO "tmp_405189153";
ALTER INDEX "public".pgcompact_index_3035 RENAME TO "products__need_reindex";
END;
DROP INDEX CONCURRENTLY "public"."tmp_405189153";; --ww_de_furniture
[Mon Nov 16 09:10:00 2020] (ww_de_furniture:public.products) Skipping reindex: public.products__unique_short_ean is a gin index not a btree, reindexing is up to you.
[Mon Nov 16 09:10:00 2020] (ww_de_furniture:public.products) Reindex queries: public.products__unique_short_ean, initial size 9038 pages (70.609MB)
[Mon Nov 16 09:10:00 2020] (ww_de_furniture:public.products) REINDEX INDEX ('"public"."products__unique_short_ean"'); --ww_de_furniture
[Mon Nov 16 10:03:39 2020] (ww_de_furniture:public.products) Reindex: public.products__canonical_url__partner_id__is_null__unique, initial size 10190 pages(79.609MB), has been reduced by 55% (43.867MB), duration 3218 seconds, attempts 0.
[Mon Nov 16 10:03:39 2020] (ww_de_furniture:public.products) Reindex queries: public.products__canonical_url__partner_id__is_null__unique, initial size 10190 pages (79.609MB), will be reduced by 35% (28.208MB)
[Mon Nov 16 10:03:39 2020] (ww_de_furniture:public.products) CREATE UNIQUE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (canonical_url) TABLESPACE pg_default WHERE (partner_id IS NULL); --ww_de_furniture
[Mon Nov 16 10:03:39 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER INDEX "public"."products__canonical_url__partner_id__is_null__unique" RENAME TO "tmp_865339717";
ALTER INDEX "public".pgcompact_index_3035 RENAME TO "products__canonical_url__partner_id__is_null__unique";
END;
DROP INDEX CONCURRENTLY "public"."tmp_865339717";; --ww_de_furniture
[Mon Nov 16 10:03:39 2020] (ww_de_furniture:public.products) Skipping reindex: public.products__ean is a gin index not a btree, reindexing is up to you.
[Mon Nov 16 10:03:39 2020] (ww_de_furniture:public.products) Reindex queries: public.products__ean, initial size 19857 pages (155.133MB)
[Mon Nov 16 10:03:39 2020] (ww_de_furniture:public.products) REINDEX INDEX ('"public"."products__ean"'); --ww_de_furniture
[Mon Nov 16 10:39:45 2020] (ww_de_furniture:public.products) Reindex: public.products__mark_as_deleted_at, initial size 24915 pages(194.648MB), has been reduced by 53% (104.320MB), duration 2165 seconds, attempts 0.
[Mon Nov 16 10:39:45 2020] (ww_de_furniture:public.products) Reindex queries: public.products__mark_as_deleted_at, initial size 24915 pages (194.648MB), will be reduced by 29% (56.686MB)
[Mon Nov 16 10:39:45 2020] (ww_de_furniture:public.products) CREATE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (mark_as_deleted_at) TABLESPACE pg_default; --ww_de_furniture
[Mon Nov 16 10:39:45 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER INDEX "public"."products__mark_as_deleted_at" RENAME TO "tmp_490914356";
ALTER INDEX "public".pgcompact_index_3035 RENAME TO "products__mark_as_deleted_at";
END;
DROP INDEX CONCURRENTLY "public"."tmp_490914356";; --ww_de_furniture
[Mon Nov 16 11:32:42 2020] (ww_de_furniture:public.products) Reindex: public.products__last_external_visit_to_sp_page_at, initial size 24723 pages(193.148MB), has been reduced by 53% (102.812MB), duration 3174 seconds, attempts 0.
[Mon Nov 16 11:32:42 2020] (ww_de_furniture:public.products) Reindex queries: public.products__last_external_visit_to_sp_page_at, initial size 24723 pages (193.148MB), will be reduced by 29% (56.850MB)
[Mon Nov 16 11:32:42 2020] (ww_de_furniture:public.products) CREATE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (last_external_visit_to_sp_page_at) TABLESPACE pg_default; --ww_de_furniture
[Mon Nov 16 11:32:42 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER INDEX "public"."products__last_external_visit_to_sp_page_at" RENAME TO "tmp_869721077";
ALTER INDEX "public".pgcompact_index_3035 RENAME TO "products__last_external_visit_to_sp_page_at";
END;
DROP INDEX CONCURRENTLY "public"."tmp_869721077";; --ww_de_furniture
[Mon Nov 16 12:28:56 2020] (ww_de_furniture:public.products) Reindex: public.products_created_at_index, initial size 25574 pages(199.797MB), has been reduced by 54% (109.492MB), duration 3371 seconds, attempts 0.
[Mon Nov 16 12:28:56 2020] (ww_de_furniture:public.products) Reindex queries: public.products_created_at_index, initial size 25574 pages (199.797MB), will be reduced by 35% (70.817MB)
[Mon Nov 16 12:28:56 2020] (ww_de_furniture:public.products) CREATE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (created_at) TABLESPACE pg_default; --ww_de_furniture
[Mon Nov 16 12:28:56 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER INDEX "public"."products_created_at_index" RENAME TO "tmp_228049313";
ALTER INDEX "public".pgcompact_index_3035 RENAME TO "products_created_at_index";
END;
DROP INDEX CONCURRENTLY "public"."tmp_228049313";; --ww_de_furniture
[Mon Nov 16 13:06:42 2020] (ww_de_furniture:public.products) Reindex: public.products_partner_id_index, initial size 28369 pages(221.633MB), has been reduced by 59% (131.156MB), duration 2264 seconds, attempts 0.
[Mon Nov 16 13:06:42 2020] (ww_de_furniture:public.products) Reindex queries: public.products_partner_id_index, initial size 28369 pages (221.633MB), will be reduced by 37% (82.472MB)
[Mon Nov 16 13:06:42 2020] (ww_de_furniture:public.products) CREATE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (partner_id) TABLESPACE pg_default; --ww_de_furniture
[Mon Nov 16 13:06:42 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER INDEX "public"."products_partner_id_index" RENAME TO "tmp_958547825";
ALTER INDEX "public".pgcompact_index_3035 RENAME TO "products_partner_id_index";
END;
DROP INDEX CONCURRENTLY "public"."tmp_958547825";; --ww_de_furniture
[Mon Nov 16 14:00:29 2020] (ww_de_furniture:public.products) Reindex: public.products_category_id_index, initial size 32689 pages(255.383MB), has been reduced by 64% (164.906MB), duration 3223 seconds, attempts 0.
[Mon Nov 16 14:00:29 2020] (ww_de_furniture:public.products) Reindex queries: public.products_category_id_index, initial size 32689 pages (255.383MB), will be reduced by 45% (116.114MB)
[Mon Nov 16 14:00:29 2020] (ww_de_furniture:public.products) CREATE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (category_id) TABLESPACE pg_default; --ww_de_furniture
[Mon Nov 16 14:00:29 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER INDEX "public"."products_category_id_index" RENAME TO "tmp_419669745";
ALTER INDEX "public".pgcompact_index_3035 RENAME TO "products_category_id_index";
END;
DROP INDEX CONCURRENTLY "public"."tmp_419669745";; --ww_de_furniture
[Mon Nov 16 14:00:31 2020] (ww_de_furniture:public.products) Skipping reindex: public.products_pkey, can not reindex without heavy locks because of its dependencies, reindexing is up to you.
[Mon Nov 16 14:00:31 2020] (ww_de_furniture:public.products) Reindex queries: public.products_pkey, initial size 31412 pages (245.406MB), will be reduced by 47% (117.004MB)
[Mon Nov 16 14:00:31 2020] (ww_de_furniture:public.products) CREATE UNIQUE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (id) TABLESPACE pg_default; --ww_de_furniture
[Mon Nov 16 14:00:31 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER TABLE "public"."products" DROP CONSTRAINT "products_pkey";
ALTER TABLE "public"."products" ADD CONSTRAINT "products_pkey" PRIMARY KEY USING INDEX pgcompact_index_3035;
END;; --ww_de_furniture
[Mon Nov 16 14:16:51 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 1
[Mon Nov 16 14:16:54 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 2
[Mon Nov 16 14:16:57 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 3
[Mon Nov 16 14:17:00 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 4
[Mon Nov 16 14:17:03 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 5
[Mon Nov 16 14:17:06 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 6
[Mon Nov 16 14:17:09 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 7
[Mon Nov 16 14:17:12 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 8
[Mon Nov 16 14:17:15 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 9
[Mon Nov 16 14:17:18 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 10
[Mon Nov 16 14:17:21 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 11
[Mon Nov 16 14:17:24 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 12
[Mon Nov 16 14:17:27 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 13
[Mon Nov 16 14:17:30 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 14
[Mon Nov 16 14:17:33 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 15
[Mon Nov 16 14:17:36 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 16
[Mon Nov 16 14:17:39 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 17
[Mon Nov 16 14:17:42 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 18
[Mon Nov 16 14:17:45 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 19
[Mon Nov 16 14:17:48 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 20
[Mon Nov 16 14:17:51 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 21
[Mon Nov 16 14:17:54 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 22
[Mon Nov 16 14:17:57 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 23
[Mon Nov 16 14:18:00 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 24
[Mon Nov 16 14:18:03 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 25
[Mon Nov 16 14:18:06 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 26
[Mon Nov 16 14:18:09 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 27
[Mon Nov 16 14:18:12 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 28
[Mon Nov 16 14:18:15 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 29
[Mon Nov 16 14:18:18 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 30
[Mon Nov 16 14:18:21 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 31
[Mon Nov 16 14:18:24 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 32
[Mon Nov 16 14:18:27 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 33
[Mon Nov 16 14:18:30 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 34
[Mon Nov 16 14:18:33 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 35
[Mon Nov 16 14:18:36 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 36
[Mon Nov 16 14:18:39 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 37
[Mon Nov 16 14:18:42 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 38
[Mon Nov 16 14:18:45 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 39
[Mon Nov 16 14:18:48 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 40
[Mon Nov 16 14:18:51 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 41
[Mon Nov 16 14:18:54 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 42
[Mon Nov 16 14:18:57 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 43
[Mon Nov 16 14:19:00 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 44
[Mon Nov 16 14:19:03 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 45
[Mon Nov 16 14:19:06 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 46
[Mon Nov 16 14:19:09 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 47
[Mon Nov 16 14:19:12 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 48
[Mon Nov 16 14:19:15 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 49
[Mon Nov 16 14:19:18 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 50
[Mon Nov 16 14:19:21 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 51
[Mon Nov 16 14:19:24 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 52
[Mon Nov 16 14:19:27 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 53
[Mon Nov 16 14:19:30 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 54
[Mon Nov 16 14:19:33 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 55
[Mon Nov 16 14:19:36 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 56
[Mon Nov 16 14:19:39 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 57
[Mon Nov 16 14:19:42 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 58
[Mon Nov 16 14:19:45 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 59
[Mon Nov 16 14:19:48 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 60
[Mon Nov 16 14:19:51 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 61
[Mon Nov 16 14:19:54 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 62
[Mon Nov 16 14:19:57 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 63
[Mon Nov 16 14:20:00 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 64
[Mon Nov 16 14:20:03 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 65
[Mon Nov 16 14:20:06 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 66
[Mon Nov 16 14:20:09 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 67
[Mon Nov 16 14:20:12 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 68
[Mon Nov 16 14:20:15 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 69
[Mon Nov 16 14:20:18 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 70
[Mon Nov 16 14:20:21 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 71
[Mon Nov 16 14:20:24 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 72
[Mon Nov 16 14:20:27 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 73
[Mon Nov 16 14:20:30 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 74
[Mon Nov 16 14:20:33 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 75
[Mon Nov 16 14:20:36 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 76
[Mon Nov 16 14:20:39 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 77
[Mon Nov 16 14:20:42 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 78
[Mon Nov 16 14:20:45 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 79
[Mon Nov 16 14:20:48 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 80
[Mon Nov 16 14:20:51 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 81
[Mon Nov 16 14:20:54 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 82
[Mon Nov 16 14:20:57 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 83
[Mon Nov 16 14:21:00 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 84
[Mon Nov 16 14:21:03 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 85
[Mon Nov 16 14:21:06 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 86
[Mon Nov 16 14:21:09 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 87
[Mon Nov 16 14:21:12 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 88
[Mon Nov 16 14:21:15 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 89
[Mon Nov 16 14:21:18 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 90
[Mon Nov 16 14:21:21 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 91
[Mon Nov 16 14:21:24 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 92
[Mon Nov 16 14:21:27 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 93
[Mon Nov 16 14:21:30 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 94
[Mon Nov 16 14:21:33 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 95
[Mon Nov 16 14:21:36 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 96
[Mon Nov 16 14:21:39 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 97
[Mon Nov 16 14:21:42 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 98
[Mon Nov 16 14:21:45 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 99
[Mon Nov 16 14:21:48 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock retry 100
[Mon Nov 16 14:21:49 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, unable lock, delete index
[Mon Nov 16 14:47:59 2020] (ww_de_furniture:public.products) Reindex: public.products_uid_partner_id_unique, lock has not been acquired, initial size 42108 pages(328.969MB)
[Mon Nov 16 14:47:59 2020] (ww_de_furniture:public.products) Reindex queries: public.products_uid_partner_id_unique, initial size 42108 pages (328.969MB), will be reduced by 29% (96.169MB)
[Mon Nov 16 14:47:59 2020] (ww_de_furniture:public.products) CREATE UNIQUE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (uid, partner_id) TABLESPACE pg_default; --ww_de_furniture
[Mon Nov 16 14:47:59 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER TABLE "public"."products" DROP CONSTRAINT "products_uid_partner_id_unique";
ALTER TABLE "public"."products" ADD CONSTRAINT "products_uid_partner_id_unique" UNIQUE USING INDEX pgcompact_index_3035;
END;; --ww_de_furniture
[Mon Nov 16 15:26:40 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 1
[Mon Nov 16 15:26:43 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 2
[Mon Nov 16 15:26:46 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 3
[Mon Nov 16 15:26:49 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 4
[Mon Nov 16 15:26:52 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 5
[Mon Nov 16 15:26:55 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 6
[Mon Nov 16 15:26:58 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 7
[Mon Nov 16 15:27:01 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 8
[Mon Nov 16 15:27:04 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 9
[Mon Nov 16 15:27:07 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 10
[Mon Nov 16 15:27:10 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 11
[Mon Nov 16 15:27:13 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 12
[Mon Nov 16 15:27:16 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 13
[Mon Nov 16 15:27:19 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 14
[Mon Nov 16 15:27:22 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 15
[Mon Nov 16 15:27:25 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 16
[Mon Nov 16 15:27:28 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 17
[Mon Nov 16 15:27:31 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 18
[Mon Nov 16 15:27:34 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 19
[Mon Nov 16 15:27:37 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 20
[Mon Nov 16 15:27:40 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 21
[Mon Nov 16 15:27:43 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 22
[Mon Nov 16 15:27:46 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 23
[Mon Nov 16 15:27:49 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 24
[Mon Nov 16 15:27:52 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 25
[Mon Nov 16 15:27:55 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 26
[Mon Nov 16 15:27:58 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 27
[Mon Nov 16 15:28:01 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 28
[Mon Nov 16 15:28:04 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 29
[Mon Nov 16 15:28:07 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 30
[Mon Nov 16 15:28:10 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 31
[Mon Nov 16 15:28:13 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 32
[Mon Nov 16 15:28:16 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 33
[Mon Nov 16 15:28:19 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 34
[Mon Nov 16 15:28:22 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 35
[Mon Nov 16 15:28:25 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 36
[Mon Nov 16 15:28:28 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 37
[Mon Nov 16 15:28:31 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 38
[Mon Nov 16 15:28:34 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 39
[Mon Nov 16 15:28:37 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 40
[Mon Nov 16 15:28:40 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 41
[Mon Nov 16 15:28:43 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 42
[Mon Nov 16 15:28:46 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 43
[Mon Nov 16 15:28:49 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 44
[Mon Nov 16 15:28:52 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 45
[Mon Nov 16 15:28:55 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 46
[Mon Nov 16 15:28:58 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 47
[Mon Nov 16 15:29:01 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 48
[Mon Nov 16 15:29:04 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 49
[Mon Nov 16 15:29:07 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 50
[Mon Nov 16 15:29:10 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 51
[Mon Nov 16 15:29:13 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 52
[Mon Nov 16 15:29:16 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 53
[Mon Nov 16 15:29:19 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 54
[Mon Nov 16 15:29:22 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 55
[Mon Nov 16 15:29:25 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 56
[Mon Nov 16 15:29:28 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 57
[Mon Nov 16 15:29:31 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 58
[Mon Nov 16 15:29:34 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 59
[Mon Nov 16 15:29:37 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 60
[Mon Nov 16 15:29:40 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 61
[Mon Nov 16 15:29:43 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 62
[Mon Nov 16 15:29:46 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 63
[Mon Nov 16 15:29:49 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 64
[Mon Nov 16 15:29:52 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 65
[Mon Nov 16 15:29:55 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 66
[Mon Nov 16 15:29:58 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 67
[Mon Nov 16 15:30:01 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 68
[Mon Nov 16 15:30:04 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 69
[Mon Nov 16 15:30:07 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 70
[Mon Nov 16 15:30:10 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 71
[Mon Nov 16 15:30:13 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 72
[Mon Nov 16 15:30:16 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 73
[Mon Nov 16 15:30:19 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 74
[Mon Nov 16 15:30:22 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 75
[Mon Nov 16 15:30:25 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 76
[Mon Nov 16 15:30:28 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 77
[Mon Nov 16 15:30:31 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 78
[Mon Nov 16 15:30:34 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 79
[Mon Nov 16 15:30:37 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 80
[Mon Nov 16 15:30:40 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 81
[Mon Nov 16 15:30:43 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 82
[Mon Nov 16 15:30:46 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 83
[Mon Nov 16 15:30:49 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 84
[Mon Nov 16 15:30:52 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 85
[Mon Nov 16 15:30:55 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 86
[Mon Nov 16 15:30:58 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 87
[Mon Nov 16 15:31:01 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 88
[Mon Nov 16 15:31:04 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 89
[Mon Nov 16 15:31:07 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 90
[Mon Nov 16 15:31:10 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 91
[Mon Nov 16 15:31:13 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 92
[Mon Nov 16 15:31:16 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 93
[Mon Nov 16 15:31:19 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 94
[Mon Nov 16 15:31:22 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 95
[Mon Nov 16 15:31:25 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 96
[Mon Nov 16 15:31:28 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 97
[Mon Nov 16 15:31:31 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 98
[Mon Nov 16 15:31:34 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 99
[Mon Nov 16 15:31:37 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock retry 100
[Mon Nov 16 15:31:38 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, unable lock, delete index
[Mon Nov 16 16:09:15 2020] (ww_de_furniture:public.products) Reindex: public.products_short_uid_partner_id_unique, lock has not been acquired, initial size 45124 pages(352.531MB)
[Mon Nov 16 16:09:15 2020] (ww_de_furniture:public.products) Reindex queries: public.products_short_uid_partner_id_unique, initial size 45124 pages (352.531MB), will be reduced by 32% (114.103MB)
[Mon Nov 16 16:09:15 2020] (ww_de_furniture:public.products) CREATE UNIQUE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (short_uid, partner_id) TABLESPACE pg_default; --ww_de_furniture
[Mon Nov 16 16:09:15 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER TABLE "public"."products" DROP CONSTRAINT "products_short_uid_partner_id_unique";
ALTER TABLE "public"."products" ADD CONSTRAINT "products_short_uid_partner_id_unique" UNIQUE USING INDEX pgcompact_index_3035;
END;; --ww_de_furniture
[Mon Nov 16 16:09:15 2020] (ww_de_furniture:public.products) Skipping reindex: public.products__images_ids is a gin index not a btree, reindexing is up to you.
[Mon Nov 16 16:09:15 2020] (ww_de_furniture:public.products) Reindex queries: public.products__images_ids, initial size 45510 pages (355.547MB)
[Mon Nov 16 16:09:15 2020] (ww_de_furniture:public.products) REINDEX INDEX ('"public"."products__images_ids"'); --ww_de_furniture
[Mon Nov 16 17:01:51 2020] (ww_de_furniture:public.products) Reindex: public.products_canonical_url_index, initial size 136635 pages(1.042GB), has been reduced by 45% (486.211MB), duration 3146 seconds, attempts 0.
[Mon Nov 16 17:01:51 2020] (ww_de_furniture:public.products) Reindex queries: public.products_canonical_url_index, initial size 136635 pages (1.042GB), will be reduced by 32% (349.771MB)
[Mon Nov 16 17:01:51 2020] (ww_de_furniture:public.products) CREATE INDEX CONCURRENTLY pgcompact_index_3035 ON public.products USING btree (canonical_url) TABLESPACE pg_default; --ww_de_furniture
[Mon Nov 16 17:01:51 2020] (ww_de_furniture:public.products) BEGIN; SET LOCAL statement_timeout TO 2000;
ALTER INDEX "public"."products_canonical_url_index" RENAME TO "tmp_306730786";
ALTER INDEX "public".pgcompact_index_3035 RENAME TO "products_canonical_url_index";
END;
DROP INDEX CONCURRENTLY "public"."tmp_306730786";; --ww_de_furniture
[Mon Nov 16 17:01:51 2020] (ww_de_furniture:public.products) Processing incomplete.
[Mon Nov 16 17:01:51 2020] (ww_de_furniture:public.products) Processing results: 1922769 pages (2510768 pages including toasts and indexes), size has been reduced by 0.000B (2.094GB including toasts and indexes) in total. This attempt has been initially expected to compact ~69% more space (1343888 pages, 10.253GB)
[Mon Nov 16 17:01:51 2020] (ww_de_furniture:public.products) Finish handling table public.products
[Mon Nov 16 17:01:51 2020] (ww_de_furniture) Processing incomplete: 1 tables left.
[Mon Nov 16 17:01:51 2020] (ww_de_furniture) Processing results: size reduced by 0.000B (2.094GB including toasts and indexes) in total.
[Mon Nov 16 17:01:51 2020] (ww_de_furniture) Disconnecting from database
[Mon Nov 16 17:01:51 2020] Processing incomplete: 1 databases left.
[Mon Nov 16 17:01:51 2020] Processing results: size reduced by 0.000B (2.094GB including toasts and indexes) in total.
Melkij commented 3 years ago

Hello I do not see any issue in this log. Some other long transaction in this database is preventing processing.

Also just ~15GB is a really small table.

Claud commented 3 years ago

Do I understand you correctly? Before running pgcompacttable, do I need to stop all processes that interact with the database?

Melkij commented 3 years ago

No. If you are able to stop all activity, run just native vacuum full. Otherwise you need pgcompacttable or pg_repack. pg_repack will terminate all conflicted sessions by itself. pgcompacttable not. If your database has a long transaction while processing with pgcompacttable - vacuum will not truncate empty pages at the end of the relation because they are not empty yet. Later autovacuum may (or may not, depends on emptiness of last pages in relation) truncate empty pages. Or the next time you run pgcompacttable later, when this long transaction ends.