explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JFUu : v2

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.350 ↓ 6.5 13 1

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

2. 0.005 0.326 ↓ 6.5 13 1

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

3. 0.022 0.308 ↓ 6.5 13 1

Nested Loop Left Join (cost=17.39..49.24 rows=2 width=743) (actual time=0.240..0.308 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.011 0.273 ↓ 6.5 13 1

Nested Loop Left Join (cost=17.39..47.56 rows=2 width=711) (actual time=0.226..0.273 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.249 ↓ 6.5 13 1

Nested Loop Left Join (cost=16.97..39.09 rows=2 width=693) (actual time=0.207..0.249 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.008 0.224 ↓ 6.5 13 1

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

7. 0.035 0.190 ↓ 6.5 13 1

Hash Right Join (cost=16.69..21.10 rows=2 width=643) (actual time=0.183..0.190 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.004..0.012 rows=93 loops=1)

9. 0.010 0.143 ↓ 6.5 13 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
10. 0.029 0.133 ↓ 6.5 13 1

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

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

12. 0.015 0.081 ↓ 6.5 13 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
13. 0.066 0.066 ↓ 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.026..0.066 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.007 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.006 0.006 ↑ 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.004..0.006 rows=9 loops=1)

17. 0.000 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.016 0.016 ↑ 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.016..0.016 rows=1 loops=1)

  • Index Cond: (sm001000_pi8_etape_dossierid = '3d87a85c-99f2-e411-9beb-005056a2625c'::uuid)
19. 0.007 0.013 ↑ 1.1 14 13

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

20. 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)

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.303 ms
Execution time : 0.562 ms