explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GOl : Optimization for: plan #3zH

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 15,839.649 20,884.308 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.00..722,452.99 rows=930 width=397) (actual time=20,884.308..20,884.308 rows=0 loops=1)

  • Join Filter: (si."row" @> ((('{"sis_fid": "'::text || (cf.fid)::text) || '"}'::text))::jsonb)
  • Rows Removed by Join Filter: 11,758,836
2. 12.659 12.659 ↓ 1.1 1,000 1

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

  • Filter: (source = 'sh.customers'::text)
  • Rows Removed by Filter: 39,514
3. 5,017.008 5,032.000 ↑ 2.2 11,760 1,000

Materialize (cost=0.00..587.95 rows=25,654 width=4) (actual time=0.001..5.032 rows=11,760 loops=1,000)

4. 14.992 14.992 ↑ 1.0 25,605 1

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

  • Filter: (data_source_id = 'sis'::text)
Planning time : 0.138 ms
Execution time : 20,884.483 ms