Re: pg_stat_statements extension

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org,Rushikesh socha <rushikesh(dot)s(at)gmail(dot)com>,pgsql-general(at)postgresql(dot)org
Subject: Re: pg_stat_statements extension
Date: 2020-01-13 20:28:45
Message-ID: 26F6C525-74EC-47EC-9D3D-269D50C7FEBA@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 13 January 2020 20:15:21 CET, Rushikesh socha <rushikesh(dot)s(at)gmail(dot)com> wrote:
>HI, Is there any good link that shows how to install pg_stat_statements
>extension
>I am getting below error
>
>postgres=# CREATE EXTENSION pg_stat_statements;
>ERROR: could not open extension control file
>"/usr/pgsql-11/share/extension/pg_stat_statements.control": No such
>file or
>directory
>
>
>Thanks.

Have you installed the contrib-package and also load the shared lib via postgresql.conf?

Andreas

--
2ndQuadrant - The PostgreSQL Support Company

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Israel Brewster 2020-01-13 23:58:58 Worse performance with higher work_mem?
Previous Message Adrian Klaver 2020-01-13 19:41:36 Re: pg_stat_statements extension