explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4PJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 3.364 ↑ 128.3 6 1

Hash Left Join (cost=459.73..1,965.06 rows=770 width=220) (actual time=3.311..3.364 rows=6 loops=1)

  • Hash Cond: (i.fk_ctc_interl = ii.id_ctcint)
2. 0.010 3.104 ↑ 128.3 6 1

Hash Left Join (cost=444.54..1,916.18 rows=770 width=202) (actual time=3.060..3.104 rows=6 loops=1)

  • Hash Cond: (ll.id_log_sms = i.fk_log_sms)
3. 0.009 3.094 ↑ 128.3 6 1

Hash Left Join (cost=386.39..1,846.48 rows=770 width=198) (actual time=3.055..3.094 rows=6 loops=1)

  • Hash Cond: (o.fk_organisme = oo.id_organisme)
4. 0.006 2.674 ↑ 128.3 6 1

Hash Left Join (cost=351.81..1,801.32 rows=770 width=171) (actual time=2.640..2.674 rows=6 loops=1)

  • Hash Cond: (ll.id_log_sms = o.fk_log_sms)
5. 0.008 2.668 ↑ 128.3 6 1

Hash Left Join (cost=293.66..1,731.62 rows=770 width=167) (actual time=2.634..2.668 rows=6 loops=1)

  • Hash Cond: (d.fk_deleguetutelle = dd.id_deleguetutelle)
6. 0.011 2.655 ↑ 128.3 6 1

Hash Left Join (cost=292.63..1,727.67 rows=770 width=160) (actual time=2.624..2.655 rows=6 loops=1)

  • Hash Cond: (ll.id_log_sms = d.fk_log_sms)
7. 0.012 2.644 ↑ 128.3 6 1

Hash Left Join (cost=234.49..1,657.97 rows=770 width=156) (actual time=2.616..2.644 rows=6 loops=1)

  • Hash Cond: (m.fk_medsocial = mm.id_medsocial)
8. 0.005 0.115 ↑ 128.3 6 1

Nested Loop Left Join (cost=84.94..1,494.94 rows=770 width=140) (actual time=0.089..0.115 rows=6 loops=1)

  • Join Filter: (c.fk_log_sms = ll.id_log_sms)
  • Rows Removed by Join Filter: 5
9. 0.009 0.092 ↑ 128.3 6 1

Nested Loop Left Join (cost=84.65..1,474.06 rows=770 width=120) (actual time=0.072..0.092 rows=6 loops=1)

  • Join Filter: (s.fk_log_sms = ll.id_log_sms)
  • Rows Removed by Join Filter: 5
10. 0.012 0.059 ↑ 128.3 6 1

Nested Loop Left Join (cost=84.36..1,453.19 rows=770 width=100) (actual time=0.045..0.059 rows=6 loops=1)

11. 0.016 0.047 ↑ 128.3 6 1

Hash Right Join (cost=84.08..131.20 rows=770 width=84) (actual time=0.040..0.047 rows=6 loops=1)

  • Hash Cond: (m.fk_log_sms = ll.id_log_sms)
12. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on t_log_sms_ms m (cost=0.00..31.40 rows=2,140 width=8) (actual time=0.000..0.000 rows=0 loops=1)

13. 0.004 0.031 ↑ 128.3 6 1

