Thanks Chris and Steve for the analyze suggestion; That will be my next
test!
On Fri, Nov 30, 2018 at 11:27 AM Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
>
>
> On Fri, Nov 30, 2018 at 8:05 AM Chris Mair wrote:
>
>>
>> > We're kind of pulling out our hair here, any ideas?
>>
>> You m
We have a long script of sql that we run, several thousand lines of sql. If
I execute the script from start to finish, somewhere in the middle of it,
one sql command will hang and take 2 to 3 hours. During this time, "htop"
shows 100% cpu usage with a postgresql process, so it appears to be doing
s
