explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YNhq

Settings
# exclusive inclusive rows x rows loops node
1. 111.673 7,961.821 ↓ 120.7 32,600 1

Nested Loop Left Join (cost=63.33..8,944.86 rows=270 width=49) (actual time=0.487..7,961.821 rows=32,600 loops=1)

  • Join Filter: e.default_responsibles
2. 66.869 189.148 ↓ 120.7 32,600 1

Nested Loop (cost=30.96..194.86 rows=270 width=18) (actual time=0.123..189.148 rows=32,600 loops=1)

3. 18.371 63.599 ↓ 120.7 6,520 1

Nested Loop (cost=30.67..157.71 rows=54 width=16) (actual time=0.111..63.599 rows=6,520 loops=1)

4. 12.034 19.128 ↓ 120.8 6,525 1

Nested Loop (cost=30.40..139.26 rows=54 width=16) (actual time=0.099..19.128 rows=6,525 loops=1)

5. 0.019 0.019 ↓ 5.0 5 1

Seq Scan on entity_units (cost=0.00..11.50 rows=1 width=8) (actual time=0.012..0.019 rows=5 loops=1)

  • Filter: (entity_id = 9)
6. 6.690 7.075 ↑ 1.0 1,305 5

Bitmap Heap Scan on entity_unit_variables entityunitvariables (cost=30.40..114.71 rows=1,305 width=12) (actual time=0.087..1.415 rows=1,305 loops=5)

  • Recheck Cond: (entity_unit_id = entity_units.id)
  • Heap Blocks: exact=72
7. 0.385 0.385 ↑ 1.0 1,305 5

Bitmap Index Scan on entity_unit_variables_entity_unit_id_variable_id_key (cost=0.00..30.07 rows=1,305 width=0) (actual time=0.077..0.077 rows=1,305 loops=5)

  • Index Cond: (entity_unit_id = entity_units.id)
8. 26.100 26.100 ↑ 1.0 1 6,525

Index Scan using idx_variables_id on variables (cost=0.28..0.34 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=6,525)

  • Index Cond: (id = entityunitvariables.variable_id)
  • Filter: (status_id <> 4)
  • Rows Removed by Filter: 0
9. 58.680 58.680 ↑ 1.0 5 6,520

Index Scan using idx_entity_unit_variable_entity_variable_dimensions on entity_unit_variable_dimensions e (cost=0.29..0.64 rows=5 width=10) (actual time=0.003..0.009 rows=5 loops=6,520)

  • Index Cond: (entity_unit_variable_id = entityunitvariables.id)
10. 97.800 7,661.000 ↑ 1.0 1 32,600

Aggregate (cost=32.37..32.38 rows=1 width=1) (actual time=0.235..0.235 rows=1 loops=32,600)

11. 228.200 7,563.200 ↑ 1.0 1 32,600

Result (cost=1.11..32.37 rows=1 width=0) (actual time=0.157..0.232 rows=1 loops=32,600)

  • One-Time Filter: e.active
12. 163.000 7,335.000 ↑ 1.0 1 32,600

Nested Loop (cost=1.11..32.37 rows=1 width=0) (actual time=0.152..0.225 rows=1 loops=32,600)

  • Join Filter: (u.id = COALESCE(ledfr.user_id, luug.user_id))
  • Rows Removed by Join Filter: 1
13. 163.000 163.000 ↑ 1.0 1 32,600

Seq Scan on users u (cost=0.00..1.05 rows=1 width=4) (actual time=0.003..0.005 rows=1 loops=32,600)

  • Filter: ((external_id)::text = '79f30646-d7b1-11e8-8dbb-f2801f1b9fd1'::text)
  • Rows Removed by Filter: 5
14. 912.800 7,009.000 ↑ 1.0 2 32,600

Nested Loop Left Join (cost=1.11..31.29 rows=2 width=8) (actual time=0.126..0.215 rows=2 loops=32,600)

  • Join Filter: (luug.user_group_id = ug.id)
  • Rows Removed by Join Filter: 25
