Greetings,
* Don Branson (don.branson@gmail.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?
Don't think pgadmin matters here- you just need to increase the GUC for
tracking activity query size:
https://www.postgresql.org/docs/current/runtime-config-statistics.html#GUC-TRACK-ACTIVITY-QUERY-SIZE
on the server and restart.
Thanks,
Stephen