explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NXks

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.036 ↑ 770.0 1 1

Nested Loop (cost=27.61..2,698.03 rows=770 width=96) (actual time=0.034..0.036 rows=1 loops=1)

2. 0.010 0.022 ↑ 770.0 1 1

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

  • Hash Cond: (c.fk_log_sms = ll.id_log_sms)
3. 0.004 0.004 ↑ 2,140.0 1 1

Seq Scan on t_log_sms_cl c (cost=0.00..31.40 rows=2,140 width=8) (actual time=0.004..0.004 rows=1 loops=1)

4. 0.004 0.008 ↑ 128.3 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
5. 0.004 0.004 ↑ 128.3 6 1

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

6. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (id_client = c.fk_client)