Re: PGAdmin 4: session detail case long SQL

Hi,

On Mon, Dec 16, 2019 at 7:30 PM Alain Dupeyron <adupeyron(at)yahoo(dot)fr> wrote:

> Hi Aditya,
>
> I have "very" long queries formatted on multilines. See screenshot below
> with 23 lines but SQL is truncated...
>
> I have just updated to PGAdmin 4.16, SQL field seem to be longuer but
> still truncated in my case
>
OK. So I guess the param track_activity_query_size might be less for you
DB. Refer -
https://www.postgresql.org/docs/12/runtime-config-statistics.html
pgAdmin uses pg_stat_activity to fetch the query. It depends on
track_activity_query_size how much size of the query is tracked.
To check, execute show track_activity_query_size in query tool.

[image: image.png]

>
> [image: Image en ligne]
> Thanks
>
> Alain
> Le lundi 16 décembre 2019 à 13:19:48 UTC+1, Aditya Toshniwal <
> aditya(dot)toshniwal(at)enterprisedb(dot)com> a écrit :
>
>
> Hi Alain,
>
> You can scroll it. Please check the screenshot below:
> [image: Screenshot 2019-12-16 at 17.45.49.png]
>
> On Mon, Dec 16, 2019 at 3:32 PM Alain Dupeyron <adupeyron(at)yahoo(dot)fr> wrote:
>
> Hi,
>
> In PG Admin 4, I use the dashboard, server activity to explore sessions on
> PG v12.1.
> In the Details panel of the session, I can see the start of the SQL, but
> when it's a long text query on multiple lines, How can I access the entire
> SQL command ?
>
> In PGAdmin 3 (on oldest PG v9.4), in tool server state, I was using for
> that purpose, the button that launch the query editor for the selected
> session with the entire SQL command.
>
> Thanks for your suggestions !
>
>
>
> --
> Thanks and Regards,
> Aditya Toshniwal
> Sr. Software Engineer | EnterpriseDB India | Pune
> "Don't Complain about Heat, Plant a TREE"
>

--
Thanks and Regards,
Aditya Toshniwal
Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"