explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ng6n

Settings
# exclusive inclusive rows x rows loops node
1. 5,522.040 5,648.340 ↓ 2,985.1 200,000 1

Bitmap Heap Scan on entity_detail (cost=10.27..278.56 rows=67 width=49) (actual time=160.771..5,648.340 rows=200,000 loops=1)

  • Recheck Cond: (((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 1'::text) AND (value = 'Device Parameter 1 value'::text)) OR ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 2'::text) AND (value = 'Device Parameter 2 value'::text)))
  • Heap Blocks: exact=101235
  • Buffers: shared hit=2 read=103111
2. 0.004 126.300 ↓ 0.0 0 1

BitmapOr (cost=10.27..10.27 rows=67 width=0) (actual time=126.300..126.300 rows=0 loops=1)

  • Buffers: shared hit=2 read=1876
3. 75.015 75.015 ↓ 50,000.0 100,000 1

Bitmap Index Scan on entity_detail_detail_type_name_value_idx (cost=0.00..4.72 rows=2 width=0) (actual time=75.015..75.015 rows=100,000 loops=1)

  • Index Cond: ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 1'::text) AND (value = 'Device Parameter 1 value'::text))
  • Buffers: shared read=939
4. 51.281 51.281 ↓ 1,515.2 100,000 1

Bitmap Index Scan on entity_detail_detail_type_name_value_idx (cost=0.00..5.52 rows=66 width=0) (actual time=51.281..51.281 rows=100,000 loops=1)

  • Index Cond: ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 2'::text) AND (value = 'Device Parameter 2 value'::text))
  • Buffers: shared hit=2 read=937