explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f05

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 10,416.488 ↑ 43.0 11 1

HashAggregate (cost=3,379.33..3,384.06 rows=473 width=16) (actual time=10,416.486..10,416.488 rows=11 loops=1)

  • Group Key: entity_detail.entity_id
  • Buffers: shared hit=4 read=101771
2. 0.005 10,416.455 ↑ 43.0 11 1

Append (cost=0.70..3,378.15 rows=473 width=16) (actual time=48.605..10,416.455 rows=11 loops=1)

  • Buffers: shared hit=4 read=101771
3. 48.608 48.608 ↑ 407.0 1 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail (cost=0.70..1,577.46 rows=407 width=16) (actual time=48.604..48.608 rows=1 loops=1)

  • Index Cond: ((detail_type = 'EntityProperty'::text) AND (name = 'DisplayName'::text) AND (value = 'WAGO Minden'::text))
  • Buffers: shared read=6
4. 0.005 10,367.842 ↑ 6.6 10 1

Result (cost=0.70..1,794.25 rows=66 width=16) (actual time=10,364.683..10,367.842 rows=10 loops=1)

  • Buffers: shared hit=4 read=101765
5. 70.492 10,367.837 ↑ 6.6 10 1

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

  • Buffers: shared hit=4 read=101765
6. 11.316 10,297.345 ↓ 219.2 100,821 1

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

  • Buffers: shared hit=4 read=101765
7. 19.181 5,674.075 ↓ 1,515.2 100,000 1

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

  • Buffers: shared hit=2 read=100937
8. 5,654.894 5,654.894 ↓ 1,515.2 100,000 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail entity_detail_1 (cost=0.70..257.92 rows=66 width=16) (actual time=45.531..5,654.894 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=100937
9. 0.748 4,611.954 ↓ 2.1 821 1

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

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

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail entity_detail_2 (cost=0.70..1,527.62 rows=394 width=16) (actual time=37.103..4,611.206 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