15. 163.000 5,379.000 ↑ 1.0 1 32,600

Nested Loop Left Join (cost=1.11..29.69 rows=1 width=8) (actual time=0.106..0.165 rows=1 loops=32,600)

16. 163.000 5,150.800 ↑ 1.0 1 32,600

Nested Loop Left Join (cost=0.98..29.52 rows=1 width=8) (actual time=0.101..0.158 rows=1 loops=32,600)

17. 228.200 4,857.400 ↑ 1.0 1 32,600

Nested Loop (cost=0.70..29.18 rows=1 width=4) (actual time=0.095..0.149 rows=1 loops=32,600)

  • Join Filter: (v.type_id = vt.id)
18. 163.000 4,564.000 ↑ 1.0 1 32,600

Nested Loop (cost=0.70..28.14 rows=1 width=8) (actual time=0.087..0.140 rows=1 loops=32,600)

19. 1,825.600 4,303.200 ↑ 1.0 1 32,600

Nested Loop (cost=0.56..19.97 rows=1 width=12) (actual time=0.082..0.132 rows=1 loops=32,600)

  • Join Filter: (v.family_id = edf.family_id)
  • Rows Removed by Join Filter: 66
20. 260.800 554.200 ↑ 1.0 1 32,600

Nested Loop (cost=0.28..9.68 rows=1 width=16) (actual time=0.012..0.017 rows=1 loops=32,600)

21. 163.000 163.000 ↑ 1.0 1 32,600

Seq Scan on entity_unit_dimensions ed (cost=0.00..1.38 rows=1 width=8) (actual time=0.003..0.005 rows=1 loops=32,600)

  • Filter: ((dimension_id = e.dimension_id) AND (entity_unit_id = entityunitvariables.entity_unit_id))
  • Rows Removed by Filter: 24
22. 130.400 130.400 ↑ 1.0 1 32,600

Index Scan using idx_variables_id on variables v (cost=0.28..8.30 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=32,600)

  • Index Cond: (id = entityunitvariables.variable_id)
  • Filter: (status_id <> 4)
23. 1,923.400 1,923.400 ↑ 1.0 67 32,600

Index Scan using idx_entity_unit_dimension_families_entity_unit_dimension_id on entity_unit_dimension_families edf (cost=0.28..9.45 rows=67 width=12) (actual time=0.004..0.059 rows=67 loops=32,600)

  • Index Cond: (entity_unit_dimension_id = ed.id)
24. 97.800 97.800 ↑ 1.0 1 32,600

Index Scan using "EntityUnit_pkey" on entity_units eu (cost=0.14..8.16 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=32,600)

  • Index Cond: (id = entityunitvariables.entity_unit_id)
  • Filter: (entity_id = 9)
25. 65.200 65.200 ↑ 1.0 1 32,600

Seq Scan on variable_types vt (cost=0.00..1.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=32,600)

  • Filter: ((system_slug)::text = 'base'::text)
  • Rows Removed by Filter: 1
26. 130.400 130.400 ↑ 1.0 1 32,600

Index Scan using idx_entity_unit_dimension_family_responsibles_entity_dimension_ on lnk_entity_unit_dimension_family_responsibles ledfr (cost=0.28..0.33 rows=1 width=12) (actual time=0.003..0.004 rows=1 loops=32,600)

  • Index Cond: (entity_unit_dimension_family_id = edf.id)
27. 65.200 65.200 ↑ 1.0 1 32,600

Index Scan using user_groups_pkey on user_groups ug (cost=0.14..0.16 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=32,600)

  • Index Cond: (id = ledfr.user_group_id)
  • Filter: (active IS NOT FALSE)
28. 717.200 717.200 ↑ 1.0 27 32,600

Seq Scan on lnk_user_user_groups luug (cost=0.00..1.27 rows=27 width=8) (actual time=0.002..0.022 rows=27 loops=32,600)

Planning time : 7.007 ms