explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Esn

options
exclusive inclusive rows x rows loops node
0.005 365.885 ↓ 2.5 10 1
→

Limit (cost=38787.96..38881.42 rows=4 width=98) (actual time=365.690..365.885 rows=10 loops=1)

0.009 365.880 ↓ 2.5 10 1
→

Nested Loop (cost=38787.96..38881.42 rows=4 width=98) (actual time=365.688..365.880 rows=10 loops=1)

0.020 365.821 ↓ 2.5 10 1
→

Nested Loop (cost=38787.96..38852.06 rows=4 width=65) (actual time=365.669..365.821 rows=10 loops=1)

0.008 365.751 ↓ 2.5 10 1
→

Nested Loop (cost=38787.96..38821.79 rows=4 width=26) (actual time=365.658..365.751 rows=10 loops=1)

0.578 365.643 ↓ 2.5 10 1
→

HashAggregate (cost=38787.96..38788.00 rows=4 width=4) (actual time=365.640..365.643 rows=10 loops=1)

50.289 365.065 ↓ 213.0 852 1
→

Nested Loop (cost=0.00..38787.95 rows=4 width=4) (actual time=19.573..365.065 rows=852 loops=1)

  • Join Filter: (((public.orders.created_on)::date >= mos.start_date) AND ((public.orders.created_on)::date < mos.end_date))
12.401 125.612 ↓ 1278.1 47291 1
→

Nested Loop (cost=0.00..38507.52 rows=37 width=16) (actual time=0.230..125.612 rows=47291 loops=1)

  • Join Filter: (COALESCE(mos.quantity, li.quantity) = li.quantity)
19.303 30.321 ↓ 2.0 135 1
→

Nested Loop (cost=0.00..2243.93 rows=69 width=16) (actual time=0.186..30.321 rows=135 loops=1)

  • Join Filter: ((public.products.name)::text ~~* (('%'::text || mos.search_term) || '%'::text))
0.050 0.050 ↑ 1.0 1 1
→

Index Scan using mc_order_searches_pkey on mc_order_searches mos (cost=0.00..8.27 rows=1 width=44) (actual time=0.048..0.050 rows=1 loops=1)

  • Index Cond: (mc_order_search_id = 2)
10.968 10.968 ↑ 1.0 13806 1
→

Seq Scan on products (cost=0.00..1994.06 rows=13806 width=41) (actual time=0.007..10.968 rows=13806 loops=1)

82.890 82.890 ↓ 1.4 350 135
→

Index Scan using index_line_items_on_product_id on line_items li (cost=0.00..521.93 rows=242 width=16) (actual time=0.022..0.614 rows=350 loops=135)

  • Index Cond: (product_id = public.products.id)
  • Filter: (((state)::text <> 'canceled'::text) AND ((state)::text <> 'canceled'::text))
189.164 189.164 ↑ 1.0 1 47291
→

Index Scan using orders_pkey on orders (cost=0.00..7.56 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=47291)

  • Index Cond: (id = li.order_id)
0.100 0.100 ↑ 1.0 1 10
→

Index Scan using line_items_pkey on line_items li (cost=0.00..8.43 rows=1 width=26) (actual time=0.010..0.010 rows=1 loops=10)

  • Index Cond: (id = li.id)
0.050 0.050 ↑ 1.0 1 10
→

Index Scan using orders_pkey on orders (cost=0.00..7.56 rows=1 width=43) (actual time=0.005..0.005 rows=1 loops=10)

  • Index Cond: (id = li.order_id)
0.050 0.050 ↑ 1.0 1 10
→

Index Scan using products_pkey on products (cost=0.00..7.32 rows=1 width=41) (actual time=0.005..0.005 rows=1 loops=10)