explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LIkN

Settings
# exclusive inclusive rows x rows loops node
1. 125.464 193.626 ↓ 1.0 920,775 1

Hash Anti Join (cost=24.18..30,514.12 rows=920,145 width=53) (actual time=0.024..193.626 rows=920,775 loops=1)

  • Hash Cond: (addresses_task.id = addresses_results.id)
2. 68.160 68.160 ↑ 1.0 920,775 1

Seq Scan on addresses_task (cost=0.00..18,870.75 rows=920,775 width=53) (actual time=0.013..68.160 rows=920,775 loops=1)

3. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=16.30..16.30 rows=630 width=4) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
4. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on addresses_results (cost=0.00..16.30 rows=630 width=4) (actual time=0.001..0.002 rows=0 loops=1)