Database Management

Long SQL Text truncation in PostgreSQL

This article provides information about the issue when the SQL Texts are being truncated for PostgreSQL DB instance

First published date

10/10/2022 8:51 AM

Last published date

10/10/2022 8:51 AM

Overview

In DPA, for PostgreSQL monitor instance, the long SQL Texts are being truncated and not showing completely

Product section

Database Performance Analyzer

Cause

The settings 'track_activity_query_size' in PostgreSQL instance is only set to 4096 or 4KB
This parameter determines the maximum query length to display in the pg_stat_activity query column

Resolution

Increase the size for 'track_activity_query_size' parameter in PostgreSQL Instance

To increase the size

Create a copy of postgresql.cnf (For a quick backup)
Edit postgresql.cnf
Find 'track_activity_query_size' parameter and increase the size to 16384 byte or 16KB
Restart PostgreSQL service *Required*

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.