explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iict

Settings
# exclusive inclusive rows x rows loops node
1. 508.073 62,794.149 ↓ 3,000,000.0 3,000,000 1

Unique (cost=8.54..8.55 rows=1 width=16) (actual time=61,822.629..62,794.149 rows=3,000,000 loops=1)

  • Buffers: shared hit=3 read=1231257
2. 2,181.833 62,286.076 ↓ 3,000,000.0 3,000,000 1

Sort (cost=8.54..8.54 rows=1 width=16) (actual time=61,822.625..62,286.076 rows=3,000,000 loops=1)

  • Sort Key: entity_id
  • Sort Method: quicksort Memory: 238930kB
  • Buffers: shared hit=3 read=1231257
3. 60,104.243 60,104.243 ↓ 3,000,000.0 3,000,000 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail (cost=0.70..8.53 rows=1 width=16) (actual time=39.196..60,104.243 rows=3,000,000 loops=1)

  • Index Cond: ((detail_type = 'BacNetProperty'::text) AND (name = 'BACnet Property 6'::text))
  • Filter: (value ~~* '%Property 6%'::text)
  • Buffers: shared read=1231257