Re: Postgresql JDBC process consumes more memory than psql client

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql JDBC process consumes more memory than psql client
Date: 2022-09-05 13:26:58
Message-ID: 20220905132658.GK31833@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-performance

On Mon, Sep 05, 2022 at 12:52:14PM +0000, James Pang (chaolpan) wrote:
> Any idea how to print SQL plan from JDBC driver ?

You could use "explain execute" on the client, or autoexplain on the
server-side.

--
Justin

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message James Pang (chaolpan) 2022-09-06 04:15:03 RE: Postgresql JDBC process consumes more memory than psql client
Previous Message James Pang (chaolpan) 2022-09-05 12:52:14 RE: Postgresql JDBC process consumes more memory than psql client

Browse pgsql-performance by date

  From Date Subject
Next Message James Pang (chaolpan) 2022-09-06 04:15:03 RE: Postgresql JDBC process consumes more memory than psql client
Previous Message James Pang (chaolpan) 2022-09-05 12:52:14 RE: Postgresql JDBC process consumes more memory than psql client