explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y69v

Settings
# exclusive inclusive rows x rows loops node
1. 58,182.481 58,182.481 ↓ 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=49) (actual time=44.158..58,182.481 rows=3,000,000 loops=1)

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