explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DeCG

Settings
# exclusive inclusive rows x rows loops node
1. 396.695 439.341 ↓ 281.8 18,882 1

Sort (cost=352.33..352.50 rows=67 width=5,885) (actual time=435.965..439.341 rows=18,882 loops=1)

  • Sort Key: champs7_.ordre, champs16_.ordre, champfacet18_.ordre
  • Sort Method: quicksort Memory: 38828kB
  • Buffers: shared hit=6175
2. 24.023 42.646 ↓ 281.8 18,882 1

Hash Left Join (cost=19.16..350.30 rows=67 width=5,885) (actual time=0.679..42.646 rows=18,882 loops=1)

  • Hash Cond: (modeleface15_.id = champs16_.modele_id)
  • Filter: (champfacet18_.actif OR (champfacet18_.actif IS NULL))
  • Buffers: shared hit=6175
3. 1.283 18.263 ↓ 57.2 458 1

Nested Loop Left Join (cost=3.71..333.70 rows=8 width=4,153) (actual time=0.302..18.263 rows=458 loops=1)

  • Join Filter: (facethemat0_.modele_id = modeleface15_.id)
  • Rows Removed by Join Filter: 476
  • Buffers: shared hit=6168
4. 1.153 16.980 ↓ 57.2 458 1

Nested Loop Left Join (cost=3.71..330.05 rows=8 width=3,866) (actual time=0.285..16.980 rows=458 loops=1)

  • Buffers: shared hit=6167
5. 1.097 14.453 ↓ 57.2 458 1

Nested Loop Left Join (cost=3.42..263.61 rows=8 width=3,527) (actual time=0.267..14.453 rows=458 loops=1)

  • Buffers: shared hit=4793
6. 0.945 11.982 ↓ 57.2 458 1

Nested Loop Left Join (cost=3.13..197.17 rows=8 width=3,188) (actual time=0.244..11.982 rows=458 loops=1)

  • Buffers: shared hit=3419
7. 1.586 8.747 ↓ 57.2 458 1

Nested Loop Left Join (cost=2.84..194.58 rows=8 width=2,849) (actual time=0.222..8.747 rows=458 loops=1)

  • Buffers: shared hit=2129
8. 0.603 4.413 ↓ 57.2 458 1

Nested Loop Left Join (cost=2.55..184.26 rows=8 width=2,721) (actual time=0.206..4.413 rows=458 loops=1)

  • Buffers: shared hit=753
9. 0.409 2.214 ↓ 14.2 114 1

Nested Loop Left Join (cost=2.26..96.64 rows=8 width=2,705) (actual time=0.180..2.214 rows=114 loops=1)

  • Buffers: shared hit=439
10. 0.867 1.349 ↓ 14.2 114 1

