explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xq10

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 16,359.528 ↓ 0.0 0 1

HashAggregate (cost=1,239,323.23..1,239,323.58 rows=35 width=1,129) (actual time=16,359.528..16,359.528 rows=0 loops=1)

  • Group Key: ordrefabri0_.id, ordrefabri0_.id_creeparsysteme, ordrefabri0_.datecreationsysteme, ordrefabri0_.datefinvalidite, ordrefabri0_.datemodificationsysteme, ordrefabri0_.id_modifieparsysteme, ordrefabri0_.id_affaire, ordrefabri0_.id_article, ordrefabri0_.codeof, ordrefabri0_.commentaire, ordrefabri0_.id_composantordrefabrication, ordrefabri0_.coutfraisgenerauxprevu_valeur, ordrefabri0_.coutfraisgenerauxreel_valeur, ordrefabri0_.coutrevientprevu_valeur, ordrefabri0_.coutrevientreel_valeur, ordrefabri0_.datecreation, ordrefabri0_.datedebutprevue, ordrefabri0_.datedebutreelle, ordrefabri0_.datefinprevue, ordrefabri0_.datefinreelle, ordrefabri0_.datelancementproduction, ordrefabri0_.id_deroulescenarioquestion, ordrefabri0_.designationarticle, ordrefabri0_.etatavancementof, ordrefabri0_.id_gammenomenclature, ordrefabri0_.id_indicearticle, ordrefabri0_.id_lieustockage, ordrefabri0_.niveauof, ordrefabri0_.origineof, ordrefabri0_.id_programmeproduction, ordrefabri0_.quantitefabriqueeprevue_valeur, ordrefabri0_.quantitefabriqueereelle_valeur, ordrefabri0_.quantiterebutee_valeur, ordrefabri0_.referenceof, ordrefabri0_.statutplanification, ordrefabri0_.statutpublicationbondetravail, ordrefabri0_.statutpublicationfichesuiveuse, ordrefabri0_.statutpublicationlisteaservir, ordrefabri0_.id_typeof, ordrefabri0_.id_unitegestion, ordrefabri0_1_.id_lignecommandevente, CASE WHEN (ordrefabri0_1_.id IS NOT NULL) THEN 1 WHEN (ordrefabri0_2_.id IS NOT NULL) THEN 2 WHEN (ordrefabri0_3_.id IS NOT NULL) THEN 3 WHEN (ordrefabri0_.id IS NOT NULL) THEN 0 ELSE NULL::integer END
2. 0.001 16,359.527 ↓ 0.0 0 1

Nested Loop Left Join (cost=162,921.15..1,239,319.55 rows=35 width=1,129) (actual time=16,359.527..16,359.527 rows=0 loops=1)

3. 0.000 16,359.526 ↓ 0.0 0 1

Hash Left Join (cost=162,920.87..1,239,308.87 rows=35 width=1,096) (actual time=16,359.526..16,359.526 rows=0 loops=1)

  • Hash Cond: ((ordrefabri0_.id)::text = (ordrefabri0_2_.id)::text)
4. 0.001 16,359.526 ↓ 0.0 0 1

Nested Loop Left Join (cost=162,919.85..1,239,307.71 rows=35 width=958) (actual time=16,359.526..16,359.526 rows=0 loops=1)

5. 11,121.172 16,359.525 ↓ 0.0 0 1

Hash Right Join (cost=162,919.42..1,239,289.48 rows=35 width=892) (actual time=16,359.525..16,359.525 rows=0 loops=1)

  • Hash Cond: ((attributsu1_.id_ordrefabrication)::text = (ordrefabri0_.id)::text)
  • Filter: (((ordrefabri0_.codeof)::text = '4466908NESTT'::text) OR (((attributsu1_.clef)::text = 'sup_OrdreFabrication_n_plaque'::text) AND ((attributsu1_.alpha)::text = '4466908NESTT'::text)))
  • Rows Removed by Filter: 14009522
6. 3,280.136 3,280.136 ↑ 1.0 14,012,677 1

Seq Scan on dm5_ordrefabrication_cs attributsu1_ (cost=0.00..331,242.77 rows=14,012,677 width=74) (actual time=0.061..3,280.136 rows=14,012,677 loops=1)

7. 1,263.412 1,958.217 ↑ 1.0 815,818 1

Hash (cost=61,098.40..61,098.40 rows=815,842 width=892) (actual time=1,958.217..1,958.217 rows=815,818 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 12920kB
8. 694.805 694.805 ↑ 1.0 815,818 1

Seq Scan on dm5_ordrefabrication ordrefabri0_ (cost=0.00..61,098.40 rows=815,842 width=892) (actual time=0.151..694.805 rows=815,818 loops=1)

  • Filter: ((datefinvalidite IS NULL) AND ((id)::text !~~ 'DefaultRecord_%'::text))
  • Rows Removed by Filter: 214
9. 0.000 0.000 ↓ 0.0 0

Index Scan using dm5_ordrefabricationcommande_pkey on dm5_ordrefabricationcommande ordrefabri0_1_ (cost=0.42..0.51 rows=1 width=66) (never executed)

  • Index Cond: ((ordrefabri0_.id)::text = (id)::text)
10. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.01..1.01 rows=1 width=138) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on dm5_ordrefabricationmanuel ordrefabri0_2_ (cost=0.00..1.01 rows=1 width=138) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Only Scan using dm5_ordrefabricationcbn_pkey on dm5_ordrefabricationcbn ordrefabri0_3_ (cost=0.28..0.30 rows=1 width=33) (never executed)

  • Index Cond: (id = (ordrefabri0_.id)::text)
  • Heap Fetches: 0
Planning time : 1.105 ms
Execution time : 16,361.325 ms