explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5BZT

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 5,507.412 ↓ 5.0 10 1

Nested Loop (cost=13.03..29.51 rows=2 width=69) (actual time=5,472.975..5,507.412 rows=10 loops=1)

  • Buffers: shared hit=31 read=100951
2. 0.010 5,460.769 ↓ 5.0 10 1

Unique (cost=12.60..12.61 rows=2 width=16) (actual time=5,460.756..5,460.769 rows=10 loops=1)

  • Buffers: shared hit=3 read=100939
3. 0.037 5,460.759 ↓ 5.0 10 1

Sort (cost=12.60..12.60 rows=2 width=16) (actual time=5,460.755..5,460.759 rows=10 loops=1)

  • Sort Key: entity_detail.entity_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3 read=100939
4. 0.002 5,460.722 ↓ 5.0 10 1

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

  • Buffers: shared read=100939
5. 39.678 5,460.720 ↓ 5.0 10 1

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

  • Sort Key: entity_detail.entity_id
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared read=100939
6. 5,421.042 5,421.042 ↓ 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=47.064..5,421.042 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
7. 46.600 46.600 ↑ 1.0 1 10

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

  • Index Cond: (id = entity_detail.entity_id)
  • Buffers: shared hit=28 read=12