explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mBLA : v1

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 70.759 ↓ 6.5 13 1

Hash Left Join (cost=11.54..83.67 rows=2 width=860) (actual time=53.858..70.759 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.021 63.396 ↓ 6.5 13 1

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

3. 0.017 54.457 ↓ 6.5 13 1

Nested Loop Left Join (cost=6.16..61.96 rows=2 width=753) (actual time=46.487..54.457 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.030 51.827 ↓ 6.5 13 1

Nested Loop Left Join (cost=6.16..60.58 rows=2 width=721) (actual time=43.875..51.827 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.036 51.771 ↓ 6.5 13 1

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

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

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

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

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

8. 0.042 12.391 ↓ 6.5 13 1

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

9. 9.983 9.983 ↓ 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=9.940..9.983 rows=13 loops=1)

  • Index Cond: (sm001000_pi8_etape_dossierid = '3d87a85c-99f2-e411-9beb-005056a2625c'::uuid)
10. 2.366 2.366 ↑ 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.182..0.182 rows=1 loops=13)

  • Index Cond: (sm001000_pi8_action_dossierbase.sm001000_systemuserid = systemuserid)
11. 15.249 15.249 ↑ 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=1.173..1.173 rows=1 loops=13)

  • Index Cond: (sm001000_pi8_action_dossierbase.sm001000_pi8_action_programmeid = sm001000_pi8_action_programmeid)
12. 0.017 20.696 ↑ 1.0 1 13

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

13. 20.679 20.679 ↑ 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=20.679..20.679 rows=1 loops=1)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
15. 3.354 3.354 ↑ 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=2.052..3.354 rows=78 loops=1)

16. 0.013 0.026 ↑ 1.1 14 13

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

17. 0.013 0.013 ↑ 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.009..0.013 rows=15 loops=1)

18. 0.012 2.613 ↑ 1.8 5 13

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

19. 2.601 2.601 ↑ 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=2.599..2.601 rows=9 loops=1)

20. 8.918 8.918 ↓ 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.686..0.686 rows=0 loops=13)

  • Index Cond: (sm001000_pi8_action_dossierbase.sm001000_pi8_choix_decisionid = sm001000_pi8_choix_decisionid)
21. 0.029 7.341 ↑ 1.0 93 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
22. 7.312 7.312 ↑ 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.008..7.312 rows=93 loops=1)

Planning time : 149.725 ms
Execution time : 71.039 ms