explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7AHl

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 565.245 ↓ 25.0 100 1

Limit (cost=53.74..53.75 rows=4 width=67) (actual time=565.199..565.245 rows=100 loops=1)

  • Buffers: shared hit=501235
  • Planning time: 0.553 ms
  • Execution time: 565.343 ms
2. 33.705 565.215 ↓ 25.0 100 1

Sort (cost=53.74..53.75 rows=4 width=67) (actual time=565.198..565.215 rows=100 loops=1)

  • Sort Key: e.id
  • Sort Method: top-N heapsort Memory: 49kB
  • Buffers: shared hit=501235
3. 121.182 531.510 ↓ 25,000.0 100,000 1

Nested Loop (cost=1.13..53.70 rows=4 width=67) (actual time=0.054..531.510 rows=100,000 loops=1)

  • Buffers: shared hit=501235
4. 110.328 110.328 ↓ 25,000.0 100,000 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail ed (cost=0.70..19.89 rows=4 width=16) (actual time=0.040..110.328 rows=100,000 loops=1)

  • Index Cond: ((detail_type = 'Parameter'::detail_type) AND (name = 'Device Parameter 2'::text) AND (value = 'Device Parameter 2 value'::text))
  • Buffers: shared hit=100824
5. 300.000 300.000 ↑ 1.0 1 100,000

Index Scan using entity_pkey on entity e (cost=0.44..8.45 rows=1 width=67) (actual time=0.003..0.003 rows=1 loops=100,000)

  • Index Cond: (id = ed.entity_id)
  • Buffers: shared hit=400411