explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PL3l

Settings
# exclusive inclusive rows x rows loops node
1. 126.615 8,042.583 ↑ 1.0 1 1

GroupAggregate (cost=0.56..114,279.52 rows=1 width=12) (actual time=8,042.582..8,042.583 rows=1 loops=1)

  • Group Key: retailer.marketplace_id
2. 228.325 7,915.968 ↓ 1.1 511,575 1

Nested Loop Left Join (cost=0.56..111,865.75 rows=482,752 width=16) (actual time=3.817..7,915.968 rows=511,575 loops=1)

  • Join Filter: (marketplace_upc.marketplace_id = retailer.marketplace_id)
3. 0.049 0.049 ↑ 1.0 1 1

Seq Scan on retailer (cost=0.00..6.74 rows=1 width=4) (actual time=0.014..0.049 rows=1 loops=1)

  • Filter: (marketplace_id = 35)
  • Rows Removed by Filter: 299
4. 7,687.594 7,687.594 ↓ 1.1 511,575 1

Index Only Scan using marketplace_upc_pk on marketplace_upc (cost=0.56..105,824.61 rows=482,752 width=16) (actual time=3.797..7,687.594 rows=511,575 loops=1)

  • Index Cond: (marketplace_id = 35)
  • Heap Fetches: 469,205
Planning time : 0.185 ms
Execution time : 8,042.627 ms