explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7loJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 5,555.735 ↓ 5.0 10 1

Nested Loop (cost=13.00..29.50 rows=2 width=45) (actual time=5,504.356..5,555.735 rows=10 loops=1)

  • Buffers: shared hit=28 read=100955
2. 0.004 5,481.245 ↓ 5.0 10 1

Limit (cost=12.56..12.57 rows=2 width=16) (actual time=5,481.220..5,481.245 rows=10 loops=1)

  • Buffers: shared hit=3 read=100940
3. 0.017 5,481.241 ↓ 5.0 10 1

Unique (cost=12.56..12.57 rows=2 width=16) (actual time=5,481.219..5,481.241 rows=10 loops=1)

  • Buffers: shared hit=3 read=100940
4. 77.302 5,481.224 ↓ 5.0 10 1

Sort (cost=12.56..12.57 rows=2 width=16) (actual time=5,481.215..5,481.224 rows=10 loops=1)

  • Sort Key: ed.entity_id
  • Sort Method: quicksort Memory: 7760kB
  • Buffers: shared hit=3 read=100940
5. 5,403.922 5,403.922 ↓ 50,000.0 100,000 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail ed (cost=0.70..12.55 rows=2 width=16) (actual time=45.196..5,403.922 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=100940
6. 74.450 74.450 ↑ 1.0 1 10

Index Scan using entity_pkey on entity e (cost=0.43..8.45 rows=1 width=45) (actual time=7.445..7.445 rows=1 loops=10)

  • Index Cond: (id = ed.entity_id)
  • Buffers: shared hit=25 read=15