On 13 January 2020 20:15:21 CET, Rushikesh socha 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
>"/us
On Mon, Jan 13, 2020 at 11:41:36AM -0800, Adrian Klaver wrote:
> How did the above get installed, from source, RPM. other?
Rushikesh, depending on your environment, the way to install
pg_stat_statements' libraries may change. On most Linux
distributions, any extension modules are shipped with a p
cha wrote:
> HI, Is there any good link that shows how to
install pg_stat_statements
> extension
Postgres version?
How did you install Postgres?
> I am getting below error
>
> postgres=# CREATE EXTENSION pg_stat_statements;
> ERROR: could
.
Rushikesh Socha
Edison,NJ,USA
Cell : +1 860 794 4643
On Mon, Jan 13, 2020 at 2:24 PM Adrian Klaver
wrote:
> On 1/13/20 11:15 AM, Rushikesh socha wrote:
> > HI, Is there any good link that shows how to install pg_stat_statements
> > extension
>
> Postgres version?
>
> H
On 1/13/20 11:15 AM, Rushikesh socha wrote:
HI, Is there any good link that shows how to install pg_stat_statements
extension
Postgres version?
How did you install Postgres?
I am getting below error
postgres=# CREATE EXTENSION pg_stat_statements;
ERROR: could not open extension control
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.
An other way is to use "waits" reporting ...
something like :
pgss_store (...)
pgstat_report_wait_start(PG_WAIT_EXTENSION);
...
pgstat_report_wait_end();
gives waits of type "Extension", name "Extension" when spending time in this
part of pgss.
This can help those working
Don't you have been surprised by the duration of a query (seen in psql with
\timing)
and the duration for the same query found in pgss ?
It seems that writting the first query text to file takes some time,
that high execution rate on the same query could generate waits on locks
as when pgss is u
