explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XzWs : v2 15 fois

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.304 ↓ 6.5 13 1

Nested Loop Left Join (cost=17.96..82.45 rows=2 width=860) (actual time=0.206..0.304 rows=13 loops=1)

2. 0.002 0.281 ↓ 6.5 13 1

Nested Loop Left Join (cost=17.68..65.85 rows=2 width=813) (actual time=0.201..0.281 rows=13 loops=1)

3. 0.019 0.266 ↓ 6.5 13 1

Nested Loop Left Join (cost=17.39..49.24 rows=2 width=743) (actual time=0.197..0.266 rows=13 loops=1)

  • Join Filter: (sm001000_pi8_action_dossier.sm001000_pi9_patron_actionid = sm001000_pi8_correspond_2ext.sm001000_pi9_patron_actionid)
  • Rows Removed by Join Filter: 165
4. 0.005 0.234 ↓ 6.5 13 1

Nested Loop Left Join (cost=17.39..47.56 rows=2 width=711) (actual time=0.185..0.234 rows=13 loops=1)

  • Join Filter: (sm001000_pi8_action_dossier.sm001000_pi8_etape_dossierid = sm001000_pi8_contientext.sm001000_pi8_etape_dossierid)
5. 0.012 0.216 ↓ 6.5 13 1

Nested Loop Left Join (cost=16.97..39.09 rows=2 width=693) (actual time=0.172..0.216 rows=13 loops=1)

  • Join Filter: (sm001000_pi8_action_dossier.sm001000_pi9_role_metierid = sm001000_pi8_est_associe_5ext.sm001000_pi9_role_metierid)
  • Rows Removed by Join Filter: 61
6. 0.005 0.191 ↓ 6.5 13 1

Nested Loop Left Join (cost=16.97..37.70 rows=2 width=661) (actual time=0.158..0.191 rows=13 loops=1)

7. 0.042 0.160 ↓ 6.5 13 1

Hash Right Join (cost=16.69..21.10 rows=2 width=643) (actual time=0.153..0.160 rows=13 loops=1)

  • Hash Cond: (sm001000_pi8_est_associe_9ext.sm001000_pi9_nature_evenement_affaireid = sm001000_pi8_action_dossier.sm001000_pi9_nature_evenement_affaireid)
8. 0.012 0.012 ↑ 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.003..0.012 rows=93 loops=1)

9. 0.009 0.106 ↓ 6.5 13 1

Hash (cost=16.67..16.67 rows=2 width=606) (actual time=0.106..0.106 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
10. 0.028 0.097 ↓ 6.5 13 1

Hash Right Join (cost=12.48..16.67 rows=2 width=606) (actual time=0.084..0.097 rows=13 loops=1)

  • Hash Cond: (sm001000_pi8_concerne_9ext.sm001000_pi9_patron_decisionid = sm001000_pi8_action_dossier.sm001000_pi9_patron_decisionid)
11. 0.014 0.014 ↑ 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.006..0.014 rows=78 loops=1)

12. 0.015 0.055 ↓ 6.5 13 1

Hash (cost=12.45..12.45 rows=2 width=566) (actual time=0.055..0.055 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
13. 0.040 0.040 ↓ 6.5 13 1

Index Scan using ix_etp_natr_actn00000 on sm001000_pi8_action_dossierbase sm001000_pi8_action_dossier (cost=0.42..12.45 rows=2 width=566) (actual time=0.017..0.040 rows=13 loops=1)

  • Index Cond: (sm001000_pi8_etape_dossierid = '3d87a85c-99f2-e411-9beb-005056a2625c'::uuid)
14. 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_dossier.sm001000_systemuserid = systemuserid)
15. 0.006 0.013 ↑ 1.8 5 13

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

16. 0.007 0.007 ↑ 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.005..0.007 rows=9 loops=1)

17. 0.002 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)

18. 0.011 0.011 ↑ 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.011..0.011 rows=1 loops=1)

  • Index Cond: (sm001000_pi8_etape_dossierid = '3d87a85c-99f2-e411-9beb-005056a2625c'::uuid)
19. 0.008 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)

20. 0.005 0.005 ↑ 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.005 rows=15 loops=1)

21. 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_dossier.sm001000_pi8_choix_decisionid = sm001000_pi8_choix_decisionid)
22. 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_dossier.sm001000_pi8_action_programmeid = sm001000_pi8_action_programmeid)
Planning time : 3.057 ms
Execution time : 0.498 ms