explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RC1I

Settings
# exclusive inclusive rows x rows loops node
1. 5,003.601 5,089.042 ↓ 14.9 100,000 1

Bitmap Heap Scan on entity_detail (cost=1,871.72..143,781.06 rows=6,712 width=49) (actual time=115.164..5,089.042 rows=100,000 loops=1)

  • Recheck Cond: ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 8'::text))
  • Filter: (value ~~* 'Device%'::text)
  • Heap Blocks: exact=100000
  • Buffers: shared read=100940
2. 85.441 85.441 ↓ 2.5 100,000 1

Bitmap Index Scan on entity_detail_detail_type_name_value_idx (cost=0.00..1,870.04 rows=40,135 width=0) (actual time=85.441..85.441 rows=100,000 loops=1)

  • Index Cond: ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 8'::text))
  • Buffers: shared read=940