gistfile1.txt

 Aggregate  (cost=24840126.64..24840126.65 rows=1 width=6) (actual time=13742.045..13742.046 rows=1 loops=1)
   ->  Seq Scan on orders  (cost=0.00..24832943.33 rows=1436662 width=6) (actual time=2447.098..13741.666 rows=95 loops=1)
         Filter: (SubPlan 1)
         Rows Removed by Filter: 2884739
         SubPlan 1
           ->  Index Scan using page_views_session_id_created_at_idx on page_views pv  (cost=0.57..8.60 rows=1 width=0) (actual ti
me=0.003..0.003 rows=0 loops=2884834)
                 Index Cond: ((session_id = orders.session_id) AND (orders.created_on > created_at) AND (created_at > (now() - '2
days'::interval)))
                 Filter: (path = '/carts/resume'::citext)
                 Rows Removed by Filter: 0
 Total runtime: 13742.132 ms