trace_sort2.log
application/octet-stream
Filename: trace_sort2.log
Type: application/octet-stream
Part: 0
8856/2018-10-29 15:58:40 CET LOG: begin index sort: unique = f, workMem = 698709, randomAccess = f 8856/2018-10-29 15:58:40 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:58:40 CET LOG: begin index sort: unique = f, workMem = 698709, randomAccess = f 7280/2018-10-29 15:58:40 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:40 CET LOG: begin index sort: unique = f, workMem = 698709, randomAccess = f 8856/2018-10-29 15:58:40 CET CONTEXT: parallel worker 8856/2018-10-29 15:58:40 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:58:40 CET LOG: begin index sort: unique = f, workMem = 698709, randomAccess = f 2736/2018-10-29 15:58:40 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:40 CET LOG: begin index sort: unique = f, workMem = 698709, randomAccess = f 8856/2018-10-29 15:58:40 CET CONTEXT: parallel worker 8856/2018-10-29 15:58:40 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:46 CET LOG: 0 switching to external sort with 501 tapes: CPU: user: 3.85 s, system: 2.15 s, elapsed: 6.16 s 8856/2018-10-29 15:58:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:46 CET LOG: 0 starting quicksort of run 1: CPU: user: 3.85 s, system: 2.15 s, elapsed: 6.16 s 8856/2018-10-29 15:58:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:58:46 CET LOG: 2 switching to external sort with 501 tapes: CPU: user: 4.14 s, system: 1.85 s, elapsed: 6.22 s 2736/2018-10-29 15:58:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:46 CET LOG: 2 switching to external sort with 501 tapes: CPU: user: 4.14 s, system: 1.85 s, elapsed: 6.22 s 8856/2018-10-29 15:58:46 CET CONTEXT: parallel worker 8856/2018-10-29 15:58:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:58:46 CET LOG: 2 starting quicksort of run 1: CPU: user: 4.14 s, system: 1.85 s, elapsed: 6.22 s 2736/2018-10-29 15:58:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:46 CET LOG: 2 starting quicksort of run 1: CPU: user: 4.14 s, system: 1.85 s, elapsed: 6.22 s 8856/2018-10-29 15:58:46 CET CONTEXT: parallel worker 8856/2018-10-29 15:58:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:58:46 CET LOG: 1 switching to external sort with 501 tapes: CPU: user: 3.90 s, system: 2.23 s, elapsed: 6.31 s 7280/2018-10-29 15:58:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:46 CET LOG: 1 switching to external sort with 501 tapes: CPU: user: 3.90 s, system: 2.23 s, elapsed: 6.31 s 8856/2018-10-29 15:58:46 CET CONTEXT: parallel worker 8856/2018-10-29 15:58:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:58:46 CET LOG: 1 starting quicksort of run 1: CPU: user: 3.90 s, system: 2.23 s, elapsed: 6.31 s 7280/2018-10-29 15:58:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:46 CET LOG: 1 starting quicksort of run 1: CPU: user: 3.90 s, system: 2.23 s, elapsed: 6.31 s 8856/2018-10-29 15:58:46 CET CONTEXT: parallel worker 8856/2018-10-29 15:58:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:58:56 CET LOG: 1 finished quicksort of run 1: CPU: user: 13.82 s, system: 2.23 s, elapsed: 16.23 s 7280/2018-10-29 15:58:56 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:56 CET LOG: 1 finished quicksort of run 1: CPU: user: 13.82 s, system: 2.23 s, elapsed: 16.23 s 8856/2018-10-29 15:58:56 CET CONTEXT: parallel worker 8856/2018-10-29 15:58:56 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:57 CET LOG: 0 finished quicksort of run 1: CPU: user: 14.33 s, system: 2.15 s, elapsed: 16.64 s 8856/2018-10-29 15:58:57 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:58:57 CET LOG: 2 finished quicksort of run 1: CPU: user: 14.67 s, system: 1.85 s, elapsed: 16.75 s 2736/2018-10-29 15:58:57 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:58:58 CET LOG: 1 finished writing run 1 to tape 0: CPU: user: 14.58 s, system: 3.08 s, elapsed: 17.86 s 7280/2018-10-29 15:58:58 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:58 CET LOG: 0 finished writing run 1 to tape 0: CPU: user: 15.10 s, system: 2.96 s, elapsed: 18.22 s 8856/2018-10-29 15:58:58 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:58 CET LOG: 2 finished quicksort of run 1: CPU: user: 14.67 s, system: 1.85 s, elapsed: 16.75 s 8856/2018-10-29 15:58:58 CET CONTEXT: parallel worker 8856/2018-10-29 15:58:58 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:58 CET LOG: 1 finished writing run 1 to tape 0: CPU: user: 14.58 s, system: 3.08 s, elapsed: 17.86 s 8856/2018-10-29 15:58:58 CET CONTEXT: parallel worker 8856/2018-10-29 15:58:58 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:58:59 CET LOG: 2 finished writing run 1 to tape 0: CPU: user: 15.52 s, system: 2.65 s, elapsed: 18.64 s 2736/2018-10-29 15:58:59 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:58:59 CET LOG: 2 finished writing run 1 to tape 0: CPU: user: 15.52 s, system: 2.65 s, elapsed: 18.64 s 8856/2018-10-29 15:58:59 CET CONTEXT: parallel worker 8856/2018-10-29 15:58:59 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:59:03 CET LOG: 1 starting quicksort of run 2: CPU: user: 18.28 s, system: 4.88 s, elapsed: 23.52 s 7280/2018-10-29 15:59:03 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:03 CET LOG: 1 starting quicksort of run 2: CPU: user: 18.28 s, system: 4.88 s, elapsed: 23.52 s 8856/2018-10-29 15:59:03 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:03 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:04 CET LOG: 0 starting quicksort of run 2: CPU: user: 18.48 s, system: 4.83 s, elapsed: 23.74 s 8856/2018-10-29 15:59:04 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:59:04 CET LOG: 2 starting quicksort of run 2: CPU: user: 19.00 s, system: 4.49 s, elapsed: 24.10 s 2736/2018-10-29 15:59:04 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:04 CET LOG: 2 starting quicksort of run 2: CPU: user: 19.00 s, system: 4.49 s, elapsed: 24.10 s 8856/2018-10-29 15:59:04 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:04 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:13 CET LOG: 0 finished quicksort of run 2: CPU: user: 27.76 s, system: 4.83 s, elapsed: 33.02 s 8856/2018-10-29 15:59:13 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:59:13 CET LOG: 1 finished quicksort of run 2: CPU: user: 27.97 s, system: 4.88 s, elapsed: 33.21 s 7280/2018-10-29 15:59:13 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:59:14 CET LOG: 2 finished quicksort of run 2: CPU: user: 28.90 s, system: 4.49 s, elapsed: 34.00 s 2736/2018-10-29 15:59:14 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:15 CET LOG: 0 finished writing run 2 to tape 1: CPU: user: 28.70 s, system: 5.53 s, elapsed: 34.74 s 8856/2018-10-29 15:59:15 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:15 CET LOG: 2 finished quicksort of run 2: CPU: user: 28.90 s, system: 4.49 s, elapsed: 34.00 s 8856/2018-10-29 15:59:15 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:15 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:15 CET LOG: 1 finished quicksort of run 2: CPU: user: 27.97 s, system: 4.88 s, elapsed: 33.21 s 8856/2018-10-29 15:59:15 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:15 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:59:15 CET LOG: 1 finished writing run 2 to tape 1: CPU: user: 28.86 s, system: 5.61 s, elapsed: 34.91 s 7280/2018-10-29 15:59:15 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:15 CET LOG: 1 finished writing run 2 to tape 1: CPU: user: 28.86 s, system: 5.61 s, elapsed: 34.91 s 8856/2018-10-29 15:59:15 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:15 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:59:16 CET LOG: 2 finished writing run 2 to tape 1: CPU: user: 29.65 s, system: 5.31 s, elapsed: 35.66 s 2736/2018-10-29 15:59:16 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:16 CET LOG: 2 finished writing run 2 to tape 1: CPU: user: 29.65 s, system: 5.31 s, elapsed: 35.66 s 8856/2018-10-29 15:59:16 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:16 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:20 CET LOG: 0 starting quicksort of run 3: CPU: user: 32.65 s, system: 6.97 s, elapsed: 40.24 s 8856/2018-10-29 15:59:20 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:59:20 CET LOG: 1 starting quicksort of run 3: CPU: user: 32.60 s, system: 7.36 s, elapsed: 40.49 s 7280/2018-10-29 15:59:20 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:20 CET LOG: 1 starting quicksort of run 3: CPU: user: 32.60 s, system: 7.36 s, elapsed: 40.49 s 8856/2018-10-29 15:59:20 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:20 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:59:21 CET LOG: 2 starting quicksort of run 3: CPU: user: 33.38 s, system: 6.78 s, elapsed: 40.99 s 2736/2018-10-29 15:59:21 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:21 CET LOG: 2 starting quicksort of run 3: CPU: user: 33.38 s, system: 6.78 s, elapsed: 40.99 s 8856/2018-10-29 15:59:21 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:21 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:29 CET LOG: 0 finished quicksort of run 3: CPU: user: 41.76 s, system: 6.97 s, elapsed: 49.35 s 8856/2018-10-29 15:59:29 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:59:29 CET LOG: 1 finished quicksort of run 3: CPU: user: 41.51 s, system: 7.36 s, elapsed: 49.40 s 7280/2018-10-29 15:59:29 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:59:30 CET LOG: 2 finished quicksort of run 3: CPU: user: 42.02 s, system: 6.78 s, elapsed: 49.63 s 2736/2018-10-29 15:59:30 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:31 CET LOG: 0 finished writing run 3 to tape 2: CPU: user: 42.58 s, system: 7.65 s, elapsed: 50.87 s 8856/2018-10-29 15:59:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:31 CET LOG: 2 finished quicksort of run 3: CPU: user: 42.02 s, system: 6.78 s, elapsed: 49.63 s 8856/2018-10-29 15:59:31 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:31 CET LOG: 1 finished quicksort of run 3: CPU: user: 41.51 s, system: 7.36 s, elapsed: 49.40 s 8856/2018-10-29 15:59:31 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:59:31 CET LOG: 1 finished writing run 3 to tape 2: CPU: user: 42.19 s, system: 8.25 s, elapsed: 50.98 s 7280/2018-10-29 15:59:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:31 CET LOG: 1 finished writing run 3 to tape 2: CPU: user: 42.19 s, system: 8.25 s, elapsed: 50.98 s 8856/2018-10-29 15:59:31 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:59:31 CET LOG: 2 finished writing run 3 to tape 2: CPU: user: 42.77 s, system: 7.65 s, elapsed: 51.26 s 2736/2018-10-29 15:59:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:31 CET LOG: 2 finished writing run 3 to tape 2: CPU: user: 42.77 s, system: 7.65 s, elapsed: 51.26 s 8856/2018-10-29 15:59:31 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:37 CET LOG: 0 starting quicksort of run 4: CPU: user: 46.06 s, system: 9.75 s, elapsed: 56.62 s 8856/2018-10-29 15:59:37 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:59:37 CET LOG: 1 starting quicksort of run 4: CPU: user: 45.89 s, system: 10.17 s, elapsed: 56.86 s 7280/2018-10-29 15:59:37 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:37 CET LOG: 1 starting quicksort of run 4: CPU: user: 45.89 s, system: 10.17 s, elapsed: 56.86 s 8856/2018-10-29 15:59:37 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:37 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:59:37 CET LOG: 2 starting quicksort of run 4: CPU: user: 46.23 s, system: 9.70 s, elapsed: 57.00 s 2736/2018-10-29 15:59:37 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:37 CET LOG: 2 starting quicksort of run 4: CPU: user: 46.23 s, system: 9.70 s, elapsed: 57.00 s 8856/2018-10-29 15:59:37 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:37 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:47 CET LOG: 0 finished quicksort of run 4: CPU: user: 56.70 s, system: 9.75 s, elapsed: 67.26 s 8856/2018-10-29 15:59:47 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:59:48 CET LOG: 1 finished quicksort of run 4: CPU: user: 56.64 s, system: 10.17 s, elapsed: 67.61 s 7280/2018-10-29 15:59:48 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:59:49 CET LOG: 2 finished quicksort of run 4: CPU: user: 57.82 s, system: 9.70 s, elapsed: 68.59 s 2736/2018-10-29 15:59:49 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:49 CET LOG: 0 finished writing run 4 to tape 3: CPU: user: 57.56 s, system: 10.49 s, elapsed: 68.87 s 8856/2018-10-29 15:59:49 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:49 CET LOG: 2 finished quicksort of run 4: CPU: user: 57.82 s, system: 9.70 s, elapsed: 68.59 s 8856/2018-10-29 15:59:49 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:49 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:49 CET LOG: 1 finished quicksort of run 4: CPU: user: 56.64 s, system: 10.17 s, elapsed: 67.61 s 8856/2018-10-29 15:59:49 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:49 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:59:49 CET LOG: 1 finished writing run 4 to tape 3: CPU: user: 57.61 s, system: 10.85 s, elapsed: 69.26 s 7280/2018-10-29 15:59:49 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:49 CET LOG: 1 finished writing run 4 to tape 3: CPU: user: 57.61 s, system: 10.85 s, elapsed: 69.26 s 8856/2018-10-29 15:59:49 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:49 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:59:50 CET LOG: 2 finished writing run 4 to tape 3: CPU: user: 58.67 s, system: 10.51 s, elapsed: 70.24 s 2736/2018-10-29 15:59:50 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:50 CET LOG: 2 finished writing run 4 to tape 3: CPU: user: 58.67 s, system: 10.51 s, elapsed: 70.24 s 8856/2018-10-29 15:59:50 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:50 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:55 CET LOG: 0 starting quicksort of run 5: CPU: user: 61.37 s, system: 12.30 s, elapsed: 74.63 s 8856/2018-10-29 15:59:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 15:59:55 CET LOG: 1 starting quicksort of run 5: CPU: user: 61.38 s, system: 12.74 s, elapsed: 75.09 s 7280/2018-10-29 15:59:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:55 CET LOG: 1 starting quicksort of run 5: CPU: user: 61.38 s, system: 12.74 s, elapsed: 75.09 s 8856/2018-10-29 15:59:55 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 15:59:56 CET LOG: 2 starting quicksort of run 5: CPU: user: 62.32 s, system: 12.30 s, elapsed: 75.86 s 2736/2018-10-29 15:59:56 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 15:59:56 CET LOG: 2 starting quicksort of run 5: CPU: user: 62.32 s, system: 12.30 s, elapsed: 75.86 s 8856/2018-10-29 15:59:56 CET CONTEXT: parallel worker 8856/2018-10-29 15:59:56 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:05 CET LOG: 0 finished quicksort of run 5: CPU: user: 72.04 s, system: 12.30 s, elapsed: 85.30 s 8856/2018-10-29 16:00:05 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:00:05 CET LOG: 1 finished quicksort of run 5: CPU: user: 71.68 s, system: 12.74 s, elapsed: 85.39 s 7280/2018-10-29 16:00:05 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:07 CET LOG: 0 finished writing run 5 to tape 4: CPU: user: 72.85 s, system: 13.07 s, elapsed: 86.87 s 8856/2018-10-29 16:00:07 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:07 CET LOG: 1 finished quicksort of run 5: CPU: user: 71.68 s, system: 12.74 s, elapsed: 85.39 s 8856/2018-10-29 16:00:07 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:07 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:00:07 CET LOG: 1 finished writing run 5 to tape 4: CPU: user: 72.43 s, system: 13.61 s, elapsed: 87.01 s 7280/2018-10-29 16:00:07 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:07 CET LOG: 1 finished writing run 5 to tape 4: CPU: user: 72.43 s, system: 13.61 s, elapsed: 87.01 s 8856/2018-10-29 16:00:07 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:07 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:00:07 CET LOG: 2 finished quicksort of run 5: CPU: user: 73.91 s, system: 12.30 s, elapsed: 87.45 s 2736/2018-10-29 16:00:07 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:07 CET LOG: 2 finished quicksort of run 5: CPU: user: 73.91 s, system: 12.30 s, elapsed: 87.45 s 8856/2018-10-29 16:00:07 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:07 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:00:09 CET LOG: 2 finished writing run 5 to tape 4: CPU: user: 74.86 s, system: 12.97 s, elapsed: 89.24 s 2736/2018-10-29 16:00:09 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:09 CET LOG: 2 finished writing run 5 to tape 4: CPU: user: 74.86 s, system: 12.97 s, elapsed: 89.24 s 8856/2018-10-29 16:00:09 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:09 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:13 CET LOG: 0 starting quicksort of run 6: CPU: user: 76.58 s, system: 14.97 s, elapsed: 92.67 s 8856/2018-10-29 16:00:13 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:00:13 CET LOG: 1 starting quicksort of run 6: CPU: user: 76.00 s, system: 15.63 s, elapsed: 92.86 s 7280/2018-10-29 16:00:13 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:13 CET LOG: 1 starting quicksort of run 6: CPU: user: 76.00 s, system: 15.63 s, elapsed: 92.86 s 8856/2018-10-29 16:00:13 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:13 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:00:15 CET LOG: 2 starting quicksort of run 6: CPU: user: 78.45 s, system: 14.63 s, elapsed: 94.66 s 2736/2018-10-29 16:00:15 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:15 CET LOG: 2 starting quicksort of run 6: CPU: user: 78.45 s, system: 14.63 s, elapsed: 94.66 s 8856/2018-10-29 16:00:15 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:15 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:24 CET LOG: 0 finished quicksort of run 6: CPU: user: 87.48 s, system: 14.99 s, elapsed: 103.58 s 8856/2018-10-29 16:00:24 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:00:24 CET LOG: 1 finished quicksort of run 6: CPU: user: 86.92 s, system: 15.63 s, elapsed: 103.80 s 7280/2018-10-29 16:00:24 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:25 CET LOG: 0 finished writing run 6 to tape 5: CPU: user: 88.20 s, system: 16.05 s, elapsed: 105.36 s 8856/2018-10-29 16:00:25 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:25 CET LOG: 1 finished quicksort of run 6: CPU: user: 86.92 s, system: 15.63 s, elapsed: 103.80 s 8856/2018-10-29 16:00:25 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:25 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:00:25 CET LOG: 1 finished writing run 6 to tape 5: CPU: user: 87.78 s, system: 16.39 s, elapsed: 105.42 s 7280/2018-10-29 16:00:25 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:25 CET LOG: 1 finished writing run 6 to tape 5: CPU: user: 87.78 s, system: 16.39 s, elapsed: 105.42 s 8856/2018-10-29 16:00:25 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:25 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:00:27 CET LOG: 2 finished quicksort of run 6: CPU: user: 90.60 s, system: 14.63 s, elapsed: 106.81 s 2736/2018-10-29 16:00:27 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:27 CET LOG: 2 finished quicksort of run 6: CPU: user: 90.60 s, system: 14.63 s, elapsed: 106.81 s 8856/2018-10-29 16:00:27 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:27 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:00:28 CET LOG: 2 finished writing run 6 to tape 5: CPU: user: 91.49 s, system: 15.35 s, elapsed: 108.42 s 2736/2018-10-29 16:00:28 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:28 CET LOG: 2 finished writing run 6 to tape 5: CPU: user: 91.49 s, system: 15.35 s, elapsed: 108.42 s 8856/2018-10-29 16:00:28 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:28 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:31 CET LOG: 0 starting quicksort of run 7: CPU: user: 91.86 s, system: 17.97 s, elapsed: 111.04 s 8856/2018-10-29 16:00:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:00:31 CET LOG: 1 starting quicksort of run 7: CPU: user: 91.43 s, system: 18.23 s, elapsed: 111.15 s 7280/2018-10-29 16:00:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:31 CET LOG: 1 starting quicksort of run 7: CPU: user: 91.43 s, system: 18.23 s, elapsed: 111.15 s 8856/2018-10-29 16:00:31 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:00:34 CET LOG: 2 starting quicksort of run 7: CPU: user: 95.14 s, system: 16.80 s, elapsed: 113.63 s 2736/2018-10-29 16:00:34 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:34 CET LOG: 2 starting quicksort of run 7: CPU: user: 95.14 s, system: 16.80 s, elapsed: 113.63 s 8856/2018-10-29 16:00:34 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:34 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:00:41 CET LOG: 1 finished quicksort of run 7: CPU: user: 101.79 s, system: 18.23 s, elapsed: 121.49 s 7280/2018-10-29 16:00:41 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:41 CET LOG: 1 finished quicksort of run 7: CPU: user: 101.79 s, system: 18.23 s, elapsed: 121.49 s 8856/2018-10-29 16:00:41 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:41 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:42 CET LOG: 0 finished quicksort of run 7: CPU: user: 102.96 s, system: 17.97 s, elapsed: 122.13 s 8856/2018-10-29 16:00:42 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:00:43 CET LOG: 1 finished writing run 7 to tape 6: CPU: user: 102.58 s, system: 18.96 s, elapsed: 123.02 s 7280/2018-10-29 16:00:43 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:44 CET LOG: 0 finished writing run 7 to tape 6: CPU: user: 103.77 s, system: 18.96 s, elapsed: 123.94 s 8856/2018-10-29 16:00:44 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:44 CET LOG: 1 finished writing run 7 to tape 6: CPU: user: 102.58 s, system: 18.96 s, elapsed: 123.02 s 8856/2018-10-29 16:00:44 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:44 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:00:45 CET LOG: 2 finished quicksort of run 7: CPU: user: 106.36 s, system: 16.80 s, elapsed: 124.84 s 2736/2018-10-29 16:00:45 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:45 CET LOG: 2 finished quicksort of run 7: CPU: user: 106.36 s, system: 16.80 s, elapsed: 124.84 s 8856/2018-10-29 16:00:45 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:45 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:00:46 CET LOG: 2 finished writing run 7 to tape 6: CPU: user: 107.23 s, system: 17.58 s, elapsed: 126.50 s 2736/2018-10-29 16:00:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:46 CET LOG: 2 finished writing run 7 to tape 6: CPU: user: 107.23 s, system: 17.58 s, elapsed: 126.50 s 8856/2018-10-29 16:00:46 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:46 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:00:49 CET LOG: 1 starting quicksort of run 8: CPU: user: 106.15 s, system: 20.87 s, elapsed: 128.68 s 7280/2018-10-29 16:00:49 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:49 CET LOG: 1 starting quicksort of run 8: CPU: user: 106.15 s, system: 20.87 s, elapsed: 128.68 s 8856/2018-10-29 16:00:49 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:49 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:50 CET LOG: 0 starting quicksort of run 8: CPU: user: 107.50 s, system: 20.73 s, elapsed: 129.63 s 8856/2018-10-29 16:00:50 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:00:52 CET LOG: 2 starting quicksort of run 8: CPU: user: 110.90 s, system: 19.09 s, elapsed: 131.74 s 2736/2018-10-29 16:00:52 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:52 CET LOG: 2 starting quicksort of run 8: CPU: user: 110.90 s, system: 19.09 s, elapsed: 131.74 s 8856/2018-10-29 16:00:52 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:52 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:00:59 CET LOG: 1 finished quicksort of run 8: CPU: user: 116.12 s, system: 20.87 s, elapsed: 138.65 s 7280/2018-10-29 16:00:59 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:00:59 CET LOG: 1 finished quicksort of run 8: CPU: user: 116.12 s, system: 20.87 s, elapsed: 138.65 s 8856/2018-10-29 16:00:59 CET CONTEXT: parallel worker 8856/2018-10-29 16:00:59 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:00 CET LOG: 0 finished quicksort of run 8: CPU: user: 117.93 s, system: 20.73 s, elapsed: 140.07 s 8856/2018-10-29 16:01:00 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:01:00 CET LOG: 1 finished writing run 8 to tape 7: CPU: user: 116.92 s, system: 21.51 s, elapsed: 140.08 s 7280/2018-10-29 16:01:00 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:02 CET LOG: 0 finished writing run 8 to tape 7: CPU: user: 118.63 s, system: 21.74 s, elapsed: 141.78 s 8856/2018-10-29 16:01:02 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:02 CET LOG: 1 finished writing run 8 to tape 7: CPU: user: 116.92 s, system: 21.51 s, elapsed: 140.08 s 8856/2018-10-29 16:01:02 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:02 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:01:02 CET LOG: 2 finished quicksort of run 8: CPU: user: 121.50 s, system: 19.09 s, elapsed: 142.35 s 2736/2018-10-29 16:01:02 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:02 CET LOG: 2 finished quicksort of run 8: CPU: user: 121.50 s, system: 19.09 s, elapsed: 142.35 s 8856/2018-10-29 16:01:02 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:02 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:01:04 CET LOG: 2 finished writing run 8 to tape 7: CPU: user: 122.21 s, system: 20.04 s, elapsed: 144.00 s 2736/2018-10-29 16:01:04 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:04 CET LOG: 2 finished writing run 8 to tape 7: CPU: user: 122.21 s, system: 20.04 s, elapsed: 144.00 s 8856/2018-10-29 16:01:04 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:04 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:01:05 CET LOG: 1 starting quicksort of run 9: CPU: user: 120.76 s, system: 22.93 s, elapsed: 145.39 s 7280/2018-10-29 16:01:05 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:05 CET LOG: 1 starting quicksort of run 9: CPU: user: 120.76 s, system: 22.93 s, elapsed: 145.39 s 8856/2018-10-29 16:01:05 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:05 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:07 CET LOG: 0 starting quicksort of run 9: CPU: user: 122.36 s, system: 23.47 s, elapsed: 147.31 s 8856/2018-10-29 16:01:07 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:01:09 CET LOG: 2 starting quicksort of run 9: CPU: user: 125.84 s, system: 21.49 s, elapsed: 149.18 s 2736/2018-10-29 16:01:09 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:09 CET LOG: 2 starting quicksort of run 9: CPU: user: 125.84 s, system: 21.49 s, elapsed: 149.18 s 8856/2018-10-29 16:01:09 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:09 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:01:15 CET LOG: 1 finished quicksort of run 9: CPU: user: 130.10 s, system: 22.93 s, elapsed: 154.73 s 7280/2018-10-29 16:01:15 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:15 CET LOG: 1 finished quicksort of run 9: CPU: user: 130.10 s, system: 22.93 s, elapsed: 154.73 s 8856/2018-10-29 16:01:15 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:15 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:01:16 CET LOG: 1 finished writing run 9 to tape 8: CPU: user: 130.69 s, system: 23.69 s, elapsed: 156.09 s 7280/2018-10-29 16:01:16 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:16 CET LOG: 1 finished writing run 9 to tape 8: CPU: user: 130.69 s, system: 23.69 s, elapsed: 156.09 s 8856/2018-10-29 16:01:16 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:16 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:17 CET LOG: 0 finished quicksort of run 9: CPU: user: 132.47 s, system: 23.47 s, elapsed: 157.41 s 8856/2018-10-29 16:01:17 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:01:19 CET LOG: 2 finished quicksort of run 9: CPU: user: 135.54 s, system: 21.49 s, elapsed: 158.88 s 2736/2018-10-29 16:01:19 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:19 CET LOG: 0 finished writing run 9 to tape 8: CPU: user: 133.20 s, system: 24.33 s, elapsed: 159.01 s 8856/2018-10-29 16:01:19 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:19 CET LOG: 2 finished quicksort of run 9: CPU: user: 135.54 s, system: 21.49 s, elapsed: 158.88 s 8856/2018-10-29 16:01:19 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:19 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:01:21 CET LOG: 2 finished writing run 9 to tape 8: CPU: user: 136.28 s, system: 22.44 s, elapsed: 160.57 s 2736/2018-10-29 16:01:21 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:21 CET LOG: 2 finished writing run 9 to tape 8: CPU: user: 136.28 s, system: 22.44 s, elapsed: 160.57 s 8856/2018-10-29 16:01:21 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:21 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:01:21 CET LOG: 1 starting quicksort of run 10: CPU: user: 134.42 s, system: 24.99 s, elapsed: 161.13 s 7280/2018-10-29 16:01:21 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:21 CET LOG: 1 starting quicksort of run 10: CPU: user: 134.42 s, system: 24.99 s, elapsed: 161.13 s 8856/2018-10-29 16:01:21 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:21 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:24 CET LOG: 0 starting quicksort of run 10: CPU: user: 137.04 s, system: 26.00 s, elapsed: 164.53 s 8856/2018-10-29 16:01:24 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:01:26 CET LOG: 2 starting quicksort of run 10: CPU: user: 139.88 s, system: 24.00 s, elapsed: 165.79 s 2736/2018-10-29 16:01:26 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:26 CET LOG: 2 starting quicksort of run 10: CPU: user: 139.88 s, system: 24.00 s, elapsed: 165.79 s 8856/2018-10-29 16:01:26 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:26 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:01:31 CET LOG: 1 finished quicksort of run 10: CPU: user: 144.12 s, system: 24.99 s, elapsed: 170.83 s 7280/2018-10-29 16:01:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:31 CET LOG: 1 finished quicksort of run 10: CPU: user: 144.12 s, system: 24.99 s, elapsed: 170.83 s 8856/2018-10-29 16:01:31 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:01:32 CET LOG: 1 finished writing run 10 to tape 9: CPU: user: 144.83 s, system: 25.69 s, elapsed: 172.23 s 7280/2018-10-29 16:01:32 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:32 CET LOG: 1 finished writing run 10 to tape 9: CPU: user: 144.83 s, system: 25.69 s, elapsed: 172.23 s 8856/2018-10-29 16:01:32 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:32 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:36 CET LOG: 0 finished quicksort of run 10: CPU: user: 148.09 s, system: 26.00 s, elapsed: 175.57 s 8856/2018-10-29 16:01:36 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:01:36 CET LOG: 2 finished quicksort of run 10: CPU: user: 150.11 s, system: 24.00 s, elapsed: 176.03 s 2736/2018-10-29 16:01:36 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:01:37 CET LOG: 1 starting quicksort of run 11: CPU: user: 148.32 s, system: 26.89 s, elapsed: 176.93 s 7280/2018-10-29 16:01:37 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:37 CET LOG: 0 finished writing run 10 to tape 9: CPU: user: 149.04 s, system: 26.69 s, elapsed: 177.21 s 8856/2018-10-29 16:01:37 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:37 CET LOG: 2 finished quicksort of run 10: CPU: user: 150.11 s, system: 24.00 s, elapsed: 176.03 s 8856/2018-10-29 16:01:37 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:37 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:37 CET LOG: 1 starting quicksort of run 11: CPU: user: 148.32 s, system: 26.89 s, elapsed: 176.93 s 8856/2018-10-29 16:01:37 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:37 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:01:38 CET LOG: 2 finished writing run 10 to tape 9: CPU: user: 150.93 s, system: 24.85 s, elapsed: 177.68 s 2736/2018-10-29 16:01:38 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:38 CET LOG: 2 finished writing run 10 to tape 9: CPU: user: 150.93 s, system: 24.85 s, elapsed: 177.68 s 8856/2018-10-29 16:01:38 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:38 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:42 CET LOG: 0 starting quicksort of run 11: CPU: user: 152.52 s, system: 28.42 s, elapsed: 182.45 s 8856/2018-10-29 16:01:42 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:01:43 CET LOG: 2 starting quicksort of run 11: CPU: user: 154.28 s, system: 26.64 s, elapsed: 182.92 s 2736/2018-10-29 16:01:43 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:43 CET LOG: 2 starting quicksort of run 11: CPU: user: 154.28 s, system: 26.64 s, elapsed: 182.92 s 8856/2018-10-29 16:01:43 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:43 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:01:47 CET LOG: 1 finished quicksort of run 11: CPU: user: 158.55 s, system: 26.89 s, elapsed: 187.16 s 7280/2018-10-29 16:01:47 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:47 CET LOG: 1 finished quicksort of run 11: CPU: user: 158.55 s, system: 26.89 s, elapsed: 187.16 s 8856/2018-10-29 16:01:47 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:47 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:01:49 CET LOG: 1 finished writing run 11 to tape 10: CPU: user: 159.19 s, system: 27.64 s, elapsed: 188.55 s 7280/2018-10-29 16:01:49 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:49 CET LOG: 1 finished writing run 11 to tape 10: CPU: user: 159.19 s, system: 27.64 s, elapsed: 188.55 s 8856/2018-10-29 16:01:49 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:49 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:53 CET LOG: 0 finished quicksort of run 11: CPU: user: 162.92 s, system: 28.42 s, elapsed: 192.86 s 8856/2018-10-29 16:01:53 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:01:53 CET LOG: 1 starting quicksort of run 12: CPU: user: 162.77 s, system: 28.65 s, elapsed: 193.14 s 7280/2018-10-29 16:01:53 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:01:54 CET LOG: 2 finished quicksort of run 11: CPU: user: 165.17 s, system: 26.64 s, elapsed: 193.81 s 2736/2018-10-29 16:01:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:54 CET LOG: 0 finished writing run 11 to tape 10: CPU: user: 163.83 s, system: 29.10 s, elapsed: 194.45 s 8856/2018-10-29 16:01:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:54 CET LOG: 2 finished quicksort of run 11: CPU: user: 165.17 s, system: 26.64 s, elapsed: 193.81 s 8856/2018-10-29 16:01:54 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:54 CET LOG: 1 starting quicksort of run 12: CPU: user: 162.77 s, system: 28.65 s, elapsed: 193.14 s 8856/2018-10-29 16:01:54 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:01:55 CET LOG: 2 finished writing run 11 to tape 10: CPU: user: 166.21 s, system: 27.26 s, elapsed: 195.48 s 2736/2018-10-29 16:01:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:01:55 CET LOG: 2 finished writing run 11 to tape 10: CPU: user: 166.21 s, system: 27.26 s, elapsed: 195.48 s 8856/2018-10-29 16:01:55 CET CONTEXT: parallel worker 8856/2018-10-29 16:01:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:00 CET LOG: 0 starting quicksort of run 12: CPU: user: 167.54 s, system: 30.49 s, elapsed: 199.61 s 8856/2018-10-29 16:02:00 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:01 CET LOG: 2 starting quicksort of run 12: CPU: user: 169.88 s, system: 28.65 s, elapsed: 200.58 s 2736/2018-10-29 16:02:01 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:01 CET LOG: 2 starting quicksort of run 12: CPU: user: 169.88 s, system: 28.65 s, elapsed: 200.58 s 8856/2018-10-29 16:02:01 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:01 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:03 CET LOG: 1 finished quicksort of run 12: CPU: user: 172.72 s, system: 28.65 s, elapsed: 203.09 s 7280/2018-10-29 16:02:03 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:03 CET LOG: 1 finished quicksort of run 12: CPU: user: 172.72 s, system: 28.65 s, elapsed: 203.09 s 8856/2018-10-29 16:02:03 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:03 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:05 CET LOG: 1 finished writing run 12 to tape 11: CPU: user: 173.55 s, system: 29.26 s, elapsed: 204.53 s 7280/2018-10-29 16:02:05 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:05 CET LOG: 1 finished writing run 12 to tape 11: CPU: user: 173.55 s, system: 29.26 s, elapsed: 204.53 s 8856/2018-10-29 16:02:05 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:05 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:09 CET LOG: 1 starting quicksort of run 13: CPU: user: 177.04 s, system: 30.32 s, elapsed: 209.08 s 7280/2018-10-29 16:02:09 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:09 CET LOG: 1 starting quicksort of run 13: CPU: user: 177.04 s, system: 30.32 s, elapsed: 209.08 s 8856/2018-10-29 16:02:09 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:09 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:11 CET LOG: 0 finished quicksort of run 12: CPU: user: 178.51 s, system: 30.49 s, elapsed: 210.58 s 8856/2018-10-29 16:02:11 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:12 CET LOG: 2 finished quicksort of run 12: CPU: user: 181.41 s, system: 28.65 s, elapsed: 212.11 s 2736/2018-10-29 16:02:12 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:12 CET LOG: 0 finished writing run 12 to tape 11: CPU: user: 179.29 s, system: 31.34 s, elapsed: 212.20 s 8856/2018-10-29 16:02:12 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:12 CET LOG: 2 finished quicksort of run 12: CPU: user: 181.41 s, system: 28.65 s, elapsed: 212.11 s 8856/2018-10-29 16:02:12 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:12 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:14 CET LOG: 2 finished writing run 12 to tape 11: CPU: user: 182.34 s, system: 29.43 s, elapsed: 213.89 s 2736/2018-10-29 16:02:14 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:14 CET LOG: 2 finished writing run 12 to tape 11: CPU: user: 182.34 s, system: 29.43 s, elapsed: 213.89 s 8856/2018-10-29 16:02:14 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:14 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:17 CET LOG: 0 starting quicksort of run 13: CPU: user: 183.05 s, system: 32.74 s, elapsed: 217.40 s 8856/2018-10-29 16:02:17 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:19 CET LOG: 2 starting quicksort of run 13: CPU: user: 185.98 s, system: 30.85 s, elapsed: 218.97 s 2736/2018-10-29 16:02:19 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:19 CET LOG: 2 starting quicksort of run 13: CPU: user: 185.98 s, system: 30.85 s, elapsed: 218.97 s 8856/2018-10-29 16:02:19 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:19 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:20 CET LOG: 1 finished quicksort of run 13: CPU: user: 187.95 s, system: 30.32 s, elapsed: 219.99 s 7280/2018-10-29 16:02:20 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:20 CET LOG: 1 finished quicksort of run 13: CPU: user: 187.95 s, system: 30.32 s, elapsed: 219.99 s 8856/2018-10-29 16:02:20 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:20 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:21 CET LOG: 1 finished writing run 13 to tape 12: CPU: user: 188.77 s, system: 30.96 s, elapsed: 221.45 s 7280/2018-10-29 16:02:21 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:21 CET LOG: 1 finished writing run 13 to tape 12: CPU: user: 188.77 s, system: 30.96 s, elapsed: 221.45 s 8856/2018-10-29 16:02:21 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:21 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:26 CET LOG: 1 starting quicksort of run 14: CPU: user: 192.52 s, system: 31.76 s, elapsed: 225.99 s 7280/2018-10-29 16:02:26 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:26 CET LOG: 1 starting quicksort of run 14: CPU: user: 192.52 s, system: 31.76 s, elapsed: 225.99 s 8856/2018-10-29 16:02:26 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:26 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:30 CET LOG: 0 finished quicksort of run 13: CPU: user: 195.43 s, system: 32.74 s, elapsed: 229.78 s 8856/2018-10-29 16:02:30 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:31 CET LOG: 2 finished quicksort of run 13: CPU: user: 197.76 s, system: 30.85 s, elapsed: 230.75 s 2736/2018-10-29 16:02:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:31 CET LOG: 0 finished writing run 13 to tape 12: CPU: user: 196.37 s, system: 33.47 s, elapsed: 231.45 s 8856/2018-10-29 16:02:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:31 CET LOG: 2 finished quicksort of run 13: CPU: user: 197.76 s, system: 30.85 s, elapsed: 230.75 s 8856/2018-10-29 16:02:31 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:31 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:33 CET LOG: 2 finished writing run 13 to tape 12: CPU: user: 198.83 s, system: 31.57 s, elapsed: 232.54 s 2736/2018-10-29 16:02:33 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:33 CET LOG: 2 finished writing run 13 to tape 12: CPU: user: 198.83 s, system: 31.57 s, elapsed: 232.54 s 8856/2018-10-29 16:02:33 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:33 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:36 CET LOG: 1 finished quicksort of run 14: CPU: user: 202.84 s, system: 31.76 s, elapsed: 236.32 s 7280/2018-10-29 16:02:36 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:36 CET LOG: 1 finished quicksort of run 14: CPU: user: 202.84 s, system: 31.76 s, elapsed: 236.32 s 8856/2018-10-29 16:02:36 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:36 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:37 CET LOG: 0 starting quicksort of run 14: CPU: user: 200.02 s, system: 34.99 s, elapsed: 236.68 s 8856/2018-10-29 16:02:37 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:38 CET LOG: 1 finished writing run 14 to tape 13: CPU: user: 203.72 s, system: 32.35 s, elapsed: 237.79 s 7280/2018-10-29 16:02:38 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:38 CET LOG: 1 finished writing run 14 to tape 13: CPU: user: 203.72 s, system: 32.35 s, elapsed: 237.79 s 8856/2018-10-29 16:02:38 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:38 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:38 CET LOG: 2 starting quicksort of run 14: CPU: user: 202.48 s, system: 33.08 s, elapsed: 237.83 s 2736/2018-10-29 16:02:38 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:38 CET LOG: 2 starting quicksort of run 14: CPU: user: 202.48 s, system: 33.08 s, elapsed: 237.83 s 8856/2018-10-29 16:02:38 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:38 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:42 CET LOG: 1 starting quicksort of run 15: CPU: user: 207.21 s, system: 33.38 s, elapsed: 242.31 s 7280/2018-10-29 16:02:42 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:42 CET LOG: 1 starting quicksort of run 15: CPU: user: 207.21 s, system: 33.38 s, elapsed: 242.31 s 8856/2018-10-29 16:02:42 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:42 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:47 CET LOG: 0 finished quicksort of run 14: CPU: user: 210.21 s, system: 34.99 s, elapsed: 246.87 s 8856/2018-10-29 16:02:47 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:48 CET LOG: 2 finished quicksort of run 14: CPU: user: 212.91 s, system: 33.08 s, elapsed: 248.25 s 2736/2018-10-29 16:02:48 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:48 CET LOG: 0 finished writing run 14 to tape 13: CPU: user: 210.92 s, system: 35.83 s, elapsed: 248.43 s 8856/2018-10-29 16:02:48 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:48 CET LOG: 2 finished quicksort of run 14: CPU: user: 212.91 s, system: 33.08 s, elapsed: 248.25 s 8856/2018-10-29 16:02:48 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:48 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:50 CET LOG: 2 finished writing run 14 to tape 13: CPU: user: 213.75 s, system: 33.94 s, elapsed: 249.95 s 2736/2018-10-29 16:02:50 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:50 CET LOG: 2 finished writing run 14 to tape 13: CPU: user: 213.75 s, system: 33.94 s, elapsed: 249.95 s 8856/2018-10-29 16:02:50 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:50 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:50 CET LOG: performsort of 0 starting: CPU: user: 212.41 s, system: 36.28 s, elapsed: 250.36 s 8856/2018-10-29 16:02:50 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:50 CET LOG: performsort of 2 starting: CPU: user: 214.04 s, system: 34.02 s, elapsed: 250.33 s 2736/2018-10-29 16:02:50 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:50 CET LOG: 0 starting quicksort of run 15: CPU: user: 212.41 s, system: 36.28 s, elapsed: 250.36 s 8856/2018-10-29 16:02:50 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:50 CET LOG: 2 starting quicksort of run 15: CPU: user: 214.04 s, system: 34.02 s, elapsed: 250.33 s 2736/2018-10-29 16:02:50 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:50 CET LOG: performsort of 2 starting: CPU: user: 214.04 s, system: 34.02 s, elapsed: 250.33 s 8856/2018-10-29 16:02:50 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:50 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:50 CET LOG: 2 starting quicksort of run 15: CPU: user: 214.04 s, system: 34.02 s, elapsed: 250.33 s 8856/2018-10-29 16:02:50 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:50 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:51 CET LOG: 2 finished quicksort of run 15: CPU: user: 214.61 s, system: 34.02 s, elapsed: 250.89 s 2736/2018-10-29 16:02:51 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:51 CET LOG: 2 finished quicksort of run 15: CPU: user: 214.61 s, system: 34.02 s, elapsed: 250.89 s 8856/2018-10-29 16:02:51 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:51 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:51 CET LOG: 2 finished writing run 15 to tape 14: CPU: user: 214.65 s, system: 34.08 s, elapsed: 251.00 s 2736/2018-10-29 16:02:51 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:51 CET LOG: 2 finished writing run 15 to tape 14: CPU: user: 214.65 s, system: 34.08 s, elapsed: 251.00 s 8856/2018-10-29 16:02:51 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:51 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:02:51 CET LOG: 2 using 698564 KB of memory for read buffers among 15 input tapes 2736/2018-10-29 16:02:51 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:51 CET LOG: 2 using 698564 KB of memory for read buffers among 15 input tapes 8856/2018-10-29 16:02:51 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:51 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:53 CET LOG: 1 finished quicksort of run 15: CPU: user: 217.48 s, system: 33.38 s, elapsed: 252.58 s 7280/2018-10-29 16:02:53 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:53 CET LOG: 1 finished quicksort of run 15: CPU: user: 217.48 s, system: 33.38 s, elapsed: 252.58 s 8856/2018-10-29 16:02:53 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:53 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:54 CET LOG: 1 finished writing run 15 to tape 14: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s 7280/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:54 CET LOG: performsort of 1 starting: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s 7280/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:54 CET LOG: 1 finished writing run 15 to tape 14: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s 8856/2018-10-29 16:02:54 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:54 CET LOG: performsort of 1 starting: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s 8856/2018-10-29 16:02:54 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:54 CET LOG: 1 starting quicksort of run 16: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s 7280/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:54 CET LOG: 1 finished quicksort of run 16: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s 7280/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:54 CET LOG: 1 starting quicksort of run 16: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s 8856/2018-10-29 16:02:54 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:54 CET LOG: 1 finished quicksort of run 16: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s 8856/2018-10-29 16:02:54 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:54 CET LOG: 1 finished writing run 16 to tape 15: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s 7280/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:54 CET LOG: 1 finished writing run 16 to tape 15: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s 8856/2018-10-29 16:02:54 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:02:54 CET LOG: 1 using 698555 KB of memory for read buffers among 16 input tapes 7280/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:54 CET LOG: 1 using 698555 KB of memory for read buffers among 16 input tapes 8856/2018-10-29 16:02:54 CET CONTEXT: parallel worker 8856/2018-10-29 16:02:54 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:55 CET LOG: 0 finished quicksort of run 15: CPU: user: 216.68 s, system: 36.28 s, elapsed: 254.63 s 8856/2018-10-29 16:02:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:55 CET LOG: 0 finished writing run 15 to tape 14: CPU: user: 217.05 s, system: 36.61 s, elapsed: 255.34 s 8856/2018-10-29 16:02:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:02:55 CET LOG: 0 using 698564 KB of memory for read buffers among 15 input tapes 8856/2018-10-29 16:02:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:03:28 CET LOG: 2 finished 15-way merge step: CPU: user: 240.78 s, system: 44.70 s, elapsed: 287.75 s 2736/2018-10-29 16:03:28 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:28 CET LOG: 2 finished 15-way merge step: CPU: user: 240.78 s, system: 44.70 s, elapsed: 287.75 s 8856/2018-10-29 16:03:28 CET CONTEXT: parallel worker 8856/2018-10-29 16:03:28 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:03:28 CET LOG: performsort of 2 done: CPU: user: 240.78 s, system: 44.81 s, elapsed: 287.86 s 2736/2018-10-29 16:03:28 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:28 CET LOG: performsort of 2 done: CPU: user: 240.78 s, system: 44.81 s, elapsed: 287.86 s 8856/2018-10-29 16:03:28 CET CONTEXT: parallel worker 8856/2018-10-29 16:03:28 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 2736/2018-10-29 16:03:32 CET LOG: parallel external sort of 2 ended, 435256 disk blocks used: CPU: user: 240.78 s, system: 44.81 s, elapsed: 291.58 s 2736/2018-10-29 16:03:32 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:32 CET LOG: parallel external sort of 2 ended, 435256 disk blocks used: CPU: user: 240.78 s, system: 44.81 s, elapsed: 291.58 s 8856/2018-10-29 16:03:32 CET CONTEXT: parallel worker 8856/2018-10-29 16:03:32 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:03:33 CET LOG: 1 finished 16-way merge step: CPU: user: 244.85 s, system: 46.41 s, elapsed: 292.99 s 7280/2018-10-29 16:03:33 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:33 CET LOG: 1 finished 16-way merge step: CPU: user: 244.85 s, system: 46.41 s, elapsed: 292.99 s 8856/2018-10-29 16:03:33 CET CONTEXT: parallel worker 8856/2018-10-29 16:03:33 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:33 CET LOG: 0 finished 15-way merge step: CPU: user: 243.68 s, system: 47.67 s, elapsed: 293.06 s 8856/2018-10-29 16:03:33 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:03:33 CET LOG: performsort of 1 done: CPU: user: 244.85 s, system: 46.55 s, elapsed: 293.14 s 7280/2018-10-29 16:03:33 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:33 CET LOG: performsort of 0 done: CPU: user: 243.68 s, system: 47.81 s, elapsed: 293.20 s 8856/2018-10-29 16:03:33 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 7280/2018-10-29 16:03:39 CET LOG: parallel external sort of 1 ended, 463964 disk blocks used: CPU: user: 244.85 s, system: 46.55 s, elapsed: 299.38 s 7280/2018-10-29 16:03:39 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:55 CET LOG: parallel external sort of 0 ended, 445285 disk blocks used: CPU: user: 243.68 s, system: 47.82 s, elapsed: 314.96 s 8856/2018-10-29 16:03:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:55 CET LOG: performsort of 1 done: CPU: user: 244.85 s, system: 46.55 s, elapsed: 293.14 s 8856/2018-10-29 16:03:55 CET CONTEXT: parallel worker 8856/2018-10-29 16:03:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:55 CET LOG: parallel external sort of 1 ended, 463964 disk blocks used: CPU: user: 244.85 s, system: 46.55 s, elapsed: 299.38 s 8856/2018-10-29 16:03:55 CET CONTEXT: parallel worker 8856/2018-10-29 16:03:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:55 CET LOG: begin index sort: unique = f, workMem = 2096128, randomAccess = f 8856/2018-10-29 16:03:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:55 CET LOG: performsort of -1 starting: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 8856/2018-10-29 16:03:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:03:55 CET ERROR: could not determine size of temporary file "0" 8856/2018-10-29 16:03:55 CET STATEMENT: CREATE INDEX kenweg_cidx ON complete.chainusers USING btree (categ); 8856/2018-10-29 16:04:41 CET LOG: could not rmdir directory "base/pgsql_tmp/pgsql_tmp8856.2.sharedfileset": Directory not empty