QEP 1.

S00T00:trace: (Result <time 373792.406250, deliver 373774.406250, rows 10> 
S00T00:trace:   (AggPlan <time 373783.406250, deliver 373774.406250, rows 10> 
S00T00:trace:     (NestLoop <time 191280.500000, deliver 12.390090, rows 202771> 
S00T00:trace:       (NestLoop <time 8763.000000, deliver 11.446814, rows 961> 
S00T00:trace:         (ScanExpr <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:           (SubQueryPlan <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:             (Distinct <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:               (Sort <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:                 (NestLoop <time 2818.699707, deliver 86.269852, rows 98> 
S00T00:trace:                   (HashJoin <time 1938.699951, deliver 56.940468, rows 81> 
S00T00:trace:                     (NestLoop <time 1857.000000, deliver 24.618473, rows 81> 
S00T00:trace:                       (SeqScan <time 1130.599976, deliver 1.423929, rows 794> BigSurDataObject)
S00T00:trace:                       (IndexScan <time 25.500000, deliver 0.289773, rows 88> BigSurAssoc_ndx1)
S00T00:trace:                     )
S00T00:trace:                     (Hash <time 8.800000, deliver 8.800000, rows 2> 
S00T00:trace:                       (SeqScan <time 7.000000, deliver 3.500000, rows 2> CellResolution)
S00T00:trace:                     )
S00T00:trace:                   )
S00T00:trace:                   (UnionPlan <time 18.600000, deliver 1.160000, rows 12> 
S00T00:trace:                     (SeqScan <time 11.600000, deliver 1.160000, rows 10> CellValue)
S00T00:trace: 
S00T00:trace:                     (SeqScan <time 7.000000, deliver 3.500000, rows 2> GCMVariable)
S00T00:trace:                   )
S00T00:trace:                 )
S00T00:trace:               )
S00T00:trace:             ))
S00T00:trace:         )
S00T00:trace:         (Material <time 3664.887207, deliver 3576.687256, rows 98> 
S00T00:trace:           (ScanExpr <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:             (SubQueryPlan <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:               (Distinct <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:                 (Sort <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:                   (NestLoop <time 2818.699707, deliver 86.269852, rows 98> 
S00T00:trace:                     (HashJoin <time 1938.699951, deliver 56.940468, rows 81> 
S00T00:trace:                       (NestLoop <time 1857.000000, deliver 24.618473, rows 81> 
S00T00:trace:                         (SeqScan <time 1130.599976, deliver 1.423929, rows 794> BigSurDataObject)
S00T00:trace:                         (IndexScan <time 25.500000, deliver 0.289773, rows 88> BigSurAssoc_ndx1)
S00T00:trace:                       )
S00T00:trace:                       (Hash <time 8.800000, deliver 8.800000, rows 2> 
S00T00:trace:                         (SeqScan <time 7.000000, deliver 3.500000, rows 2> CellResolution)
S00T00:trace:                       )
S00T00:trace:                     )
S00T00:trace:                     (UnionPlan <time 18.600000, deliver 1.160000, rows 12> 
S00T00:trace:                       (SeqScan <time 11.600000, deliver 1.160000, rows 10> CellValue)
S00T00:trace: 
S00T00:trace:                       (SeqScan <time 7.000000, deliver 3.500000, rows 2> GCMVariable)
S00T00:trace:                     )
S00T00:trace:                   )
S00T00:trace:                 )
S00T00:trace:               ))
S00T00:trace:           )
S00T00:trace:         )
S00T00:trace:       )
S00T00:trace:       (IndexScan <time 0.000000, deliver 0.000000, rows 211> Integer_ndx1)
S00T00:trace:     )
S00T00:trace:   )
S00T00:trace: ) 

  QEP 2.

