[GENERAL] Re: Re: [GENERAL] Re: Re: [GENERAL] 回复: postgres cpu 100% need help

2015-10-28 Thread 657985...@qq.com
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 : select o_count from tshow.p_hpart_liveingro

[GENERAL] Re: Re: [GENERAL] Re: Re: [GENERAL] 回复: postgres cpu 100% need help

2015-10-28 Thread 657985...@qq.com
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 : select o_count from tshow.p_hpart_l