explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bCMh

Settings
# exclusive inclusive rows x rows loops node
1. 12.293 215.768 ↑ 23.9 1,000 1

Merge Join (cost=1.47..157,356.24 rows=23,884 width=673) (actual time=0.379..215.768 rows=1,000 loops=1)

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

Nested Loop (cost=1.18..155,810.38 rows=23,884 width=409) (actual time=0.330..184.332 rows=1,000 loops=1)

3. 15.886 15.886 ↑ 1.0 25,654 1

Index Scan using customers_fids_customer_id_idx on customers_fids cf (cost=0.29..815.10 rows=25,654 width=12) (actual time=0.006..15.886 rows=25,654 loops=1)

4. 51.308 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. 76.962 76.962 ↓ 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.003..0.003 rows=0 loops=25,654)

  • Index Cond: ("row" @> ((('{"sis_fid": "'::text || (cf.fid)::text) || '"}'::text))::jsonb)
6. 19.143 19.143 ↑ 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.006..19.143 rows=25,324 loops=1)

Planning time : 0.328 ms
Execution time : 216.240 ms