explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KScM

Settings
# exclusive inclusive rows x rows loops node
1. 29.069 283.804 ↑ 1.0 10,388 1

Nested Loop Left Join (cost=1.00..137,065.42 rows=10,388 width=261) (actual time=0.150..283.804 rows=10,388 loops=1)

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

Nested Loop Left Join (cost=0.56..49,260.85 rows=10,388 width=39) (actual time=0.144..192.407 rows=10,388 loops=1)

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

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

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

Limit (cost=0.56..4.67 rows=1 width=27) (actual time=0.012..0.014 rows=1 loops=10,388)

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

Index Scan using product_upc_created_idx on public."Product" product (cost=0.56..173.28 rows=42 width=27) (actual time=0.010..0.011 rows=1 loops=10,388)

  • Output: product.id, product.created, product.provider
  • Index Cond: ((product.upc)::text = (j.upc)::text)
6. 62.328 62.328 ↑ 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.006..0.006 rows=1 loops=10,388)

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