explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uB8h : Get Marketplace Upc Coverage Summaries

Settings
# exclusive inclusive rows x rows loops node
1. 299.869 20,836.961 ↑ 100.0 2 1

GroupAggregate (cost=189,720.90..190,688.22 rows=200 width=20) (actual time=19,837.612..20,836.961 rows=2 loops=1)

  • Group Key: marketplace_upc.marketplace_id
2. 792.514 20,537.092 ↓ 42.4 1,023,150 1

GroupAggregate (cost=189,720.90..190,203.56 rows=24,133 width=24) (actual time=17,478.400..20,537.092 rows=1,023,150 loops=1)

  • Group Key: marketplace_upc.marketplace_id, marketplace_upc.provided_upc
3. 9,985.771 19,744.578 ↓ 55.4 1,336,020 1

Sort (cost=189,720.90..189,781.24 rows=24,133 width=20) (actual time=17,478.387..19,744.578 rows=1,336,020 loops=1)

  • Sort Key: marketplace_upc.marketplace_id, marketplace_upc.provided_upc
  • Sort Method: external merge Disk: 35,624kB
4. 597.298 9,758.807 ↓ 55.4 1,336,020 1

Nested Loop Left Join (cost=1,851.38..187,964.18 rows=24,133 width=20) (actual time=47.485..9,758.807 rows=1,336,020 loops=1)

5. 424.168 976.309 ↓ 45.7 1,023,150 1

Nested Loop (cost=1,850.95..174,816.71 rows=22,394 width=29) (actual time=47.441..976.309 rows=1,023,150 loops=1)

6. 0.043 0.043 ↓ 2.0 2 1

Seq Scan on retailer (cost=0.00..6.74 rows=1 width=4) (actual time=0.013..0.043 rows=2 loops=1)

  • Filter: (organization_id = 11,832)
  • Rows Removed by Filter: 298
7. 473.814 552.098 ↓ 6.5 511,575 2

Bitmap Heap Scan on marketplace_upc (cost=1,850.95..174,022.21 rows=78,776 width=29) (actual time=44.231..276.049 rows=511,575 loops=2)

  • Recheck Cond: (marketplace_id = retailer.marketplace_id)
  • Heap Blocks: exact=55,012
8. 78.284 78.284 ↓ 6.5 511,575 2

Bitmap Index Scan on marketplace_upc_marketplace_id_index (cost=0.00..1,831.25 rows=78,776 width=0) (actual time=39.142..39.142 rows=511,575 loops=2)

  • Index Cond: (marketplace_id = retailer.marketplace_id)
9. 8,185.200 8,185.200 ↓ 0.0 0 1,023,150

Index Scan using product_ids_gtin_14_index on product_ids _unmatched_upcs (cost=0.43..0.55 rows=4 width=19) (actual time=0.007..0.008 rows=0 loops=1,023,150)

  • Index Cond: ((marketplace_upc.gtin_14)::text = (gtin_14)::text)
Planning time : 11.098 ms
Execution time : 20,843.031 ms