pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Justin Pryzby <pryzby@telsasoft.com>
To: James Pang (chaolpan) <chaolpan@cisco.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Postgresql JDBC process consumes more memory than psql client
Date: Mon, 5 Sep 2022 08:26:58 -0500
Message-ID: <20220905132658.GK31833@telsasoft.com> (raw)
In-Reply-To: <PH0PR11MB5191C2C75F91CE1237267479D67F9@PH0PR11MB5191.namprd11.prod.outlook.com>
References: <PH0PR11MB5191A047B707B2FE6527C549D67F9@PH0PR11MB5191.namprd11.prod.outlook.com>
	<20220905124722.GI31833@telsasoft.com>
	<PH0PR11MB5191C2C75F91CE1237267479D67F9@PH0PR11MB5191.namprd11.prod.outlook.com>

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

view thread (19+ messages)  latest in thread

Message-ID: <20220905132658.GK31833@telsasoft.com>
Permalink:  ../20220905132658.GK31833@telsasoft.com/
Also on:    postgresql.org/message-id/20220905132658.GK31833@telsasoft.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pryzby@telsasoft.com, chaolpan@cisco.com, pgsql-performance@lists.postgresql.org
  Subject: Re: Postgresql JDBC process consumes more memory than psql client
  In-Reply-To: <20220905132658.GK31833@telsasoft.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox