explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Un1Z

Settings
# exclusive inclusive rows x rows loops node
1. 20.613 5,615.736 ↓ 15.0 100,000 1

Unique (cost=145,183.35..145,217.14 rows=6,666 width=16) (actual time=5,582.605..5,615.736 rows=100,000 loops=1)

  • Buffers: shared hit=3 read=100940
2. 75.377 5,595.123 ↓ 14.8 100,000 1

Sort (cost=145,183.35..145,200.25 rows=6,757 width=16) (actual time=5,582.602..5,595.123 rows=100,000 loops=1)

  • Sort Key: entity_id
  • Sort Method: quicksort Memory: 7760kB
  • Buffers: shared hit=3 read=100940
3. 5,425.680 5,519.746 ↓ 14.8 100,000 1

Bitmap Heap Scan on entity_detail (cost=1,890.39..144,753.53 rows=6,757 width=16) (actual time=122.014..5,519.746 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
4. 94.066 94.066 ↓ 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=94.066..94.066 rows=100,000 loops=1)

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