explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XMtG

Settings
# exclusive inclusive rows x rows loops node
1. 765.217 2,038.471 ↑ 3.9 4,498,570 1

Nested Loop (cost=0.00..353,062.02 rows=17,380,200 width=40) (actual time=0.535..2,038.471 rows=4,498,570 loops=1)

  • Output: claim_product_order.claim_id, cpo.claim_product_id, cpo.display_order
  • Buffers: shared hit=14145 read=10964
2. 56.640 56.640 ↑ 1.0 173,802 1

Seq Scan on client_pinnacle.claim_product_order (cost=0.00..5,458.02 rows=173,802 width=143) (actual time=0.517..56.640 rows=173,802 loops=1)

  • Output: claim_product_order.claim_id, claim_product_order.item_ids
  • Buffers: shared hit=3 read=3717
3. 1,216.614 1,216.614 ↑ 3.8 26 173,802

Function Scan on pg_catalog.unnest cpo (cost=0.00..1.00 rows=100 width=24) (actual time=0.005..0.007 rows=26 loops=173,802)

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