explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w02y

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.215 ↑ 2.0 1 1

Nested Loop Left Join (cost=9.77..55.85 rows=2 width=80) (actual time=0.199..0.215 rows=1 loops=1)

2. 0.002 0.146 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.14..30.81 rows=1 width=28) (actual time=0.132..0.146 rows=1 loops=1)

3. 0.001 0.138 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.14..29.74 rows=1 width=24) (actual time=0.125..0.138 rows=1 loops=1)

4. 0.002 0.118 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.14..27.92 rows=1 width=20) (actual time=0.111..0.118 rows=1 loops=1)

5. 0.002 0.107 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.14..26.56 rows=1 width=16) (actual time=0.100..0.107 rows=1 loops=1)

6. 0.002 0.088 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.14..25.21 rows=1 width=12) (actual time=0.087..0.088 rows=1 loops=1)

7. 0.006 0.078 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..16.90 rows=1 width=8) (actual time=0.077..0.078 rows=1 loops=1)

8. 0.061 0.061 ↑ 1.0 1 1

Index Scan using i_t_dim_bovin_bvn on t_dim_bovin_bvn bvn (cost=0.57..8.59 rows=1 width=4) (actual time=0.061..0.061 rows=1 loops=1)

  • Index Cond: ((bvn_num_bovin)::text = 'FR0185008478'::text)
9. 0.011 0.011 ↑ 1.0 1 1

Index Scan using i_t_dim_age_age on t_dim_age_age age_entree (cost=0.28..8.30 rows=1 width=4) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: ((age_jours)::integer = 2523)
10. 0.008 0.008 ↓ 0.0 0 1

Index Scan using i_t_dim_age_age on t_dim_age_age age (cost=0.28..8.30 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((age_jours)::integer = '-1'::integer)
11. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on t_dim_bov_mouvement_mou mou_entree (cost=0.00..1.34 rows=1 width=4) (actual time=0.012..0.017 rows=1 loops=1)

  • Filter: (((mou_type_mouvement)::text = 'E'::text) AND ((mou_cause_mouvement)::text = 'A'::text))
  • Rows Removed by Filter: 22
12. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on t_dim_bov_mouvement_mou mou_sortie (cost=0.00..1.34 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (((mou_type_mouvement)::text = 'S'::text) AND ((mou_cause_mouvement)::text = ''::text))
  • Rows Removed by Filter: 23
13. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on t_dim_race_rac rac (cost=0.00..1.81 rows=1 width=4) (actual time=0.013..0.019 rows=1 loops=1)

  • Filter: ((rac_code_race)::text = '46'::text)
  • Rows Removed by Filter: 64
14. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on t_dim_sexe_sex sex (cost=0.00..1.06 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((sex_detail)::text = '2'::text)
  • Rows Removed by Filter: 5
15. 0.003 0.064 ↑ 2.0 1 1

Nested Loop (cost=8.64..25.01 rows=2 width=4) (actual time=0.062..0.064 rows=1 loops=1)

16. 0.002 0.042 ↑ 2.0 1 1

Unique (cost=8.35..8.36 rows=2 width=32) (actual time=0.041..0.042 rows=1 loops=1)

17. 0.023 0.040 ↑ 2.0 1 1

Sort (cost=8.35..8.35 rows=2 width=32) (actual time=0.040..0.040 rows=1 loops=1)

  • Sort Key: tr_correspondance_anciennes_communes_cac.cac_nouveau_code
  • Sort Method: quicksort Memory: 25kB
18. 0.002 0.017 ↑ 2.0 1 1

Append (cost=0.28..8.34 rows=2 width=32) (actual time=0.016..0.017 rows=1 loops=1)

19. 0.013 0.013 ↓ 0.0 0 1

Index Scan using i_tr_correspondance_anciennes_communes_cac on tr_correspondance_anciennes_communes_cac (cost=0.28..8.30 rows=1 width=6) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((cac_ancien_code)::text = '01079'::text)
20. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.001..0.002 rows=1 loops=1)

21. 0.019 0.019 ↑ 1.0 1 1

Index Scan using i_t_dim_geographique_geo on t_dim_geographique_geo geo (cost=0.29..8.31 rows=1 width=10) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((geo_code_commune)::text = (tr_correspondance_anciennes_communes_cac.cac_nouveau_code)::text)
Planning time : 0.770 ms
Execution time : 0.365 ms