explain.depesz.com

PostgreSQL's explain analyze made readable

Result: erfm

Settings
# exclusive inclusive rows x rows loops node
1. 5,496.504 14,199.377 ↓ 151.1 100,000 1

Bitmap Heap Scan on entity_detail (cost=24,253.66..26,875.38 rows=662 width=49) (actual time=8,725.405..14,199.377 rows=100,000 loops=1)

  • Recheck Cond: ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 6'::text) AND (value ~~* '%Parameter 6%'::text))
  • Heap Blocks: exact=100000
  • Buffers: shared hit=18727 read=112627
2. 4.662 8,702.873 ↓ 0.0 0 1

BitmapAnd (cost=24,253.66..24,253.66 rows=662 width=0) (actual time=8,702.873..8,702.873 rows=0 loops=1)

  • Buffers: shared hit=18727 read=12627
3. 77.215 77.215 ↓ 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=77.215..77.215 rows=100,000 loops=1)

  • Index Cond: ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 6'::text))
  • Buffers: shared read=940
4. 8,620.996 8,620.996 ↑ 2.3 1,100,000 1

Bitmap Index Scan on entity_detail_value_gin_trgm_idx (cost=0.00..22,383.03 rows=2,488,405 width=0) (actual time=8,620.996..8,620.996 rows=1,100,000 loops=1)

  • Index Cond: (value ~~* '%Parameter 6%'::text)
  • Buffers: shared hit=18727 read=11687