Postgres showing only truncated queries.

Follow

nidhin

• December 21, 2018 15:00

Hi All,

 

Postgres showing only truncated queries in "Running Queries", am not able to view my full running queries from the interface.

Is there any solution for this..?

0

• 

  nidhin

  • December 27, 2018 05:14

  Dear Team,

   

  Any update..?

  0

  Comment actions Permalink
• 

  Paul Namuag

  • December 27, 2018 07:36

  Hi Nidhin,

   

  Apologies for the delayed response due to holidays and overlooked this request.

   

  Have you tried clicking the rows that has the query you want to view? For example, see my screenshot below:

  

  That will show you the full queries.

   

  Let us know if that solves the problem.

   

  Thanks.

  0

  Comment actions Permalink
• 

  nidhin

  • December 27, 2018 08:26

  Dear Paul,

   

  No issues for the delay, am also went for holidays..

  I tried to clicking the rows, but its showing only some part of the query, not the full. 

  

  Please find my screen shot, You can fin that the missing query is showing like ......

  Is there any other solutions for this..?

  0

  Comment actions Permalink
• 

  Paul Namuag

  • December 27, 2018 09:02

  Hi Nidhin,

   

  I just got our devs feedback and it looks that this is not ClusterControl thing but on the PostgreSQL side since it relies on pg_stat_activity output. To fix this, try increasing the variable track_activity_query_size which is defined as,

  track_activity_query_size (integer)
  
  Specifies the number of bytes reserved to track the currently executing command for each active session, for the pg_stat_activity.query field. The default value is 1024. This parameter can only be set at server start.

  The downside though, it needs a server restart. So you can't do this in a production node unless it's under maintenance.

   

  So set it to a higher value than the current value it has. It works in my end as I tested it setting it lower though:

  where variable has only 100:

  postgres=# show track_activity_query_size;
  
   track_activity_query_size 
  
  ---------------------------
  
   100
  
  (1 row)

   

  Let us know how it goes.

   

  Thanks.

  0

  Comment actions Permalink
• 

  nidhin

  • December 27, 2018 12:16

  Dear Paul,

   

  Thanks for the update,

  Am trying to list the full queries in the cluster control interface and its not getting.

  0

  Comment actions Permalink
• 

  Paul Namuag

  • December 27, 2018 15:52

  Hi Nidhin,

   

  As what I've mentioned earlier, the ClusterControl does not have control of the truncated queries but it needs to be adjusted to the PostgreSQL node itself.  You have to set the variable track_activity_query_size in your pg_hba.conf and then try to restart the node. Ensure that the node is not under prod or is on maintenance mode.

  0

  Comment actions Permalink
• 

  nidhin

  • December 28, 2018 04:31

  Dear Paul,

   

  Thanks for the update.

  0

  Comment actions Permalink

Please sign in to leave a comment.