Hash (cost=74.45..74.45 rows=770 width=80) (actual time=0.031..0.031 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
14. 0.011 0.027 ↑ 128.3 6 1

Hash Right Join (cost=27.32..74.45 rows=770 width=80) (actual time=0.022..0.027 rows=6 loops=1)

  • Hash Cond: (f.fk_log_sms = ll.id_log_sms)
15. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on t_log_sms_fa f (cost=0.00..31.40 rows=2,140 width=8) (actual time=0.000..0.000 rows=0 loops=1)

16. 0.006 0.016 ↑ 128.3 6 1

Hash (cost=17.70..17.70 rows=770 width=76) (actual time=0.016..0.016 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
17. 0.010 0.010 ↑ 128.3 6 1

Seq Scan on t_log_sms ll (cost=0.00..17.70 rows=770 width=76) (actual time=0.008..0.010 rows=6 loops=1)

18. 0.000 0.000 ↓ 0.0 0 6

Index Scan using pk_t_famille on t_famille ff (cost=0.29..1.71 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=6)

  • Index Cond: (f.fk_famille = id_famille)
19. 0.006 0.024 ↑ 1.0 1 6

Materialize (cost=0.29..9.33 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=6)

20. 0.003 0.018 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.29..9.32 rows=1 width=24) (actual time=0.016..0.018 rows=1 loops=1)

21. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on t_log_sms_sa s (cost=0.00..1.01 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1)

22. 0.013 0.013 ↑ 1.0 1 1

Index Scan using pk_t_salarie on t_salarie ss (cost=0.29..8.30 rows=1 width=20) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (s.fk_salarie = id_salarie)
23. 0.006 0.018 ↑ 1.0 1 6

Materialize (cost=0.29..9.33 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=6)

24. 0.003 0.012 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.29..9.33 rows=1 width=24) (actual time=0.011..0.012 rows=1 loops=1)

25. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on t_log_sms_cl c (cost=0.00..1.01 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

26. 0.008 0.008 ↑ 1.0 1 1

Index Scan using pk_t_client on t_client cc (cost=0.29..8.31 rows=1 width=20) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (c.fk_client = id_client)
27. 1.516 2.517 ↑ 1.0 3,891 1

Hash (cost=100.91..100.91 rows=3,891 width=20) (actual time=2.517..2.517 rows=3,891 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 208kB
28. 1.001 1.001 ↑ 1.0 3,891 1

Seq Scan on t_medsocial mm (cost=0.00..100.91 rows=3,891 width=20) (actual time=0.003..1.001 rows=3,891 loops=1)

29. 0.000 0.000 ↓ 0.0 0 1

Hash (cost=31.40..31.40 rows=2,140 width=8) (actual time=0.000..0.000 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
30. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on t_log_sms_dt d (cost=0.00..31.40 rows=2,140 width=8) (actual time=0.000..0.000 rows=0 loops=1)

31. 0.001 0.005 ↓ 3.0 3 1

Hash (cost=1.01..1.01 rows=1 width=11) (actual time=0.005..0.005 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
32. 0.004 0.004 ↓ 3.0 3 1

Seq Scan on t_deleguetutelle dd (cost=0.00..1.01 rows=1 width=11) (actual time=0.003..0.004 rows=3 loops=1)

33. 0.000 0.000 ↓ 0.0 0 1

Hash (cost=31.40..31.40 rows=2,140 width=8) (actual time=0.000..0.000 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
34. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on t_log_sms_or o (cost=0.00..31.40 rows=2,140 width=8) (actual time=0.000..0.000 rows=0 loops=1)

35. 0.234 0.411 ↓ 1.0 652 1

Hash (cost=26.48..26.48 rows=648 width=31) (actual time=0.411..0.411 rows=652 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
36. 0.177 0.177 ↓ 1.0 652 1

Seq Scan on t_organisme oo (cost=0.00..26.48 rows=648 width=31) (actual time=0.004..0.177 rows=652 loops=1)

37. 0.000 0.000 ↓ 0.0 0 1

Hash (cost=31.40..31.40 rows=2,140 width=8) (actual time=0.000..0.000 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
38. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on t_log_sms_ia i (cost=0.00..31.40 rows=2,140 width=8) (actual time=0.000..0.000 rows=0 loops=1)

39. 0.140 0.242 ↑ 1.0 364 1

Hash (cost=10.64..10.64 rows=364 width=22) (actual time=0.242..0.242 rows=364 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
40. 0.102 0.102 ↑ 1.0 364 1

Seq Scan on t_ctc_interl ii (cost=0.00..10.64 rows=364 width=22) (actual time=0.004..0.102 rows=364 loops=1)