pg_stat_statements exists but postgres-exporter complains that it doesn't

Can anyone suggest what is the issue?
root user was given superuser rights on postgres db, I ran create extension pg_stat_statements;
extension was created and checking with \dx i can see it is there in public schema. Then superuser rights were removed from root user. I have installed postgres exporter (using root user in values.yaml), in logs of the pod I can see an error that no pg_stat_statements extension exists.
I see that root has right for using public schema, also on another DB this method worked. I am a bit confused here. Any help would be appreciated!

Start with values.yaml and the pod logs, then compare the PostgreSQL database and connection used by the exporter with the database where pg_stat_statements was created. Done means the cause of the missing-extension report is reproducible and the exporter can detect the extension in the target database, or the configuration limitation is documented.