explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3zH

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 15,838.097 20,917.397 ↓ 0.0 0 1

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

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

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

  • Filter: (source = 'sh.customers'::text)
  • Rows Removed by Filter: 39514
3. 5,051.010 5,066.000 ↑ 2.2 11,760 1,000

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

4. 14.990 14.990 ↑ 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.990 rows=25,605 loops=1)

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