explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vcLM

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

Nested Loop (cost=1.13..29.46 rows=2 width=69) (actual time=66.540..216,169.767 rows=100,000 loops=1)

  • Buffers: shared hit=367944 read=133389
2. 17,522.579 17,522.579 ↓ 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.628..17,522.579 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,500.000 198,500.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.985..1.985 rows=1 loops=100,000)

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