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');


          relname           |  reltuples  | relpages
----------------------------+-------------+----------
 vtiger_emaildetails        |       44595 |     1360
 vtiger_seactivityrel       | 1.31978e+06 |     6470
 vtiger_vantage_email_track |       88852 |      481
(3 rows)

Reply via email to