explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RXHt

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 4.498 ↑ 128.3 6 1

Hash Left Join (cost=234.49..1,673.37 rows=770 width=156) (actual time=4.448..4.498 rows=6 loops=1)

  • Hash Cond: (m.fk_medsocial = mm.id_medsocial)
2. 0.006 0.209 ↑ 128.3 6 1

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

  • Join Filter: (c.fk_log_sms = ll.id_log_sms)
  • Rows Removed by Join Filter: 5
3. 0.013 0.155 ↑ 128.3 6 1

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

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

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

5. 0.029 0.082 ↑ 128.3 6 1

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

  • Hash Cond: (m.fk_log_sms = ll.id_log_sms)
6. 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)

7. 0.006 0.053 ↑ 128.3 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
8. 0.020 0.047 ↑ 128.3 6 1

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

  • Hash Cond: (f.fk_log_sms = ll.id_log_sms)
9. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

10. 0.009 0.026 ↑ 128.3 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
11. 0.017 0.017 ↑ 128.3 6 1

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

12. 0.006 0.006 ↓ 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.001..0.001 rows=0 loops=6)

  • Index Cond: (f.fk_famille = id_famille)
13. 0.011 0.042 ↑ 1.0 1 6

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

14. 0.004 0.031 ↑ 1.0 1 1

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

15. 0.004 0.004 ↑ 1.0 1 1

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

16. 0.023 0.023 ↑ 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.021..0.023 rows=1 loops=1)

  • Index Cond: (s.fk_salarie = id_salarie)
17. 0.023 0.048 ↑ 1.0 1 6

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

18. 0.002 0.025 ↑ 1.0 1 1

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

19. 0.003 0.003 ↑ 1.0 1 1

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

20. 0.020 0.020 ↑ 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.019..0.020 rows=1 loops=1)

  • Index Cond: (c.fk_client = id_client)
21. 2.503 4.260 ↑ 1.0 3,891 1

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

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

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