explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QEHs

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

Limit (cost=24.75..47,903,964.42 rows=1 width=66) (actual time=582.103..8,410.384 rows=3 loops=1)

2. 0.023 8,410.383 ↓ 3.0 3 1

Nested Loop Left Join (cost=24.75..47,903,964.42 rows=1 width=66) (actual time=582.103..8,410.383 rows=3 loops=1)

  • Filter: (ucmfrd.contactid IS NULL)
  • Rows Removed by Filter: 4
3. 8,406.692 8,406.692 ↑ 2,261.9 7 1

Seq Scan on contactsforrecommendations cfr (cost=0.00..50,864.10 rows=15,833 width=66) (actual time=581.369..8,406.692 rows=7 loops=1)

  • Filter: ((lower(companyname) = 'appneta'::text) OR ((length(companyname) > 4) AND (companyname % 'appneta'::text)) OR (lower(companyname) = 'llc'::text) OR ((length(companyname) > 4) AND (companyname % 'llc'::text)) OR (lower(companyname) = 'cti group'::text) OR ((length(companyname) > 4) AND (companyname % 'cti group'::text)) OR (lower(companyname) = 'weblineindia'::text) OR ((length(companyname) > 4) AND (companyname % 'weblineindia'::text)) OR (lower(companyname) = 'tpf software'::text) OR ((length(companyname) > 4) AND (companyname % 'tpf software'::text)))
  • Rows Removed by Filter: 600284
4. 0.035 3.668 ↑ 1.0 1 7

Limit (cost=24.75..3,022.34 rows=1 width=8) (actual time=0.524..0.524 rows=1 loops=7)

5. 3.059 3.633 ↑ 1.0 1 7

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

  • Recheck Cond: ((userid = '13670'::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: 342
  • Heap Blocks: exact=1874
6. 0.574 0.574 ↑ 4.2 491 7

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

  • Index Cond: (userid = '13670'::bigint)
Planning time : 0.239 ms
Execution time : 8,410.435 ms