explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4mx8

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 0.128 ↑ 128.3 6 1

Hash Left Join (cost=18.67..49.87 rows=770 width=116) (actual time=0.101..0.128 rows=6 loops=1)

  • Hash Cond: (ll.id_log_sms = c.fk_log_sms)
2. 0.023 0.082 ↑ 128.3 6 1

Hash Left Join (cost=9.33..29.93 rows=770 width=96) (actual time=0.069..0.082 rows=6 loops=1)

  • Hash Cond: (ll.id_log_sms = s.fk_log_sms)
3. 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.013..0.018 rows=6 loops=1)

4. 0.005 0.041 ↑ 1.0 1 1

Hash (cost=9.32..9.32 rows=1 width=24) (actual time=0.041..0.041 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
5. 0.006 0.036 ↑ 1.0 1 1

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

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

7. 0.025 0.025 ↑ 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.023..0.025 rows=1 loops=1)

  • Index Cond: (s.fk_salarie = id_salarie)
8. 0.002 0.022 ↑ 1.0 1 1

Hash (cost=9.33..9.33 rows=1 width=24) (actual time=0.022..0.022 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
9. 0.002 0.020 ↑ 1.0 1 1

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

10. 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.003..0.003 rows=1 loops=1)

11. 0.015 0.015 ↑ 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.015 rows=1 loops=1)

  • Index Cond: (c.fk_client = id_client)