explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oZUV

Settings
# exclusive inclusive rows x rows loops node
1. 71.276 10,682.887 ↑ 6.6 10 1

HashSetOp Intersect (cost=0.70..1,793.59 rows=66 width=20) (actual time=10,679.749..10,682.887 rows=10 loops=1)

  • Buffers: shared hit=2 read=101767
2. 10.592 10,611.611 ↓ 219.2 100,821 1

Append (cost=0.70..1,792.44 rows=460 width=20) (actual time=43.791..10,611.611 rows=100,821 loops=1)

  • Buffers: shared hit=2 read=101767
3. 19.184 5,947.459 ↓ 1,515.2 100,000 1

Subquery Scan on *SELECT* 2 (cost=0.70..258.58 rows=66 width=20) (actual time=43.790..5,947.459 rows=100,000 loops=1)

  • Buffers: shared read=100939
4. 5,928.275 5,928.275 ↓ 1,515.2 100,000 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail (cost=0.70..257.92 rows=66 width=16) (actual time=43.781..5,928.275 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 read=100939
5. 0.599 4,653.560 ↓ 2.1 821 1

Subquery Scan on *SELECT* 1 (cost=0.70..1,531.56 rows=394 width=20) (actual time=36.961..4,653.560 rows=821 loops=1)

  • Buffers: shared hit=2 read=828
6. 4,652.961 4,652.961 ↓ 2.1 821 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail entity_detail_1 (cost=0.70..1,527.62 rows=394 width=16) (actual time=36.959..4,652.961 rows=821 loops=1)

  • Index Cond: ((detail_type = 'Tag'::text) AND (name = 'Tag1'::text) AND (value = 'tag 2993'::text))
  • Buffers: shared hit=2 read=828