explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yh8G

Settings
# exclusive inclusive rows x rows loops node
1. 206.132 216,162.633 ↓ 50,000.0 100,000 1

Nested Loop (cost=1.13..29.46 rows=2 width=85) (actual time=66.667..216,162.633 rows=100,000 loops=1)

  • Buffers: shared hit=367944 read=133389
2. 17,756.501 17,756.501 ↓ 50,000.0 100,000 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail (cost=0.70..12.55 rows=2 width=16) (actual time=46.799..17,756.501 rows=100,000 loops=1)

  • Index Cond: ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 1'::text) AND (value = 'Device Parameter 1 value'::text))
  • Buffers: shared read=100939
3. 198,200.000 198,200.000 ↑ 1.0 1 100,000

Index Scan using entity_pkey on entity e (cost=0.43..8.45 rows=1 width=69) (actual time=1.982..1.982 rows=1 loops=100,000)

  • Index Cond: (id = entity_detail.entity_id)
  • Buffers: shared hit=367944 read=32450