Re: pg_stat_statements extension - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: pg_stat_statements extension
Date
Msg-id 26F6C525-74EC-47EC-9D3D-269D50C7FEBA@a-kretschmer.de
Whole thread Raw
In response to pg_stat_statements extension  (Rushikesh socha <rushikesh.s@gmail.com>)
List pgsql-general
On 13 January 2020 20:15:21 CET, Rushikesh socha <rushikesh.s@gmail.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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_stat_statements extension
Next
From: Israel Brewster
Date:
Subject: Worse performance with higher work_mem?