explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5lAv

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 10,699.088 ↓ 5.0 5 1

Nested Loop (cost=1,001.12..368,119.70 rows=1 width=107) (actual time=8,214.170..10,699.088 rows=5 loops=1)

2. 0.000 10,690.806 ↓ 6.0 6 1

Nested Loop (cost=1,000.56..368,118.65 rows=1 width=107) (actual time=8,212.597..10,690.806 rows=6 loops=1)

3. 2.468 10,683.524 ↓ 4.0 4 1

Gather (cost=1,000.00..368,098.27 rows=1 width=99) (actual time=8,210.593..10,683.524 rows=4 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 10,681.056 10,681.056 ↑ 1.0 1 3 / 3

Parallel Seq Scan on address a (cost=0.00..367,098.17 rows=1 width=99) (actual time=9,036.746..10,681.056 rows=1 loops=3)

  • Filter: (((street)::text = '615 N Harth Ave'::text) AND ((city)::text = 'Madison'::text) AND ((state)::text = 'SD'::text) AND ((zip_code)::text = '57042-1624'::text) AND ((country)::text = 'US'::text))
  • Rows Removed by Filter: 5,072,964
5. 7.332 7.332 ↓ 2.0 2 4

Index Scan using order_ship_address_id_idx1 on "order" o (cost=0.56..20.38 rows=1 width=16) (actual time=1.477..1.833 rows=2 loops=4)

  • Index Cond: (ship_address_id = a.id)
  • Filter: (store_id = 106,421,781)
6. 8.256 8.256 ↑ 1.0 1 6

Index Scan using cart_coupon_order_idx on cart_coupon cp (cost=0.56..1.04 rows=1 width=8) (actual time=1.376..1.376 rows=1 loops=6)

  • Index Cond: (order_id = o.id)
  • Filter: (coupon_id = '2158429731'::bigint)
Planning time : 15.952 ms
Execution time : 10,699.275 ms