S00T00:trace: Query is:  select * from Reference.SigVars('Landover3');
S00T00:trace: Plan is:
S00T00:trace: (ScanExpr <time 3276004.000000, deliver 3275986.000000, rows 10> 
S00T00:trace:   (SubQueryPlan <time 3276004.000000, deliver 3275986.000000, rows 10> 
S00T00:trace:     (Result <time 3276004.000000, deliver 3275986.000000, rows 10> 
S00T00:trace:       (AggPlan <time 3275995.000000, deliver 3275986.000000, rows 10> 
S00T00:trace:         (NestLoop <time 3215443.000000, deliver 2462.558594, rows 67270> 
S00T00:trace:           (NestLoop <time 8763.000000, deliver 11.446814, rows 961> 
S00T00:trace:             (ScanExpr <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:               (SubQueryPlan <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:                 (Distinct <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:                   (Sort <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:                     (NestLoop <time 2818.699707, deliver 86.269852, rows 98> 
S00T00:trace:                       (HashJoin <time 1938.699951, deliver 56.940468, rows 81> 
S00T00:trace:                         (NestLoop <time 1857.000000, deliver 24.618473, rows 81> 
S00T00:trace:                           (SeqScan <time 1130.599976, deliver 1.423929, rows 794> BigSurDataObject)
S00T00:trace:                           (IndexScan <time 25.500000, deliver 0.289773, rows 88> BigSurAssoc_ndx1)
S00T00:trace:                         )
S00T00:trace:                         (Hash <time 8.800000, deliver 8.800000, rows 2> 
S00T00:trace:                           (SeqScan <time 7.000000, deliver 3.500000, rows 2> CellResolution)
S00T00:trace:                         )
S00T00:trace:                       )
S00T00:trace:                       (UnionPlan <time 18.600000, deliver 1.160000, rows 12> 
S00T00:trace:                         (SeqScan <time 11.600000, deliver 1.160000, rows 10> CellValue)
S00T00:trace: 
S00T00:trace:                         (SeqScan <time 7.000000, deliver 3.500000, rows 2> GCMVariable)
S00T00:trace:                       )
S00T00:trace:                     )
S00T00:trace:                   )
S00T00:trace:                 ))
S00T00:trace:             )
S00T00:trace:             (Material <time 3664.887207, deliver 3576.687256, rows 98> 
S00T00:trace:               (ScanExpr <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:                 (SubQueryPlan <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:                   (Distinct <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:                     (Sort <time 3576.687256, deliver 3488.487305, rows 98> 
S00T00:trace:                       (NestLoop <time 2818.699707, deliver 86.269852, rows 98> 
S00T00:trace:                         (HashJoin <time 1938.699951, deliver 56.940468, rows 81> 
S00T00:trace:                           (NestLoop <time 1857.000000, deliver 24.618473, rows 81> 
S00T00:trace:                             (SeqScan <time 1130.599976, deliver 1.423929, rows 794> BigSurDataObject)
S00T00:trace:                             (IndexScan <time 25.500000, deliver 0.289773, rows 88> BigSurAssoc_ndx1)
S00T00:trace:                           )
S00T00:trace:                           (Hash <time 8.800000, deliver 8.800000, rows 2> 
S00T00:trace:                             (SeqScan <time 7.000000, deliver 3.500000, rows 2> CellResolution)
S00T00:trace:                           )
S00T00:trace:                         )
S00T00:trace:                         (UnionPlan <time 18.600000, deliver 1.160000, rows 12> 
S00T00:trace:                           (SeqScan <time 11.600000, deliver 1.160000, rows 10> CellValue)
S00T00:trace: 
S00T00:trace:                           (SeqScan <time 7.000000, deliver 3.500000, rows 2> GCMVariable)
S00T00:trace:                         )
S00T00:trace:                       )
S00T00:trace:                     )
S00T00:trace:                   ))
S00T00:trace:               )
S00T00:trace:             )
S00T00:trace:           )
S00T00:trace:           (SeqScan <time 926.000000, deliver 1.324750, rows 699> Integers)
S00T00:trace:         
S00T00:trace:           ->(SubQueryPlan <time 2436.799561, deliver 2434.999756, rows 1> 
S00T00:trace:             (Result <time 2436.799561, deliver 2434.999756, rows 1> 
S00T00:trace:               (AggPlan <time 2435.899658, deliver 2434.999756, rows 1> 
S00T00:trace:                 (HashJoin <time 2331.499756, deliver 306.063080, rows 115> 
S00T00:trace:                   (HashJoin <time 2107.899902, deliver 214.096069, rows 166> 
S00T00:trace:                     (NestLoop <time 1857.000000, deliver 24.618473, rows 81> 
S00T00:trace:                       (SeqScan <time 1130.599976, deliver 1.423929, rows 794> BigSurDataObject)
S00T00:trace:                       (IndexScan <time 25.500000, deliver 0.289773, rows 88> BigSurAssoc_ndx1)
S00T00:trace:                     )
S00T00:trace:                     (Hash <time 178.000000, deliver 178.000000, rows 96> 
S00T00:trace:                       (SeqScan <time 91.599998, deliver 0.954167, rows 96> GridAxisRes)
S00T00:trace:                     )
S00T00:trace:                   )
S00T00:trace:                   (Hash <time 74.200005, deliver 74.200005, rows 7> 
S00T00:trace:                     (UnionPlan <time 67.900002, deliver 8.950000, rows 7> 
S00T00:trace:                       (SeqScan <time 53.700001, deliver 8.950000, rows 6> BigSurAxis)
S00T00:trace: 
S00T00:trace:                       (SeqScan <time 14.200000, deliver 14.200000, rows 1> GCMAxis)
S00T00:trace:                     )
S00T00:trace:                   )
S00T00:trace:                 )
S00T00:trace:               )
S00T00:trace:             ))<-
S00T00:trace:         )

Interrupt

S00T00:trace:       )
S00T00:trace:     ))
S00T00:trace: )