explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Gan

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 3,056.696 ↓ 3.0 3 1

Limit (cost=26,366.33..26,515.08 rows=1 width=66) (actual time=3,056.602..3,056.696 rows=3 loops=1)

2. 0.092 3,056.695 ↓ 3.0 3 1

Merge Left Join (cost=26,366.33..26,515.08 rows=1 width=66) (actual time=3,056.601..3,056.695 rows=3 loops=1)

  • Merge Cond: ((cfr.firstname = ucmfrd.firstname) AND (cfr.companyname = ucmfrd.companyname))
  • Join Filter: ((cfr.lastname IS NULL) OR (lower(cfr.lastname) = lower(ucmfrd.lastname)))
  • Filter: (ucmfrd.contactid IS NULL)
  • Rows Removed by Filter: 4
3. 0.000 3,055.109 ↑ 2,539.9 7 1

Sort (cost=23,256.67..23,301.12 rows=17,779 width=66) (actual time=3,055.108..3,055.109 rows=7 loops=1)

  • Sort Key: cfr.firstname, cfr.companyname
  • Sort Method: quicksort Memory: 25kB
4. 106.806 3,057.252 ↑ 2,539.9 7 1

Gather (cost=1,000.00..22,001.66 rows=17,779 width=66) (actual time=2,041.261..3,057.252 rows=7 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 2,950.446 2,950.446 ↑ 3,704.0 2 3 / 3

Parallel Seq Scan on contactsforrecommendations cfr (cost=0.00..19,223.76 rows=7,408 width=66) (actual time=1,059.560..2,950.446 rows=2 loops=3)

  • Filter: ((lower(companyname) = 'appneta'::text) OR (companyname % 'appneta'::text) OR (lower(companyname) = 'llc'::text) OR (companyname % 'llc'::text) OR (lower(companyname) = 'cti group'::text) OR (companyname % 'cti group'::text) OR (lower(companyname) = 'weblineindia'::text) OR (companyname % 'weblineindia'::text) OR (lower(companyname) = 'tpf software'::text) OR (companyname % 'tpf software'::text))
  • Rows Removed by Filter: 200095
6. 0.784 1.494 ↑ 5.8 354 1

Sort (cost=3,109.66..3,114.77 rows=2,043 width=38) (actual time=1.474..1.494 rows=354 loops=1)

  • Sort Key: ucmfrd.firstname, ucmfrd.companyname
  • Sort Method: quicksort Memory: 66kB
7. 0.614 0.710 ↑ 4.2 491 1

Bitmap Heap Scan on usermycontactsforrecommdedupe ucmfrd (cost=25.26..2,997.33 rows=2,043 width=38) (actual time=0.136..0.710 rows=491 loops=1)

  • Recheck Cond: ((userid = '13670'::bigint) AND (firstname IS NOT NULL) AND (companyname IS NOT NULL))
  • Heap Blocks: exact=382
8. 0.096 0.096 ↑ 4.2 491 1

Bitmap Index Scan on idx_usermycontactsforrecommdedupe_userid_names (cost=0.00..24.75 rows=2,042 width=0) (actual time=0.096..0.096 rows=491 loops=1)

  • Index Cond: (userid = '13670'::bigint)
Planning time : 0.839 ms
Execution time : 3,058.924 ms