explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Heho

Settings
# exclusive inclusive rows x rows loops node
1. 4,989.608 5,170.517 ↓ 2,189.8 300,000 1

Bitmap Heap Scan on entity_detail (cost=15.91..564.12 rows=137 width=49) (actual time=210.180..5,170.517 rows=300,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)) OR ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 3'::text) AND (value = 'Device Parameter 3 value'::text)))
  • Heap Blocks: exact=102470
  • Buffers: shared hit=4 read=105284
2. 0.005 180.909 ↓ 0.0 0 1

BitmapOr (cost=15.91..15.91 rows=137 width=0) (actual time=180.909..180.909 rows=0 loops=1)

  • Buffers: shared hit=4 read=2814
3. 74.616 74.616 ↓ 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=74.616..74.616 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.820 51.820 ↓ 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.820..51.820 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
5. 54.468 54.468 ↓ 1,428.6 100,000 1

Bitmap Index Scan on entity_detail_detail_type_name_value_idx (cost=0.00..5.57 rows=70 width=0) (actual time=54.468..54.468 rows=100,000 loops=1)

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