Nested Loop Left Join (cost=2.12..95.33 rows=8 width=2,417) (actual time=0.164..1.349 rows=114 loops=1)

  • Buffers: shared hit=211
  • -> Index Only Scan using pk_face_thematique_caracterisation on t_face_thematique_caracterisation caracteris8_ (cost=0.28..8.30 rows=1 width=16) (actual time=0.007..0.011 rows=2 l
11. 0.140 0.482 ↓ 7.1 57 1

Nested Loop Left Join (cost=1.84..28.87 rows=8 width=2,401) (actual time=0.145..0.482 rows=57 loops=1)

  • Buffers: shared hit=40
  • Index Cond: (face_thematique_id = facethemat0_.id)
  • Heap Fetches: 114
  • Buffers: shared hit=171
12. 0.020 0.220 ↓ 2.0 2 1

Nested Loop Left Join (cost=1.70..27.50 rows=1 width=1,559) (actual time=0.127..0.220 rows=2 loops=1)

  • Join Filter: (facethemat0_.modele_id = modeleface6_.id)
  • Rows Removed by Join Filter: 17
  • Buffers: shared hit=36
13. 0.011 0.182 ↓ 2.0 2 1

Nested Loop Left Join (cost=1.70..26.05 rows=1 width=1,272) (actual time=0.115..0.182 rows=2 loops=1)

  • Buffers: shared hit=34
14. 0.015 0.155 ↓ 2.0 2 1

Nested Loop Left Join (cost=1.41..25.67 rows=1 width=1,153) (actual time=0.100..0.155 rows=2 loops=1)

  • Buffers: shared hit=28
15. 0.011 0.126 ↓ 2.0 2 1

Nested Loop Left Join (cost=1.13..25.29 rows=1 width=1,034) (actual time=0.083..0.126 rows=2 loops=1)

  • Buffers: shared hit=22
16. 0.010 0.105 ↓ 2.0 2 1

Nested Loop (cost=0.85..24.91 rows=1 width=915) (actual time=0.071..0.105 rows=2 loops=1)

  • Buffers: shared hit=16
17. 0.049 0.077 ↓ 2.0 2 1

Nested Loop (cost=0.57..16.61 rows=1 width=796) (actual time=0.052..0.077 rows=2 loops=1)

  • Buffers: shared hit=10
  • -> Index Scan using "unique-facethematique-reference-par-constat" on t_face_thematique facethemat0_ (cost=0.29..8.30 rows=1 width=677) (
  • Index Cond: (coeur_constat_id = 597240)
  • Buffers: shared hit=4
18. 0.028 0.028 ↑ 1.0 1 2

Index Scan using index_code_entite on t_entite entite1_ (cost=0.28..8.30 rows=1 width=119) (actual time=0.014..0.014 rows=1 loops=2)

  • Index Cond: ((code)::text = (facethemat0_.code_ent_mere)::text)
  • Buffers: shared hit=6
19. 0.018 0.018 ↑ 1.0 1 2

Index Scan using index_code_entite on t_entite entite2_ (cost=0.28..8.30 rows=1 width=119) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: ((code)::text = (facethemat0_.code_ent_fille_responsable)::text)
  • Buffers: shared hit=6
20. 0.010 0.010 ↑ 1.0 1 2

Index Scan using index_code_entite on t_entite entite3_ (cost=0.28..0.38 rows=1 width=119) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: ((entite2_.parent)::text = (code)::text)
  • Buffers: shared hit=6
21. 0.014 0.014 ↑ 1.0 1 2

Index Scan using index_code_entite on t_entite entite4_ (cost=0.28..0.38 rows=1 width=119) (actual time=0.007..0.007 rows=1 loops=2)

  • Index Cond: ((entite3_.parent)::text = (code)::text)
  • Buffers: shared hit=6
22. 0.016 0.016 ↑ 1.0 1 2

Index Scan using index_code_entite on t_entite entite5_ (cost=0.28..0.38 rows=1 width=119) (actual time=0.008..0.008 rows=1 loops=2)

  • Index Cond: ((entite4_.parent)::text = (code)::text)
  • Buffers: shared hit=6
23. 0.018 0.018 ↑ 2.0 10 2

Seq Scan on t_modele_face_thematique modeleface6_ (cost=0.00..1.20 rows=20 width=287) (actual time=0.008..0.009 rows=10 loops=2)

  • Buffers: shared hit=2
24. 0.122 0.122 ↓ 3.5 28 2

Index Scan using idx_t_champ_face_thematique_01 on t_champ_face_thematique champs7_ (cost=0.14..1.29 rows=8 width=842) (actual time=0.013..0.061 rows=28 loops=2)

  • Index Cond: (modeleface6_.id = modele_id)
  • Buffers: shared hit=4
25. 0.456 0.456 ↑ 1.0 1 114

Index Scan using pk_caracterisation on t_caracterisation caracteris9_ (cost=0.14..0.16 rows=1 width=288) (actual time=0.004..0.004 rows=1 loops=114)

  • Index Cond: (caracteris8_.caracterisation_id = id)
  • Buffers: shared hit=228
26. 1.596 1.596 ↓ 2.0 4 114

Index Only Scan using pk_face_thematique_piece_jointe on t_face_thematique_piece_jointe piecesjoin10_ (cost=0.29..10.93 rows=2 width=16) (actual time=0.004..0.014 rows=4 loops=114)

  • Index Cond: (face_thematique_id = facethemat0_.id)
  • Heap Fetches: 430
  • Buffers: shared hit=314
27. 2.748 2.748 ↑ 1.0 1 458

Index Scan using pk_piece_jointe on t_piece_jointe piecejoint11_ (cost=0.29..1.29 rows=1 width=128) (actual time=0.006..0.006 rows=1 loops=458)

  • Index Cond: (piecesjoin10_.piece_jointe_id = id)
  • Buffers: shared hit=1376
28. 2.290 2.290 ↑ 1.0 1 458

Index Scan using utilisateur_nni_unique on t_utilisateur utilisateu12_ (cost=0.29..0.32 rows=1 width=339) (actual time=0.005..0.005 rows=1 loops=458)

  • Index Cond: ((piecejoint11_.creation_login)::text = (nni)::text)
  • Buffers: shared hit=1290
29. 1.374 1.374 ↑ 1.0 1 458

Index Scan using utilisateur_nni_unique on t_utilisateur utilisateu13_ (cost=0.29..8.30 rows=1 width=339) (actual time=0.003..0.003 rows=1 loops=458)

  • Index Cond: ((facethemat0_.creation_login)::text = (nni)::text)
  • Buffers: shared hit=1374
30. 1.374 1.374 ↑ 1.0 1 458

Index Scan using utilisateur_nni_unique on t_utilisateur utilisateu14_ (cost=0.29..8.30 rows=1 width=339) (actual time=0.003..0.003 rows=1 loops=458)

  • Index Cond: ((facethemat0_.modification_login)::text = (nni)::text)
  • Buffers: shared hit=1374
31. 0.000 0.000 ↑ 10.0 2 458

Materialize (cost=0.00..1.30 rows=20 width=287) (actual time=0.000..0.000 rows=2 loops=458)

  • Buffers: shared hit=1
32. 0.008 0.008 ↑ 1.1 18 1

Seq Scan on t_modele_face_thematique modeleface15_ (cost=0.00..1.20 rows=20 width=287) (actual time=0.004..0.008 rows=18 loops=1)

  • Buffers: shared hit=1
33. 0.114 0.360 ↑ 1.0 174 1

Hash (cost=13.25..13.25 rows=177 width=1,700) (actual time=0.360..0.360 rows=174 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
  • Buffers: shared hit=7
34. 0.126 0.246 ↓ 1.0 183 1

Hash Left Join (cost=6.84..13.25 rows=177 width=1,700) (actual time=0.106..0.246 rows=183 loops=1)

  • Hash Cond: (champs16_.id = colonnes17_.champ_face_thematique_id)
  • Buffers: shared hit=7
35. 0.032 0.032 ↑ 1.0 177 1

Seq Scan on t_champ_face_thematique champs16_ (cost=0.00..4.77 rows=177 width=842) (actual time=0.006..0.032 rows=177 loops=1)

  • Buffers: shared hit=3
36. 0.013 0.088 ↑ 1.0 9 1

Hash (cost=6.73..6.73 rows=9 width=858) (actual time=0.088..0.088 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=4
37. 0.037 0.075 ↑ 1.0 9 1

Hash Right Join (cost=1.20..6.73 rows=9 width=858) (actual time=0.055..0.075 rows=9 loops=1)

  • Hash Cond: (champfacet18_.id = colonnes17_.colonne_id)
  • Buffers: shared hit=4
38. 0.026 0.026 ↑ 1.0 177 1

Seq Scan on t_champ_face_thematique champfacet18_ (cost=0.00..4.77 rows=177 width=842) (actual time=0.004..0.026 rows=177 loops=1)

  • Buffers: shared hit=3
39. 0.006 0.012 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=16) (actual time=0.012..0.012 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
40. 0.006 0.006 ↑ 1.0 9 1

Seq Scan on t_champ_face_thematique_colonne colonnes17_ (cost=0.00..1.09 rows=9 width=16) (actual time=0.004..0.006 rows=9 loops=1)

  • Buffers: shared hit=1
Planning time : 7.994 ms
Execution time : 443.811 ms