On Wed, Oct 28, 2015 at 12:12 AM, 657985...@qq.com <657985...@qq.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->
from
tshow.p_hpart_liveingroomlist_count($1)","parameters: $1 = '46'
thanks
657985...@qq.com
发件人： 657985...@qq.com
发送时间： 2015-10-28 16:53
收件人： John R Pierce; pgsql-general
主题： Re: Re: [GENERAL] Re: Re: [GENERAL] 回复: postgres cpu 100% need help
thanks , I can change the sql . Needed a lit
from
tshow.p_hpart_liveingroomlist_count($1)","parameters: $1 = '46'
657985...@qq.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, 657985...@qq.com wrote:
Thank you for your reply.
On 10/28/2015 12:12 AM, 657985...@qq.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.de
300.237 ms execute :
SELECT o_count FROM
tshow.p_hpart_getcount_intitle($1)","parameters: $1 = '46'"""
657985...@qq.com
发件人： Jeff Janes
发送时间： 2015-10-28 03:33
收件人： 657985...@qq.com
抄送： pgsql-general
主
On Tue, Oct 27, 2015 at 4:04 PM, Merlin Moncure wrote:
> On Tue, Oct 27, 2015 at 2:33 PM, Jeff Janes wrote:
>> On Mon, Oct 26, 2015 at 8:30 PM, 657985...@qq.com <657985...@qq.com> wrote:
>>>
>>> Dear sir:
>>> Recently a wired question about postgresql database really
>>> bothered me a lo
On Tue, Oct 27, 2015 at 2:33 PM, Jeff Janes wrote:
> On Mon, Oct 26, 2015 at 8:30 PM, 657985...@qq.com <657985...@qq.com> wrote:
>>
>> Dear sir:
>> Recently a wired question about postgresql database really
>> bothered me a lot, so i really need your help. Here is the problem, in the
>> m
On Mon, Oct 26, 2015 at 8:30 PM, 657985...@qq.com <657985...@qq.com> wrote:
> Dear sir:
> Recently a wired question about postgresql database really
> bothered me a lot, so i really need your help. Here is the problem, in the
> most situations the postgre database work very well, Average
Dear sir:
Recently a wired question about postgresql database really bothered me
a lot, so i really need your help. Here is the problem, in the most situations
the postgre database work very well, Average 3500tps/s per day, the cpu usage
of its process is 3%~10% and every query can be
