explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C6aZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 9.117 ↓ 5.0 5 1

Limit (cost=24.75..47,903,964.42 rows=1 width=66) (actual time=1.931..9.117 rows=5 loops=1)

2. 0.012 9.115 ↓ 5.0 5 1

Nested Loop Left Join (cost=24.75..47,903,964.42 rows=1 width=66) (actual time=1.931..9.115 rows=5 loops=1)

  • Filter: (ucmfrd.contactid IS NULL)
3. 3.723 3.723 ↑ 3,166.6 5 1

Seq Scan on contactsforrecommendations cfr (cost=0.00..50,864.10 rows=15,833 width=66) (actual time=0.324..3.723 rows=5 loops=1)

  • Filter: ((lower(titlename) = 'vp marketing'::text) OR ((length(titlename) > 4) AND (titlename % 'vp marketing'::text)) OR (lower(titlename) = 'marketing'::text) OR ((length(titlename) > 4) AND (titlename % 'marketing'::text)) OR (lower(titlename) = 'director'::text) OR ((length(titlename) > 4) AND (titlename % 'director'::text)) OR (lower(titlename) = 'marketing manager'::text) OR ((length(titlename) > 4) AND (titlename % 'marketing manager'::text)) OR (lower(titlename) = 'sales'::text) OR ((length(titlename) > 4) AND (titlename % 'sales'::text)))
  • Rows Removed by Filter: 170
4. 0.015 5.380 ↓ 0.0 0 5

Limit (cost=24.75..3,022.34 rows=1 width=8) (actual time=1.076..1.076 rows=0 loops=5)

5. 4.560 5.365 ↓ 0.0 0 5

Bitmap Heap Scan on usermycontactsforrecommdedupe ucmfrd (cost=24.75..3,022.34 rows=1 width=8) (actual time=1.073..1.073 rows=0 loops=5)

  • Recheck Cond: ((userid = '8025'::bigint) AND (firstname IS NOT NULL) AND (companyname IS NOT NULL))
  • Filter: ((firstname = cfr.firstname) AND (companyname = cfr.companyname) AND ((cfr.lastname IS NULL) OR (lower(cfr.lastname) = lower(lastname))))
  • Rows Removed by Filter: 1079
  • Heap Blocks: exact=4105
6. 0.805 0.805 ↑ 1.9 1,079 5

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

  • Index Cond: (userid = '8025'::bigint)
Planning time : 0.468 ms
Execution time : 9.152 ms