explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8E0

Settings
# exclusive inclusive rows x rows loops node
1. 0.169 0.448 ↓ 6.1 609 1

Nested Loop (cost=0.42..5.44 rows=100 width=40) (actual time=0.164..0.448 rows=609 loops=1)

  • Output: claim_product_order.claim_id, cpo.claim_product_id, cpo.display_order
  • Buffers: shared hit=8
2. 0.015 0.015 ↑ 1.0 1 1

Index Scan using claim_product_order_pkey on client_pinnacle.claim_product_order (cost=0.42..3.44 rows=1 width=143) (actual time=0.013..0.015 rows=1 loops=1)

  • Output: claim_product_order.claim_id, claim_product_order.item_ids
  • Index Cond: (claim_product_order.claim_id = 'a9846f99-396a-4ce9-8035-ccd35769b080'::uuid)
  • Buffers: shared hit=4
3. 0.264 0.264 ↓ 6.1 609 1

Function Scan on pg_catalog.unnest cpo (cost=0.00..1.00 rows=100 width=24) (actual time=0.147..0.264 rows=609 loops=1)

  • Output: cpo.claim_product_id, cpo.display_order
  • Function Call: unnest(claim_product_order.item_ids)
  • Buffers: shared hit=4