explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JJa6 : Optimization for: Optimization for: plan #3zH; plan #GOl

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.246 47.210 ↓ 0.0 0 1

Hash Anti Join (cost=780.35..6,908.28 rows=466 width=397) (actual time=47.210..47.210 rows=0 loops=1)

  • Hash Cond: (((si."row" ->> 'sis_fid'::text))::integer = cf.fid)
2. 11.985 11.985 ↓ 1.1 1,000 1

Seq Scan on staging_imports si (cost=0.00..6,118.39 rows=931 width=397) (actual time=11.365..11.985 rows=1,000 loops=1)

  • Filter: (source = 'sh.customers'::text)
  • Rows Removed by Filter: 39514
3. 19.321 33.979 ↑ 1.0 25,654 1

Hash (cost=459.68..459.68 rows=25,654 width=4) (actual time=33.979..33.979 rows=25,654 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1158kB
4. 14.658 14.658 ↑ 1.0 25,654 1

Seq Scan on customers_fids cf (cost=0.00..459.68 rows=25,654 width=4) (actual time=0.012..14.658 rows=25,654 loops=1)

  • Filter: (data_source_id = 'sis'::text)
Planning time : 0.153 ms
Execution time : 47.246 ms