explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NVJx

Settings
# exclusive inclusive rows x rows loops node
1. 7.896 18.004 ↑ 1.0 1 1

Nested Loop Anti Join (cost=0.42..3,894.43 rows=1 width=103) (actual time=18.003..18.004 rows=1 loops=1)

  • Join Filter: (table1.id = table2.id)
  • Rows Removed by Join Filter: 100,000
2. 0.015 0.015 ↑ 1.0 1 1

Index Scan using table1_idx on table1 (cost=0.42..4.44 rows=1 width=103) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: ((address)::text = 'HYD'::text)
3. 10.093 10.093 ↑ 1.0 100,000 1

Seq Scan on table2 (cost=0.00..2,640.00 rows=100,000 width=4) (actual time=0.103..10.093 rows=100,000 loops=1)

Planning time : 0.083 ms
Execution time : 18.029 ms