explain.depesz.com

PostgreSQL's explain analyze made readable

Result: keP6

Settings
# exclusive inclusive rows x rows loops node
1. 5,581.104 5,581.104 ↓ 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=49) (actual time=48.892..5,581.104 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