explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I9vE

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.060 ↑ 1.0 1 1

Limit (cost=0.56..28.22 rows=1 width=52) (actual time=0.055..0.060 rows=1 loops=1)

  • Output: p.upc, p.created, ((SubPlan 1))
2. 0.036 0.054 ↑ 9.0 1 1

Index Scan using product_upc_created_idx on public."Product" p (cost=0.56..249.46 rows=9 width=52) (actual time=0.052..0.054 rows=1 loops=1)

  • Output: p.upc, p.created, (SubPlan 1)
  • Index Cond: ((p.upc)::text = '048894047169'::text)
  • Filter: ((p.provider)::text = 'walmart.com'::text)
3.          

SubPlan (for Index Scan)

4. 0.018 0.018 ↑ 1.0 1 1

Index Scan using "ProductPayload_pkey" on public."ProductPayload" (cost=0.43..8.45 rows=1 width=230) (actual time=0.015..0.018 rows=1 loops=1)

  • Output: "ProductPayload".payload
  • Index Cond: ("ProductPayload".pid = p.id)
Planning time : 0.232 ms
Execution time : 0.098 ms