explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dowH : v1 15 fois

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.268 ↓ 6.5 13 1

Hash Left Join (cost=11.54..83.67 rows=2 width=860) (actual time=0.146..0.268 rows=13 loops=1)

  • Hash Cond: (sm001000_pi8_action_dossierbase.sm001000_pi9_nature_evenement_affaireid = sm001000_pi8_est_associe_9ext.sm001000_pi9_nature_evenement_affaireid)
2. 0.000 0.220 ↓ 6.5 13 1

Nested Loop Left Join (cost=6.45..78.57 rows=2 width=823) (actual time=0.101..0.220 rows=13 loops=1)

3. 0.006 0.207 ↓ 6.5 13 1

Nested Loop Left Join (cost=6.16..61.96 rows=2 width=753) (actual time=0.099..0.207 rows=13 loops=1)

  • Join Filter: (sm001000_pi8_action_dossierbase.sm001000_pi9_role_metierid = sm001000_pi8_est_associe_5ext.sm001000_pi9_role_metierid)
  • Rows Removed by Join Filter: 61
4. 0.020 0.188 ↓ 6.5 13 1

Nested Loop Left Join (cost=6.16..60.58 rows=2 width=721) (actual time=0.094..0.188 rows=13 loops=1)

  • Join Filter: (sm001000_pi8_action_dossierbase.sm001000_pi9_patron_actionid = sm001000_pi8_correspond_2ext.sm001000_pi9_patron_actionid)
  • Rows Removed by Join Filter: 165
5. 0.011 0.155 ↓ 6.5 13 1

Hash Left Join (cost=6.16..58.90 rows=2 width=689) (actual time=0.083..0.155 rows=13 loops=1)

  • Hash Cond: (sm001000_pi8_action_dossierbase.sm001000_pi9_patron_decisionid = sm001000_pi8_concerne_9ext.sm001000_pi9_patron_decisionid)
6. 0.004 0.105 ↓ 6.5 13 1

Nested Loop Left Join (cost=1.40..54.14 rows=2 width=649) (actual time=0.038..0.105 rows=13 loops=1)

  • Join Filter: (sm001000_pi8_action_dossierbase.sm001000_pi8_etape_dossierid = sm001000_pi8_contientext.sm001000_pi8_etape_dossierid)
7. 0.011 0.088 ↓ 6.5 13 1

Nested Loop Left Join (cost=0.98..45.66 rows=2 width=631) (actual time=0.026..0.088 rows=13 loops=1)

8. 0.007 0.064 ↓ 6.5 13 1

Nested Loop Left Join (cost=0.70..29.06 rows=2 width=584) (actual time=0.020..0.064 rows=13 loops=1)

9. 0.031 0.031 ↓ 6.5 13 1

Index Scan using ix_etp_natr_actn00000 on sm001000_pi8_action_dossierbase (cost=0.42..12.45 rows=2 width=582) (actual time=0.013..0.031 rows=13 loops=1)

  • Index Cond: (sm001000_pi8_etape_dossierid = '3d87a85c-99f2-e411-9beb-005056a2625c'::uuid)
10. 0.026 0.026 ↑ 1.0 1 13

Index Scan using pk_1954106002_cndx_primarykey_systemuser on systemuserbase sm001000_pi8_est_assigne (cost=0.28..8.29 rows=1 width=34) (actual time=0.002..0.002 rows=1 loops=13)

  • Index Cond: (sm001000_pi8_action_dossierbase.sm001000_systemuserid = systemuserid)
11. 0.013 0.013 ↑ 1.0 1 13

Index Scan using pk_1269136558_pk_sm001000_pi8_action_programmebase on sm001000_pi8_action_programmebase sm001000_pi8_concerne_8ext (cost=0.28..8.30 rows=1 width=63) (actual time=0.001..0.001 rows=1 loops=13)

  • Index Cond: (sm001000_pi8_action_dossierbase.sm001000_pi8_action_programmeid = sm001000_pi8_action_programmeid)
12. 0.004 0.013 ↑ 1.0 1 13

Materialize (cost=0.42..8.45 rows=1 width=34) (actual time=0.001..0.001 rows=1 loops=13)

13. 0.009 0.009 ↑ 1.0 1 1

Index Scan using pk_1176612226_pk_sm001000_pi8_etape_dossierbase on sm001000_pi8_etape_dossierbase sm001000_pi8_contientext (cost=0.42..8.44 rows=1 width=34) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (sm001000_pi8_etape_dossierid = '3d87a85c-99f2-e411-9beb-005056a2625c'::uuid)
14. 0.013 0.039 ↑ 1.0 78 1

Hash (cost=3.78..3.78 rows=78 width=56) (actual time=0.039..0.039 rows=78 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
15. 0.026 0.026 ↑ 1.0 78 1

Seq Scan on sm001000_pi9_patron_decisionbase sm001000_pi8_concerne_9ext (cost=0.00..3.78 rows=78 width=56) (actual time=0.007..0.026 rows=78 loops=1)

16. 0.007 0.013 ↑ 1.1 14 13

Materialize (cost=0.00..1.24 rows=16 width=48) (actual time=0.000..0.001 rows=14 loops=13)

17. 0.006 0.006 ↑ 1.1 15 1

Seq Scan on sm001000_pi9_patron_actionbase sm001000_pi8_correspond_2ext (cost=0.00..1.16 rows=16 width=48) (actual time=0.003..0.006 rows=15 loops=1)

18. 0.008 0.013 ↑ 1.8 5 13

Materialize (cost=0.00..1.14 rows=9 width=48) (actual time=0.000..0.001 rows=5 loops=13)

19. 0.005 0.005 ↑ 1.0 9 1

Seq Scan on sm001000_pi9_role_metierbase sm001000_pi8_est_associe_5ext (cost=0.00..1.09 rows=9 width=48) (actual time=0.003..0.005 rows=9 loops=1)

20. 0.013 0.013 ↓ 0.0 0 13

Index Scan using pk_1411041054_pk_sm001000_pi8_choix_decisionbase on sm001000_pi8_choix_decisionbase sm001000_pi8_est_associe_6ext (cost=0.29..8.30 rows=1 width=86) (actual time=0.001..0.001 rows=0 loops=13)

  • Index Cond: (sm001000_pi8_action_dossierbase.sm001000_pi8_choix_decisionid = sm001000_pi8_choix_decisionid)
21. 0.015 0.041 ↑ 1.0 93 1

Hash (cost=3.93..3.93 rows=93 width=53) (actual time=0.041..0.041 rows=93 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
22. 0.026 0.026 ↑ 1.0 93 1

Seq Scan on sm001000_pi9_nature_evenement_affairebase sm001000_pi8_est_associe_9ext (cost=0.00..3.93 rows=93 width=53) (actual time=0.004..0.026 rows=93 loops=1)

Planning time : 2.574 ms
Execution time : 0.404 ms