explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E5ab

Settings
# exclusive inclusive rows x rows loops node
1. 3,579.634 5,704.692 ↓ 6.5 174,300 1

Aggregate (cost=0.43..273,110.21 rows=26,903 width=88) (actual time=0.059..5,704.692 rows=174,300 loops=1)

  • Buffers: shared hit=88736 read=40788
2. 2,125.058 2,125.058 ↑ 1.0 4,525,987 1

Index Scan using claim_product_claim_id_idx on claim_product claim_product (cost=0.43..204,816.86 rows=4,525,987 width=55) (actual time=0.042..2,125.058 rows=4,525,987 loops=1)

  • Buffers: shared hit=88736 read=40788