explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Vol

Settings
# exclusive inclusive rows x rows loops node
1. 33.352 407.896 ↑ 1.0 10,388 1

Nested Loop Left Join (cost=173.92..1,890,684.08 rows=10,388 width=261) (actual time=0.053..407.896 rows=10,388 loops=1)

  • Output: j.upc, product.created, product.provider, "ProductPayload".payload
  • Inner Unique: true
2. 32.068 322.604 ↑ 1.0 10,388 1

Nested Loop Left Join (cost=173.48..1,802,879.51 rows=10,388 width=39) (actual time=0.047..322.604 rows=10,388 loops=1)

  • Output: j.upc, product.created, product.provider, product.id
3. 10.060 10.060 ↑ 1.0 10,388 1

Seq Scan on public."JobPayload" j (cost=0.00..515.90 rows=10,388 width=12) (actual time=0.011..10.060 rows=10,388 loops=1)

  • Output: j.job_id, j.upc
  • Filter: (j.job_id = 66)
  • Rows Removed by Filter: 4
4. 51.940 280.476 ↑ 1.0 1 10,388

Limit (cost=173.48..173.48 rows=1 width=27) (actual time=0.023..0.027 rows=1 loops=10,388)

  • Output: product.id, product.created, product.provider
5. 62.328 228.536 ↑ 42.0 1 10,388

Sort (cost=173.48..173.59 rows=42 width=27) (actual time=0.021..0.022 rows=1 loops=10,388)

  • Output: product.id, product.created, product.provider
  • Sort Key: product.created DESC
  • Sort Method: top-N heapsort Memory: 25kB
6. 166.208 166.208 ↑ 10.5 4 10,388

Index Scan using product_upc_idx on public."Product" product (cost=0.56..173.27 rows=42 width=27) (actual time=0.009..0.016 rows=4 loops=10,388)

  • Output: product.id, product.created, product.provider
  • Index Cond: ((product.upc)::text = (j.upc)::text)
7. 51.940 51.940 ↑ 1.0 1 10,388

Index Scan using "ProductPayload_pkey" on public."ProductPayload" (cost=0.43..8.45 rows=1 width=238) (actual time=0.005..0.005 rows=1 loops=10,388)

  • Output: "ProductPayload".pid, "ProductPayload".title, "ProductPayload".description, "ProductPayload".payload
  • Index Cond: ("ProductPayload".pid = product.id)
Planning time : 0.330 ms
Execution time : 416.077 ms