Re: Check explain plan of a running query in other session

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(dot)albe(at)cybertec(dot)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