explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QQju

Settings
# exclusive inclusive rows x rows loops node
1. 6,218.147 12,712.744 ↑ 1.0 1 1

GroupAggregate (cost=1.57..219,350.96 rows=1 width=20) (actual time=12,712.743..12,712.744 rows=1 loops=1)

  • Group Key: retailer.marketplace_id
2. 702.962 6,494.597 ↓ 12.2 686,063 1

Nested Loop Left Join (cost=1.57..218,787.00 rows=56,395 width=42) (actual time=0.046..6,494.597 rows=686,063 loops=1)

3. 748.193 5,105.572 ↓ 12.2 686,063 1

Nested Loop Left Join (cost=1.14..160,445.77 rows=56,395 width=36) (actual time=0.045..5,105.572 rows=686,063 loops=1)

4. 227.149 693.908 ↓ 14.7 523,353 1

Nested Loop Left Join (cost=0.71..52,148.16 rows=35,678 width=18) (actual time=0.035..693.908 rows=523,353 loops=1)

5. 0.085 0.085 ↑ 1.0 1 1

Index Scan using retailer_pkey on retailer (cost=0.15..25.19 rows=1 width=4) (actual time=0.018..0.085 rows=1 loops=1)

  • Filter: (organization_id = 11,832)
  • Rows Removed by Filter: 300
6. 466.674 466.674 ↓ 7.1 523,353 1

Index Only Scan using marketplace_upc_marketplace_id_gtin_14_index on marketplace_upc (cost=0.56..51,389.86 rows=73,312 width=18) (actual time=0.015..466.674 rows=523,353 loops=1)

  • Index Cond: (marketplace_id = retailer.marketplace_id)
  • Heap Fetches: 523,353
7. 3,663.471 3,663.471 ↓ 0.0 0 523,353

Index Scan using product_ids_gtin_14_index on product_ids (cost=0.43..3.00 rows=4 width=18) (actual time=0.007..0.007 rows=0 loops=523,353)

  • Index Cond: ((marketplace_upc.gtin_14)::text = (gtin_14)::text)
8. 686.063 686.063 ↓ 0.0 0 686,063

Index Scan using product_ids_pk on product_ids onboard_platform (cost=0.43..1.02 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=686,063)

  • Index Cond: (product_id = product_ids.fe_prod_id)
Planning time : 1.290 ms
Execution time : 12,712.835 ms