Append  (cost=407.63..477.50 rows=101 width=8) (actual time=41.090..42804.152 rows=47302 loops=1)
  CTE t
    ->  Recursive Union  (cost=3.98..407.63 rows=101 width=8) (actual time=41.086..42719.839 rows=47303 loops=1)
          ->  Result  (cost=3.98..3.99 rows=1 width=0) (actual time=41.083..41.083 rows=1 loops=1)
                InitPlan 1 (returns $1)
                  ->  Limit  (cost=0.00..3.98 rows=1 width=8) (actual time=41.068..41.068 rows=1 loops=1)
                        ->  Index Scan using "to" on follows  (cost=0.00..2119376395.73 rows=532018692 width=8) (actual time=41.066..41.066 rows=1 loops=1)
                              Filter: ("to" IS NOT NULL)
          ->  WorkTable Scan on t  (cost=0.00..40.16 rows=10 width=8) (actual time=0.899..0.900 rows=1 loops=47303)
                Filter: (t."to" IS NOT NULL)
                SubPlan 3
                  ->  Result  (cost=3.99..4.00 rows=1 width=0) (actual time=0.897..0.897 rows=1 loops=47302)
                        InitPlan 2 (returns $3)
                          ->  Limit  (cost=0.00..3.99 rows=1 width=8) (actual time=0.895..0.895 rows=1 loops=47302)
                                ->  Index Scan using "to" on follows  (cost=0.00..706902240.99 rows=177339564 width=8) (actual time=0.893..0.893 rows=1 loops=47302)
                                      Index Cond: ("to" > $2)
                                      Filter: ("to" IS NOT NULL)
  ->  CTE Scan on t  (cost=0.00..2.02 rows=100 width=8) (actual time=41.090..42791.349 rows=47302 loops=1)
        Filter: ("to" IS NOT NULL)
  ->  Subquery Scan "*SELECT* 2"  (cost=66.83..66.85 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)
        ->  Result  (cost=66.83..66.84 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)
              One-Time Filter: $5
              InitPlan 5 (returns $5)
                ->  Index Scan using "to" on follows  (cost=0.00..66.83 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)
                      Index Cond: ("to" IS NULL)
Total runtime: 42818.338 ms