explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FMnp : group by

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 0.411 ↑ 1.0 1 1

Group (cost=75.42..75.49 rows=1 width=152,085) (actual time=0.405..0.411 rows=1 loops=1)

  • Group Key: f_p_person0_.bpp_ident, t_clititre1_.tit_ident, t_catprof2_.cat_ident, t_professi3_.pro_ident, t_naf4_.tnaf_ident, t_etabliss5_.ta_ident, t_societe6_.ta_code, f_p_c_clie7_.bpcl_ident, t_clifam8_.fam_ident, t_clisfam9_.sfa_ident, f_p_c_assu10_.bpass_ident, f_p_c_cnds16_.bpcnd_ident, f_p_c_corr11_.bpcor_ident, f_p_c_corr12_.bpcor_ident, f_intermed13_.in_ident, f_compagni14_.co_ident, f_p_c_user15_.bput_ident, f_p_c_clie7_.bpcl_ident, f_p_c_assu10_.bpass_ident, f_p_c_cnds16_.bpcnd_ident, f_p_c_corr11_.bpcor_ident, f_p_c_corr12_.bpcor_ident, f_intermed13_.in_ident, f_compagni14_.co_ident, f_p_c_user15_.bput_ident
2. 0.017 0.379 ↑ 1.0 1 1

Sort (cost=75.42..75.42 rows=1 width=151,941) (actual time=0.375..0.379 rows=1 loops=1)

  • Sort Key: t_clititre1_.tit_ident, t_catprof2_.cat_ident, t_professi3_.pro_ident, t_naf4_.tnaf_ident, t_etabliss5_.ta_ident, t_societe6_.ta_code, f_p_c_clie7_.bpcl_ident, t_clifam8_.fam_ident, t_clisfam9_.sfa_ident, f_p_c_assu10_.bpass_ident, f_p_c_cnds16_.bpcnd_ident, f_p_c_corr11_.bpcor_ident, f_p_c_corr12_.bpcor_ident, f_intermed13_.in_ident, f_compagni14_.co_ident, f_p_c_user15_.bput_ident
  • Sort Method: quicksort Memory: 25kB
3. 0.025 0.362 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.31..75.41 rows=1 width=151,941) (actual time=0.354..0.362 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_p_c_user15_.bput_ptrbppid)
4. 0.024 0.330 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.31..74.08 rows=1 width=144,975) (actual time=0.321..0.330 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_compagni14_.co_ptrbppident)
5. 0.030 0.302 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.31..73.06 rows=1 width=137,363) (actual time=0.294..0.302 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_intermed13_.in_ptrbppident)
6. 0.019 0.266 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.18..64.90 rows=1 width=112,023) (actual time=0.258..0.266 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_p_c_corr12_.bpcor_ptrbppident)
7. 0.017 0.244 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.18..54.89 rows=1 width=94,991) (actual time=0.237..0.244 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_p_c_corr11_.bpcor_ptrbppident)
8. 0.015 0.226 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.18..44.88 rows=1 width=77,959) (actual time=0.219..0.226 rows=1 loops=1)

  • Join Filter: (f_p_c_assu10_.bpass_ident = f_p_c_cnds16_.bpcnd_ptrbpassid)
  • Rows Removed by Join Filter: 1
9. 0.014 0.209 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.18..43.86 rows=1 width=76,975) (actual time=0.203..0.209 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_p_c_assu10_.bpass_ptrbppident)
10. 0.015 0.191 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.18..42.83 rows=1 width=65,545) (actual time=0.185..0.191 rows=1 loops=1)

11. 0.015 0.172 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.04..34.55 rows=1 width=65,009) (actual time=0.166..0.172 rows=1 loops=1)

  • Join Filter: (f_p_c_clie7_.bpcl_ptrfamid = t_clifam8_.fam_ident)
  • Rows Removed by Join Filter: 26
12. 0.013 0.153 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.04..32.97 rows=1 width=64,491) (actual time=0.147..0.153 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_p_c_clie7_.bpcl_ptrbppident)
13. 0.013 0.136 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.04..31.94 rows=1 width=37,311) (actual time=0.130..0.136 rows=1 loops=1)

  • Join Filter: ((f_p_person0_.bpp_societe)::text = (t_societe6_.ta_code)::text)
  • Rows Removed by Join Filter: 2
14. 0.011 0.120 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.04..30.88 rows=1 width=30,281) (actual time=0.115..0.120 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ptrcatid = t_catprof2_.cat_ident)
  • Rows Removed by Join Filter: 29
15. 0.009 0.104 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.04..29.22 rows=1 width=29,763) (actual time=0.099..0.104 rows=1 loops=1)

