explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cWQs

Settings
# exclusive inclusive rows x rows loops node
1. 12.270 9,817.857 ↓ 150.4 100,000 1

Unique (cost=28,404.82..28,408.15 rows=665 width=16) (actual time=9,794.508..9,817.857 rows=100,000 loops=1)

  • Buffers: shared hit=114719 read=20330
2. 53.950 9,805.587 ↓ 150.2 100,000 1

Sort (cost=28,404.82..28,406.48 rows=666 width=16) (actual time=9,794.505..9,805.587 rows=100,000 loops=1)

  • Sort Key: entity_id
  • Sort Method: quicksort Memory: 7760kB
  • Buffers: shared hit=114719 read=20330
3. 654.370 9,751.637 ↓ 150.2 100,000 1

Bitmap Heap Scan on entity_detail (cost=25,735.99..28,373.59 rows=666 width=16) (actual time=9,113.539..9,751.637 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=114716 read=20330
4. 4.193 9,097.267 ↓ 0.0 0 1

BitmapAnd (cost=25,735.99..25,735.99 rows=666 width=0) (actual time=9,097.267..9,097.267 rows=0 loops=1)

  • Buffers: shared hit=20889 read=14157
5. 66.397 66.397 ↓ 2.5 100,000 1

Bitmap Index Scan on entity_detail_detail_type_name_value_idx (cost=0.00..1,888.70 rows=40,401 width=0) (actual time=66.397..66.397 rows=100,000 loops=1)

  • Index Cond: ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 6'::text))
  • Buffers: shared hit=2 read=938
6. 9,026.677 9,026.677 ↑ 2.1 1,211,000 1

Bitmap Index Scan on entity_detail_value_gin_trgm_idx (cost=0.00..23,846.71 rows=2,504,894 width=0) (actual time=9,026.677..9,026.677 rows=1,211,000 loops=1)

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