explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WLFW

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.064 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.29..17.49 rows=1 width=269) (actual time=0.056..0.064 rows=1 loops=1)

  • Output: j.upc, product.created, product.provider, y.payload
  • Inner Unique: true
2. 0.005 0.049 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..9.03 rows=1 width=40) (actual time=0.042..0.049 rows=1 loops=1)

  • Output: j.upc, product.created, product.provider, product.id
3. 0.015 0.015 ↑ 1.0 1 1

Index Scan using jobpayload_jid_idx on public."JobPayload" j (cost=0.29..4.34 rows=1 width=13) (actual time=0.013..0.015 rows=1 loops=1)

  • Output: j.upc
  • Index Cond: (j.job_id = 68)
4. 0.005 0.029 ↑ 1.0 1 1

Limit (cost=0.56..4.67 rows=1 width=27) (actual time=0.026..0.029 rows=1 loops=1)

  • Output: product.id, product.created, product.provider
5. 0.024 0.024 ↑ 42.0 1 1

Index Scan using product_upc_created_idx on public."Product" product (cost=0.56..173.22 rows=42 width=27) (actual time=0.023..0.024 rows=1 loops=1)

  • Output: product.id, product.created, product.provider
  • Index Cond: ((product.upc)::text = (j.upc)::text)
6. 0.011 0.011 ↑ 1.0 1 1

Index Scan using "ProductPayload_pkey" on public."ProductPayload" y (cost=0.44..8.46 rows=1 width=245) (actual time=0.011..0.011 rows=1 loops=1)

  • Output: y.pid, y.title, y.description, y.payload
  • Index Cond: (y.pid = product.id)
Planning time : 0.315 ms
Execution time : 0.107 ms