explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6gMr

Settings
# exclusive inclusive rows x rows loops node
1. 2,456.056 60,896.723 ↓ 1,033,333.3 3,100,000 1

HashAggregate (cost=21.13..21.16 rows=3 width=16) (actual time=60,274.301..60,896.723 rows=3,100,000 loops=1)

  • Group Key: entity_detail.entity_id
  • Buffers: shared hit=2 read=1332194
2. 210.387 58,440.667 ↓ 1,033,333.3 3,100,000 1

Append (cost=0.70..21.13 rows=3 width=16) (actual time=20.195..58,440.667 rows=3,100,000 loops=1)

  • Buffers: shared hit=2 read=1332194
3. 1,275.416 1,275.416 ↓ 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=20.195..1,275.416 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. 56,954.864 56,954.864 ↓ 3,000,000.0 3,000,000 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail entity_detail_1 (cost=0.70..8.53 rows=1 width=16) (actual time=39.245..56,954.864 rows=3,000,000 loops=1)

  • Index Cond: ((detail_type = 'BacNetProperty'::text) AND (name = 'BACnet Property 8'::text))
  • Filter: (value ~~* 'BACnet%'::text)
  • Buffers: shared hit=2 read=1231255