explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iblx

Settings
# exclusive inclusive rows x rows loops node
1. 0.080 31,231.855 ↑ 5.8 6 1

HashAggregate (cost=983,067.58..983,067.93 rows=35 width=1,028) (actual time=31,231.847..31,231.855 rows=6 loops=1)

  • Group Key: ordrefabri0_.id, ordrefabri0_.id_creeparsysteme, ordrefabri0_.datecreationsysteme, ordrefabri0_.datefinvalidite, ordrefabri0_.datemodificationsysteme, ordrefabri0_.id_modifieparsysteme, ordrefabri0_.id_affaire, ordrefabri0_.id_article, ordrefa (...)
2. 8.384 31,231.775 ↑ 5.8 6 1

Nested Loop Left Join (cost=1.41..983,063.90 rows=35 width=1,028) (actual time=11,833.372..31,231.775 rows=6 loops=1)

  • Join Filter: ((ordrefabri0_.id)::text = (ordrefabri0_3_.id)::text)
  • Rows Removed by Join Filter: 11730
3. 0.035 31,213.017 ↑ 5.8 6 1

Nested Loop Left Join (cost=1.41..981,996.09 rows=35 width=995) (actual time=11,827.861..31,213.017 rows=6 loops=1)

  • Join Filter: ((ordrefabri0_.id)::text = (ordrefabri0_2_.id)::text)
  • Rows Removed by Join Filter: 6
4. 0.034 31,212.934 ↑ 5.8 6 1

Nested Loop Left Join (cost=1.41..981,994.55 rows=35 width=958) (actual time=11,827.805..31,212.934 rows=6 loops=1)

5. 12,916.346 31,212.804 ↑ 5.8 6 1

Merge Left Join (cost=0.99..981,977.98 rows=35 width=892) (actual time=11,827.750..31,212.804 rows=6 loops=1)

  • Merge Cond: ((ordrefabri0_.id)::text = (attributsu1_.id_ordrefabrication)::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: 14095262
6. 1,690.215 1,690.215 ↓ 1.0 818,584 1

Index Scan using dm5_ordrefabrication_pkey on dm5_ordrefabrication ordrefabri0_ (cost=0.42..74,058.43 rows=817,668 width=892) (actual time=0.010..1,690.215 rows=818,584 loops=1)

  • Filter: ((datefinvalidite IS NULL) AND ((id)::text !~~ 'DefaultRecord_%'::text))
  • Rows Removed by Filter: 214
7. 16,606.243 16,606.243 ↓ 1.0 14,098,420 1

Index Scan using dm5_ordrefabrication_cs_pkey on dm5_ordrefabrication_cs attributsu1_ (cost=0.56..624,110.51 rows=14,091,530 width=74) (actual time=0.004..16,606.243 rows=14,098,420 loops=1)

8. 0.096 0.096 ↑ 1.0 1 6

Index Scan using dm5_ordrefabricationcommande_pkey on dm5_ordrefabricationcommande ordrefabri0_1_ (cost=0.42..0.46 rows=1 width=66) (actual time=0.014..0.016 rows=1 loops=6)

  • Index Cond: ((ordrefabri0_.id)::text = (id)::text)
9. 0.026 0.048 ↑ 1.0 1 6

Materialize (cost=0.00..1.01 rows=1 width=37) (actual time=0.007..0.008 rows=1 loops=6)

10. 0.022 0.022 ↑ 1.0 1 1

Seq Scan on dm5_ordrefabricationmanuel ordrefabri0_2_ (cost=0.00..1.01 rows=1 width=37) (actual time=0.021..0.022 rows=1 loops=1)

11. 8.963 10.374 ↑ 1.0 1,955 6

Materialize (cost=0.00..46.32 rows=1,955 width=33) (actual time=0.005..1.729 rows=1,955 loops=6)

12. 1.411 1.411 ↑ 1.0 1,955 1

Seq Scan on dm5_ordrefabricationcbn ordrefabri0_3_ (cost=0.00..36.55 rows=1,955 width=33) (actual time=0.016..1.411 rows=1,955 loops=1)

Planning time : 7.353 ms
Execution time : 31,232.360 ms