pg_stat_statements extension not recognised as enabled - Githubissues

jfcoz / postgresqltuner

Simple script to analyse your PostgreSQL database configuration, and give tuning advice

https://postgresqltuner.pl

GNU General Public License v3.0

2.61k stars 190 forks source link

pg_stat_statements extension not recognised as enabled #39

Closed PitoneMaledetto closed 5 years ago

PitoneMaledetto commented 5 years ago

Although the extension has been enabled it shows as disabled:

postgres=# select extname from pg_extension; extname

plpgsql pg_stat_statements

Expected Behavior

[OK] Extension pg_stat_statements is enabled

Current Behavior

[WARN] Extensions pg_stat_statements is disabled

Possible Solution

n.a.

Steps to Reproduce (for bugs)

Just run ./postgresqltuner.pl

Context

n.a.

Your Environment

Version used: Latest
PostgreSQL version: PostgreSQL 11.2
Operating System and version: Debian 9.8 (4.9.144-3)

PitoneMaledetto commented 5 years ago

Please close/delete this "issue" since it is me running the script without the --database parameter. Apologies.