Incorrect display for remote connection and complex multiline queries

[pashagolub]

I'm not sure if the remote connection is an issue, but decided to add it just in case.
The thing is for complex queries table is corrupted. Switching between views (V key) is not fixing the situation, but the display is changing somehow and stays corrupted.

[genericmoniker]

I'm seeing something similar (though just connected to localhost). The displayed multi-line query is truncated in various surprising ways depending on the size of the terminal window. For example:

[julmon]

What terminal are you using ? It looks that pg_activity doesn't get terminal right size.

[pashagolub]

Terminal on the screenshot is ConEmu, but I observed pretty the same on others. Could it be affected by \r\n symbols in a SQL itself?

[julmon]

@pashagolub thanks ! you're right, query string wasn't cleaned in remote mode.

[genericmoniker]

In my case, it was just the Gnome terminal in CentOS 7, running in a VirtualBox VM.