explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hXtS : Optimization for: dc; plan #Q2On

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.425 81.311 ↓ 571.0 571 1

Nested Loop (cost=180.44..107,265.50 rows=1 width=82) (actual time=0.240..81.311 rows=571 loops=1)

2. 0.964 4.514 ↓ 114.2 571 1

Nested Loop (cost=92.35..32,842.55 rows=5 width=99) (actual time=0.158..4.514 rows=571 loops=1)

  • Join Filter: (role.id = unite_evaluation.role)
3. 0.368 0.695 ↑ 4.8 571 1

Nested Loop (cost=91.79..15,179.19 rows=2,768 width=67) (actual time=0.135..0.695 rows=571 loops=1)

4. 0.005 0.060 ↑ 1.0 1 1

Nested Loop (cost=0.57..16.62 rows=1 width=22) (actual time=0.056..0.060 rows=1 loops=1)

5. 0.040 0.040 ↑ 1.0 1 1

Index Scan using exercice_organisme_code_geo_annee_exercice_key on exercice_organisme (cost=0.29..8.30 rows=1 width=22) (actual time=0.039..0.040 rows=1 loops=1)

  • Index Cond: (((code_geo)::text = '31050'::text) AND (annee_exercice = 2018))
6. 0.015 0.015 ↑ 1.0 1 1

Index Scan using role_exercice_organisme_idx on role (cost=0.29..8.30 rows=1 width=8) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: (exercice_organisme = exercice_organisme.id)
7. 0.206 0.267 ↑ 9.7 571 1

Bitmap Heap Scan on exploitation_identification_unite_evaluation_m (cost=91.22..15,106.98 rows=5,559 width=45) (actual time=0.075..0.267 rows=571 loops=1)

  • Recheck Cond: (id_role = role.id)
  • Heap Blocks: exact=8
8. 0.061 0.061 ↑ 9.7 571 1

Bitmap Index Scan on exploitation_identification_unite_evaluation_m_id_role_idx (cost=0.00..89.83 rows=5,559 width=0) (actual time=0.061..0.061 rows=571 loops=1)

  • Index Cond: (id_role = role.id)
9. 2.855 2.855 ↑ 1.0 1 571

Index Scan using unite_evaluation_id_idx on unite_evaluation (cost=0.56..6.37 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=571)

  • Index Cond: (id = exploitation_identification_unite_evaluation_m.id_unite_evaluation)
  • Filter: (exploitation_identification_unite_evaluation_m.id_role = role)
10. 54.245 75.372 ↑ 1.0 1 571

Bitmap Heap Scan on exploitation_caracteristiques_unite_evaluation_m (cost=88.08..14,884.58 rows=1 width=11) (actual time=0.089..0.132 rows=1 loops=571)

  • Recheck Cond: (id_role = unite_evaluation.role)
  • Filter: (unite_evaluation.id = id_unite_evaluation)
  • Rows Removed by Filter: 570
  • Heap Blocks: exact=4568
11. 21.127 21.127 ↑ 9.6 571 571

Bitmap Index Scan on exploitation_caracteristiques_unite_evaluation_m_id_role_idx (cost=0.00..88.08 rows=5,508 width=0) (actual time=0.037..0.037 rows=571 loops=571)

  • Index Cond: (id_role = unite_evaluation.role)
Planning time : 3.907 ms