explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UOcJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.072 5,504.366 ↓ 5.0 10 1

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

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

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

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

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

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

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

  • Sort Key: entity_detail.entity_id
  • Sort Method: quicksort Memory: 7760kB
  • Buffers: shared hit=3 read=100940
5. 5,349.286 5,349.286 ↓ 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=43.777..5,349.286 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. 86.900 86.900 ↑ 1.0 1 10

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

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