public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Jonas Gassenmeyer <[email protected]>
Cc: [email protected]
Subject: Re: Check explain plan of a running query in other session
Date: Wed, 22 Dec 2021 10:39:17 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CADH0_2VRtjfE=SsuNOos8mQEjhj2-bS9biFNh8reZmUw-of3wg@mail.gmail.com>
References: <CADH0_2V5NkwpqKA5GoFq_FNd01CY6zPcNam6jdvrf0H58K16-A@mail.gmail.com>
	<[email protected]>
	<CADH0_2VRtjfE=SsuNOos8mQEjhj2-bS9biFNh8reZmUw-of3wg@mail.gmail.com>

On Wed, 2021-12-22 at 08:58 +0100, Jonas Gassenmeyer wrote:
> Am Mo., 8. Nov. 2021 um 09:43 Uhr schrieb Laurenz Albe <[email protected]>:
> > 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

view thread (5+ messages)

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Check explain plan of a running query in other session
  In-Reply-To: <[email protected]>

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

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