explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S3bn

Settings
# exclusive inclusive rows x rows loops node
1. 7.861 30.810 ↑ 1.0 1 1

Nested Loop Anti Join (cost=0.00..6,780.01 rows=1 width=103) (actual time=30.809..30.810 rows=1 loops=1)

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

Seq Scan on table1 (cost=0.00..2,890.01 rows=1 width=103) (actual time=12.637..12.638 rows=1 loops=1)

  • Filter: ((address)::text = 'HYD'::text)
  • Rows Removed by Filter: 100,000
3. 10.311 10.311 ↑ 1.0 100,000 1

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

Planning time : 0.118 ms
Execution time : 30.836 ms