From: | "657985552(at)qq(dot)com" <657985552(at)qq(dot)com> |
---|---|
To: | "John R Pierce" <pierce(at)hogranch(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Re: [GENERAL] Re: Re: [GENERAL] 回复: postgres cpu 100% need help |
Date: | 2015-10-28 08:53:43 |
Message-ID: | 2015102816534343829262@qq.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
thanks , I can change the sql . Needed a little business modify in my application .but i don't know why in high load time I Executing the sql
,it cost 200-300ms . but the log record it cost 2000ms
log message:
duration: 2042.493 ms execute <unnamed>: select o_count from tshow.p_hpart_liveingroomlist_count($1)","parameters: $1 = '46'
657985552(at)qq(dot)com
发件人: John R Pierce
发送时间: 2015-10-28 16:28
收件人: pgsql-general
主题: Re: [GENERAL] Re: Re: [GENERAL] 回复: postgres cpu 100% need help
On 10/28/2015 12:12 AM, 657985552(at)qq(dot)com wrote:
Thank you for your reply.
tshow=> explain (analyze, buffers) select count(t.*) from tshow.res_room_weight t,tshow.res_room_info r
tshow-> where t.subcatlg_id=46
tshow-> and t.roomid = r.actorid
tshow-> and r.levels>=0;
http://explain.depesz.com/s/oKN5
shows where the time is spent in that query, but as you say, that one the timing was fine. there's a lot of time being spent in a seq_scan of res_room_info.
I would have written that query as the inner join it is, but that probably won't effect how it's executed.
select ... from tshow.res_room_weight t join tshow.res_room_info r on (t.roomid = r.actorid) where t.subcatlg_id=46 and r.levels>=0;
--
john r pierce, recycling bits in santa cruz
From | Date | Subject | |
---|---|---|---|
Next Message | 657985552@qq.com | 2015-10-28 08:56:13 | Re: Re: [GENERAL] Re: Re: [GENERAL] 回复: postgres cpu 100% need help |
Previous Message | John R Pierce | 2015-10-28 08:28:50 | Re: Re: Re: [GENERAL] 回复: postgres cpu 100% need help |