16. 0.006 0.090 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.90..19.61 rows=1 width=21,687) (actual time=0.086..0.090 rows=1 loops=1)

17. 0.009 0.079 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.62..11.31 rows=1 width=21,630) (actual time=0.075..0.079 rows=1 loops=1)

18. 0.025 0.064 ↑ 1.0 1 1

Hash Right Join (cost=1.35..2.98 rows=1 width=21,450) (actual time=0.061..0.064 rows=1 loops=1)

  • Hash Cond: (t_clititre1_.tit_ident = f_p_person0_.bpp_ptrcliid)
19. 0.008 0.008 ↑ 1.0 49 1

Seq Scan on t_clititre t_clititre1_ (cost=0.00..1.49 rows=49 width=708) (actual time=0.004..0.008 rows=49 loops=1)

20. 0.006 0.031 ↑ 1.0 1 1

Hash (cost=1.34..1.34 rows=1 width=20,742) (actual time=0.030..0.031 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
21. 0.025 0.025 ↑ 1.0 1 1

Seq Scan on f_p_personne f_p_person0_ (cost=0.00..1.34 rows=1 width=20,742) (actual time=0.024..0.025 rows=1 loops=1)

  • Filter: (bpp_ident = '1'::numeric)
  • Rows Removed by Filter: 26
22. 0.006 0.006 ↓ 0.0 0 1

Index Scan using pk_pro_ident on t_profession t_professi3_ (cost=0.27..8.29 rows=1 width=180) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (pro_ident = f_p_person0_.bpp_ptrproid)
23. 0.005 0.005 ↓ 0.0 0 1

Index Scan using pk_tnaf_ident on t_naf t_naf4_ (cost=0.28..8.29 rows=1 width=57) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (tnaf_ident = f_p_person0_.bpp_ptrtnafid)
24. 0.005 0.005 ↓ 0.0 0 1

Index Scan using t_etabliss_pk on t_etabliss t_etabliss5_ (cost=0.14..8.15 rows=1 width=8,076) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (ta_ident = f_p_person0_.bpp_ptretabident)
25. 0.005 0.005 ↑ 1.0 29 1

Seq Scan on t_catprof t_catprof2_ (cost=0.00..1.29 rows=29 width=518) (actual time=0.003..0.005 rows=29 loops=1)

26. 0.003 0.003 ↑ 1.0 3 1

Seq Scan on t_societe t_societe6_ (cost=0.00..1.03 rows=3 width=7,030) (actual time=0.003..0.003 rows=3 loops=1)

27. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on f_p_c_client f_p_c_clie7_ (cost=0.00..1.01 rows=1 width=27,180) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (bpcl_ptrbppident = '1'::numeric)
  • Rows Removed by Filter: 1
28. 0.004 0.004 ↑ 1.0 26 1

Seq Scan on t_clifam t_clifam8_ (cost=0.00..1.26 rows=26 width=518) (actual time=0.003..0.004 rows=26 loops=1)

29. 0.004 0.004 ↓ 0.0 0 1

Index Scan using pk_sfa_ident on t_clisfam t_clisfam9_ (cost=0.14..8.16 rows=1 width=536) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (sfa_ident = f_p_c_clie7_.bpcl_ptrsfaid)
30. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on f_p_c_assure f_p_c_assu10_ (cost=0.00..1.01 rows=1 width=11,430) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (bpass_ptrbppident = '1'::numeric)
  • Rows Removed by Filter: 1
31. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on f_p_c_cnd f_p_c_cnds16_ (cost=0.00..1.01 rows=1 width=984) (actual time=0.002..0.002 rows=1 loops=1)

32. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on f_p_c_corresp f_p_c_corr11_ (cost=0.00..10.00 rows=1 width=17,032) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (bpcor_ptrbppident = '1'::numeric)
33. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on f_p_c_corresp f_p_c_corr12_ (cost=0.00..10.00 rows=1 width=17,032) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (bpcor_ptrbppident = '1'::numeric)
34. 0.006 0.006 ↓ 0.0 0 1

Index Scan using ind_in_ptrbppident on f_intermediaire f_intermed13_ (cost=0.12..8.14 rows=1 width=25,340) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (in_ptrbppident = '1'::numeric)
35. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on f_compagnies f_compagni14_ (cost=0.00..1.01 rows=1 width=7,612) (actual time=0.003..0.004 rows=0 loops=1)

  • Filter: (co_ptrbppident = '1'::numeric)
  • Rows Removed by Filter: 1
36. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on f_p_c_user f_p_c_user15_ (cost=0.00..1.31 rows=1 width=6,822) (actual time=0.006..0.007 rows=1 loops=1)

  • Filter: (bput_ptrbppid = '1'::numeric)
  • Rows Removed by Filter: 24