| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Don Branson <don(dot)branson(at)gmail(dot)com> |
| Cc: | pgadmin-support(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Length of SQL show in dashboard limited to 1K |
| Date: | 2020-05-19 16:59:39 |
| Message-ID: | 20200519165939.GP13712@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Greetings,
* 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?
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Murtuza Zabuawala | 2020-05-19 17:57:17 | Re: Length of SQL show in dashboard limited to 1K |
| Previous Message | Don Branson | 2020-05-19 16:56:29 | Length of SQL show in dashboard limited to 1K |