From: | AI Rumman <rummandba(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | query hangs |
Date: | 2010-06-10 10:16:05 |
Message-ID: | AANLkTilkFy49pAQeUVy-5pJpz-OuHOl2HgC69ptZO8dS@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Max Williams | 2010-06-10 10:19:41 | Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? |
Previous Message | Heikki Linnakangas | 2010-06-10 09:01:25 | Re: Autovaccum settings while Bulk Loading data |