Message-ID: <90000e7812c6440a93872bc3b5f67cb6804d57ba.camel@cybertec.at>
Subject: Re: Check explain plan of a running query in other session
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Jonas Gassenmeyer <gassenmj@gmail.com>
Cc: pgsql-novice@lists.postgresql.org
Date: Wed, 22 Dec 2021 10:39:17 +0100
In-Reply-To: 
 <CADH0_2VRtjfE=SsuNOos8mQEjhj2-bS9biFNh8reZmUw-of3wg@mail.gmail.com>
References: 
	<CADH0_2V5NkwpqKA5GoFq_FNd01CY6zPcNam6jdvrf0H58K16-A@mail.gmail.com>
	 <f83f7705b465f87b07da6ffe57809cc305d1881f.camel@cybertec.at>
	 <CADH0_2VRtjfE=SsuNOos8mQEjhj2-bS9biFNh8reZmUw-of3wg@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/90000e7812c6440a93872bc3b5f67cb6804d57ba.camel%40cybertec.at>
Precedence: bulk

On Wed, 2021-12-22 at 08:58 +0100, Jonas Gassenmeyer wrote:
> Am Mo., 8. Nov. 2021 um 09:43 Uhr schrieb Laurenz Albe <laurenz.albe@cybertec.at>:
> > There is nothing like that built into PostgreSQL, but you could try pg_show_plans:
> > https://github.com/cybertec-postgresql/pg_show_plans
>
> i tried to install this extension. 
>
> One more dump question: Where do I find this contrib folder? It is currently unclear
> to me *where* to git clone this repo - all my other extensions just didn't need a
> special place they just needed an make install.
> This one seems to need a special place "somewhere between the PostgreSQL binaries".
> Is there a PostgreSQL convention where to place such binaries?

I don't think you have to put it into the PostgreSQL source tree.  You can extract
the source anywhere and use PGXS to build:

PATH=/path/to/postgresql/bin:$PATH USE_PGXS=1 make

You will need the PostgreSQL headers and "pg_config" installed.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com