Hi Justin,
Thanks for your response.
I suspect JDBC is using parameterized queries (postgres $1, $2, ..) and psql
isn't (unless you type "prepare p AS SELECT ..." and execute p(.., .., ..)"
Yes JDBC is using parameterized queries which get constructed dynamically
depending upon user privileges in
On Fri, Dec 04, 2020 at 01:31:14PM +0530, aditya desai wrote:
> Hi Justin,
> Many thanks for your response. Please see my response below.
>
> What do you mean by API ? If it's a different client, how does it connect ?
> Queries are getting called from Web UI built in Microservices spring boot.
>
Hi Kyotaro,
Many thanks for the response. Will try and debug further. Have responded to
Justin in another chain. Could you please check and advise if anything ?
Regards,
Aditya.
On Fri, Dec 4, 2020 at 1:23 PM Kyotaro Horiguchi
wrote:
> At Fri, 4 Dec 2020 12:11:59 +0530, Ravikumar Reddy <
> urra
At Fri, 4 Dec 2020 12:11:59 +0530, Ravikumar Reddy
wrote in
> Hi,
> pg_stat_activity -- Providers the active and ideal connection for our
> database
> Pg_locks -- Provider the queries/procedure/function details if
> any object is locked at the current in our database.
Yeah..
That re
