explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ht7s

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=401,254.31..401,256.31 rows=200 width=20) (actual rows= loops=)

  • Group Key: marketplace_upc.marketplace_id
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=396,742.63..398,998.47 rows=112,792 width=24) (actual rows= loops=)

  • Group Key: marketplace_upc.provided_upc, marketplace_upc.marketplace_id
3. 0.000 0.000 ↓ 0.0

Sort (cost=396,742.63..397,024.61 rows=112,792 width=20) (actual rows= loops=)

  • Sort Key: marketplace_upc.provided_upc, marketplace_upc.marketplace_id
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=3,049.91..384,964.02 rows=112,792 width=20) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,049.48..342,051.09 rows=71,954 width=30) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on retailer (cost=0.00..7.75 rows=2 width=4) (actual rows= loops=)

  • Filter: (organization_id = 211)
7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on marketplace_upc (cost=3,049.48..170,282.42 rows=73,925 width=30) (actual rows= loops=)

  • Recheck Cond: (marketplace_id = retailer.marketplace_id)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on marketplace_upc_pk (cost=0.00..3,031.00 rows=73,925 width=0) (actual rows= loops=)

  • Index Cond: (marketplace_id = retailer.marketplace_id)
9. 0.000 0.000 ↓ 0.0

Index Scan using product_ids_gtin_14_index on product_ids _unmatched_upcs (cost=0.43..0.56 rows=4 width=18) (actual rows= loops=)

  • Index Cond: ((marketplace_upc.gtin_14)::text = (gtin_14)::text)