explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YNEg

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.184 ↑ 128.3 6 1

Nested Loop Left Join (cost=28.19..1,449.74 rows=770 width=136) (actual time=0.144..0.184 rows=6 loops=1)

  • Join Filter: (c.fk_log_sms = ll.id_log_sms)
  • Rows Removed by Join Filter: 5
2. 0.011 0.126 ↑ 128.3 6 1

Nested Loop Left Join (cost=27.90..1,417.31 rows=770 width=116) (actual time=0.101..0.126 rows=6 loops=1)

  • Join Filter: (s.fk_log_sms = ll.id_log_sms)
  • Rows Removed by Join Filter: 5
3. 0.014 0.073 ↑ 128.3 6 1

Nested Loop Left Join (cost=27.61..1,396.44 rows=770 width=96) (actual time=0.056..0.073 rows=6 loops=1)

4. 0.025 0.053 ↑ 128.3 6 1

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

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

6. 0.010 0.028 ↑ 128.3 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
7. 0.018 0.018 ↑ 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.018 rows=6 loops=1)

8. 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)
9. 0.013 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)

10. 0.004 0.029 ↑ 1.0 1 1

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

11. 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.004..0.004 rows=1 loops=1)

12. 0.021 0.021 ↑ 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.020..0.021 rows=1 loops=1)

  • Index Cond: (s.fk_salarie = id_salarie)
13. 0.016 0.036 ↑ 1.0 1 6

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

14. 0.003 0.020 ↑ 1.0 1 1

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

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

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

  • Index Cond: (c.fk_client = id_client)