Can anyone please tell me why the following query hangs? This is a part of a large query.
explain select * from vtiger_emaildetails inner join vtiger_vantage_email_track on vtiger_emaildetails.emailid = vtiger_vantage_email_track.mailid left join vtiger_seactivityrel on vtiger_seactivityrel.activityid = vtiger_emaildetails.emailid
QUERY PLAN ------------------------------------------------------------------------------------------------------------------------- Merge Left Join (cost=9500.30..101672.51 rows=2629549 width=506) Merge Cond: ("outer".emailid = "inner".activityid) -> Merge Join (cost=9500.30..11658.97 rows=88852 width=498) Merge Cond: ("outer".emailid = "inner".mailid) -> Index Scan using vtiger_emaildetails_pkey on vtiger_emaildetails (cost=0.00..714.40 rows=44595 width=486) -> Sort (cost=9500.30..9722.43 rows=88852 width=12) Sort Key: vtiger_vantage_email_track.mailid -> Seq Scan on vtiger_vantage_email_track (cost=0.00..1369.52 rows=88852 width=12) -> Index Scan using seactivityrel_activityid_idx on vtiger_seactivityrel (cost=0.00..28569.29 rows=1319776 width=8) (9 rows)
select relname, reltuples, relpages from pg_class where relname in ('vtiger_emaildetails','vtiger_vantage_email_track','vtiger_seactivityrel');