explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qrmJ

Settings
# exclusive inclusive rows x rows loops node
1. 12.725 229.043 ↑ 23.9 1,000 1

Merge Join (cost=1.47..157,420.38 rows=23,884 width=673) (actual time=0.382..229.043 rows=1,000 loops=1)

  • Merge Cond: (cf.customer_id = cu.id)
2. 49.017 196.453 ↑ 23.9 1,000 1

Nested Loop (cost=1.18..155,874.52 rows=23,884 width=409) (actual time=0.333..196.453 rows=1,000 loops=1)

3. 19.166 19.166 ↑ 1.0 25,654 1

Index Scan using customers_fids_customer_id_idx on customers_fids cf (cost=0.29..879.23 rows=25,654 width=12) (actual time=0.007..19.166 rows=25,654 loops=1)

  • Filter: (data_source_id = 'sis'::text)
4. 25.654 128.270 ↓ 0.0 0 25,654

Bitmap Heap Scan on staging_imports si (cost=0.89..6.03 rows=1 width=397) (actual time=0.005..0.005 rows=0 loops=25,654)

  • Recheck Cond: ("row" @> ((('{"sis_fid": "'::text || (cf.fid)::text) || '"}'::text))::jsonb)
  • Rows Removed by Index Recheck: 0
  • Filter: (source = 'sh.customers'::text)
  • Heap Blocks: exact=1007
5. 102.616 102.616 ↓ 0.0 0 25,654

Bitmap Index Scan on staging_imports_row_idx (cost=0.00..0.89 rows=38 width=0) (actual time=0.004..0.004 rows=0 loops=25,654)

  • Index Cond: ("row" @> ((('{"sis_fid": "'::text || (cf.fid)::text) || '"}'::text))::jsonb)
6. 19.865 19.865 ↑ 1.0 25,324 1

Index Scan using customers_pkey on customers cu (cost=0.29..1,183.88 rows=25,371 width=264) (actual time=0.005..19.865 rows=25,324 loops=1)

Planning time : 0.327 ms
Execution time : 229.521 ms