Re: Using stat collector for collecting long SQL

2020-03-06 Thread Andres Freund
Hi, On 2020-02-27 09:42:19 +0100, Pavel Stehule wrote: > There is a often problem with taking source of long SQL strings. The > pg_stat_activity field query is reduced to some short limit and is not too > practical to increase this limit. > > I have a idea to use for solution of this problem stat

Re: Using stat collector for collecting long SQL

2020-02-27 Thread legrand legrand
Hi > There is a often problem with taking source of long SQL strings. The > pg_stat_activity field query is reduced to some short limit and is not too > practical to increase this limit. I thought it was "old story", since that track_activity_query_size can be increased widely: https://www.postgr

Using stat collector for collecting long SQL

2020-02-27 Thread Pavel Stehule
Hi There is a often problem with taking source of long SQL strings. The pg_stat_activity field query is reduced to some short limit and is not too practical to increase this limit. I have a idea to use for solution of this problem stat_collector process. When the query string is reduced, then ful