explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G1pa

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 122.897 ↑ 1.0 100 1

Limit (cost=164,120.39..164,120.64 rows=100 width=895) (actual time=122.873..122.897 rows=100 loops=1)

2. 2.294 122.880 ↑ 5.7 100 1

Sort (cost=164,120.39..164,121.81 rows=568 width=895) (actual time=122.872..122.880 rows=100 loops=1)

  • Sort Key: ordrefabri0_.datecreationsysteme
  • Sort Method: top-N heapsort Memory: 76kB
3. 1.201 120.586 ↓ 2.3 1,287 1

Nested Loop Left Join (cost=0.00..164,098.68 rows=568 width=895) (actual time=0.279..120.586 rows=1,287 loops=1)

4. 0.721 118.098 ↓ 2.3 1,287 1

Nested Loop Left Join (cost=0.00..163,940.33 rows=568 width=862) (actual time=0.272..118.098 rows=1,287 loops=1)

5. 1.444 113.516 ↓ 2.3 1,287 1

Nested Loop Left Join (cost=0.00..163,746.05 rows=568 width=829) (actual time=0.264..113.516 rows=1,287 loops=1)

6. 1.668 109.498 ↓ 2.3 1,287 1

Nested Loop (cost=0.00..163,541.22 rows=568 width=763) (actual time=0.257..109.498 rows=1,287 loops=1)

7. 2.007 103.816 ↓ 2.2 1,338 1

Nested Loop (cost=0.00..163,314.79 rows=622 width=763) (actual time=0.247..103.816 rows=1,338 loops=1)

8. 1.414 1.414 ↑ 1.0 1,455 1

Index Scan using "863_4705" on dm3_gammenomenclature gammenomen2_ (cost=0.00..468.81 rows=1,455 width=32) (actual time=0.014..1.414 rows=1,455 loops=1)

  • Index Cond: (id_affaire IS NOT NULL)
9. 8.004 100.395 ↑ 1.0 1 1,455

Index Scan using "516_3793" on dm5_ordrefabrication ordrefabri0_ (cost=0.00..111.91 rows=1 width=763) (actual time=0.069..0.069 rows=1 loops=1,455)

  • Index Cond: ((id_gammenomenclature)::text = (gammenomen2_.id)::text)
  • Filter: ((datefinvalidite IS NULL) AND (id_affaire IS NOT NULL) AND ((id)::text !~~ 'DefaultRecord_%'::text) AND (0 < (SubPlan 1)))
  • Rows Removed by Filter: 0
10.          

SubPlan (for Index Scan)

11. 2.678 92.391 ↑ 1.0 1 1,339

Aggregate (cost=53.61..53.62 rows=1 width=32) (actual time=0.069..0.069 rows=1 loops=1,339)

12. 8.748 89.713 ↓ 1.9 13 1,339

Nested Loop (cost=0.00..53.59 rows=7 width=32) (actual time=0.019..0.067 rows=13 loops=1,339)

13. 5.356 29.458 ↓ 1.9 13 1,339

Nested Loop (cost=0.00..18.95 rows=7 width=65) (actual time=0.013..0.022 rows=13 loops=1,339)

14. 4.017 4.017 ↑ 1.0 1 1,339

Index Only Scan using "516_1174" on dm5_ordrefabrication ordrefabri3_ (cost=0.00..4.28 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1,339)

  • Index Cond: (id = (ordrefabri0_.id)::text)
  • Heap Fetches: 123
15. 20.085 20.085 ↓ 1.9 13 1,339

Index Scan using "idx_nf_ssb5-2006" on dm5_operationordrefabrication listeopera4_ (cost=0.00..14.60 rows=7 width=65) (actual time=0.009..0.015 rows=13 loops=1,339)

  • Index Cond: ((id_ordrefabrication)::text = (ordrefabri0_.id)::text)
16. 51.507 51.507 ↑ 1.0 1 17,169

Index Only Scan using "779_1948" on dm1_operation listeopera4_1_ (cost=0.00..4.94 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=17,169)

  • Index Cond: (id = (listeopera4_.id)::text)
  • Heap Fetches: 1882
17. 4.014 4.014 ↑ 1.0 1 1,338

Index Scan using "759_1897" on dm6_affaire affaireent1_ (cost=0.00..0.35 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1,338)

  • Index Cond: ((id)::text = (ordrefabri0_.id_affaire)::text)
  • Filter: ((etataffaire)::text <> '2'::text)
  • Rows Removed by Filter: 0
18. 2.574 2.574 ↓ 0.0 0 1,287

Index Scan using "350_685" on dm5_ordrefabricationcommande ordrefabri0_1_ (cost=0.00..0.35 rows=1 width=66) (actual time=0.002..0.002 rows=0 loops=1,287)

  • Index Cond: ((ordrefabri0_.id)::text = (id)::text)
19. 3.861 3.861 ↑ 1.0 1 1,287

Index Only Scan using "351_687" on dm5_ordrefabricationmanuel ordrefabri0_2_ (cost=0.00..0.33 rows=1 width=33) (actual time=0.003..0.003 rows=1 loops=1,287)

  • Index Cond: (id = (ordrefabri0_.id)::text)
  • Heap Fetches: 10
20. 1.287 1.287 ↓ 0.0 0 1,287

Index Only Scan using "349_683" on dm5_ordrefabricationcbn ordrefabri0_3_ (cost=0.00..0.27 rows=1 width=33) (actual time=0.001..0.001 rows=0 loops=1,287)

  • Index Cond: (id = (ordrefabri0_.id)::text)
  • Heap Fetches: 0
Total runtime : 123.155 ms