Re: Length of SQL show in dashboard limited to 1K

From: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
To: Don Branson <don(dot)branson(at)gmail(dot)com>
Cc: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Length of SQL show in dashboard limited to 1K
Date: 2020-05-19 17:57:17
Message-ID: CAKKotZSO2rfKuGLx6GYG755M4LDhmdKii87em7N+ZvXCAnAw1g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

This issue is not related to pgAdmin4.

You can modify and increase the track_activity_query_size parameter value
which controls the length of the query, it postgres server side setting,
you can check postgres documentation for more information.

Regards,
Murtaza

On Tue, 19 May 2020, 22:27 Don Branson, <don(dot)branson(at)gmail(dot)com> wrote:

> I'm using pgadmin 4.21, following Server Activity and drilling into
> individual requests, looking at SQL for certain requests. The SQL is
> limited to 1024 characters, but that's cutting off the where clause, which
> I need to see. I was able to find a solution for this for older versions of
> pgadmin, but am unable to see the whole SQL in pgadmin4. How do I see the
> whole query?
>
> Thanks,
> Don
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Bo Guo 2020-05-19 18:36:15 Re: pgadmin4 container install: volume mapping
Previous Message Stephen Frost 2020-05-19 16:59:39 Re: Length of SQL show in dashboard limited to 1K