explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DGph

Settings
# exclusive inclusive rows x rows loops node
1. 108.290 5,681.074 ↓ 1,470.6 100,000 1

HashAggregate (cost=271.66..272.34 rows=68 width=16) (actual time=5,668.388..5,681.074 rows=100,000 loops=1)

  • Group Key: entity_detail.entity_id
  • Buffers: shared hit=98767 read=103111
2. 13.496 5,572.784 ↓ 2,941.2 200,000 1

Append (cost=0.70..271.49 rows=68 width=16) (actual time=48.021..5,572.784 rows=200,000 loops=1)

  • Buffers: shared hit=98767 read=103111
3. 5,429.784 5,429.784 ↓ 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=48.020..5,429.784 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
4. 129.504 129.504 ↓ 1,515.2 100,000 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail entity_detail_1 (cost=0.70..257.92 rows=66 width=16) (actual time=31.587..129.504 rows=100,000 loops=1)

  • Index Cond: ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 2'::text) AND (value = 'Device Parameter 2 value'::text))
  • Buffers: shared hit=98767 read=2172