query-plan-1179

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
79458.183 100.00% 
 Limit (cost=3115.85..3115.85 rows=1 width=1793) (actual time=79458.183..79458.183 rows=0 loops=1)
79458.183 100.00% 
   -> Sort (cost=3115.85..3115.85 rows=1 width=1793) (actual time=79458.183..79458.183 rows=0 loops=1)
         Sort Key: round((meters_to_miles((distance('0101000020E610000018265305A3725DC09487855AD3EC4040'::geometry, c.llpoint) * 111319::double precision)))::numeric, 2)
79458.095 100.00% 
         -> Nested Loop (cost=0.0..3115.85 rows=1 width=1793) (actual time=79458.095..79458.095 rows=0 loops=1)
79458.094 100.00% 
               -> Nested Loop (cost=0.0..3107.82 rows=1 width=1613) (actual time=79458.094..79458.094 rows=0 loops=1)
79449.207 99.99% 
                     -> Append (cost=0.0..3075.5 rows=4 width=385) (actual time=190.628..79449.207 rows=729 loops=1)
17454.671 21.97% 
                           -> Nested Loop (cost=0.0..921.7 rows=1 width=302) (actual time=190.627..17454.671 rows=216 loops=1)
16042.772 20.19% 
                                 -> Seq Scan on "location" l (cost=0.0..776.96 rows=18 width=50) (actual time=5.952..16042.772 rows=3394 loops=1)
                                       Filter: (((currentvalue('eureka'::text, uid, 'location'::text, 'franchisecode'::text, (now())::timestamp without time zone) = ANY ('{K,s,T,J,H,P,2,W,4}'::text[])) AND (cu
37.334 0.05% 
                                 -> Index Scan using address_pkey on address a (cost=0.0..8.04 rows=1 width=256) (actual time=0.011..0.011 rows=0 loops=3394)
                                       Index Cond: ((l.uid = a.objectuid) AND ((a."type")::text = 'S'::text))
                                       Filter: (('0103000020E61000000100000005000000000000E00BE25DC0000000A0010E4040000000E00BE25DC000000000A5CB4140000000403A035DC000000000A5CB4140000000403A035DC0000000A0010E4
61994.181 78.02% 
                           -> Subquery Scan "*SELECT* 2" (cost=0.0..2153.79 rows=3 width=385) (actual time=33758.247..61994.181 rows=513 loops=1)
61993.366 78.02% 
                                 -> Nested Loop (cost=0.0..2153.79 rows=3 width=385) (actual time=33758.240..61993.366 rows=513 loops=1)
59616.828 75.03% 
                                       -> Seq Scan on "location" ml (cost=0.0..979.37 rows=166 width=44) (actual time=10.805..59616.828 rows=14694 loops=1)
                                             Filter: (((currentvalue('massmerchant'::text, uid, 'location'::text, 'franchisecode'::text, (now())::timestamp without time zone) = ANY ('{K,s,T,J,H,P,2,W,4}'::text
132.246 0.17% 
                                       -> Index Scan using address_pkey on address ma (cost=0.0..7.07 rows=1 width=345) (actual time=0.009..0.009 rows=0 loops=14694)
                                             Index Cond: ((ml.uid = ma.objectuid) AND ((ma."type")::text = 'S'::text))
                                             Filter: (('0103000020E61000000100000005000000000000E00BE25DC0000000A0010E4040000000E00BE25DC000000000A5CB4140000000403A035DC000000000A5CB4140000000403A035DC0000000A
8.019 0.01% 
                     -> Index Scan using offlineproduct_idx1 on offlineproduct b (cost=0.0..8.08 rows=1 width=21) (actual time=0.011..0.011 rows=0 loops=729)
                           Index Cond: (((b.clientkey)::text = (c.clientkey)::text) AND ('dadasda'::text = (b.sku)::text))
0.000 0.00% 
               -> Index Scan using product_idx1 on product a (never executed)
                     Index Cond: (((sku)::text = 'dadasda'::text) AND ((currency)::text = 'USD'::text) AND (activeflag = true))
                     Filter: activeflag