Amazon Postgres RDS pg_stat_statements not loaded

Question

I configured my RDS Postgres 9.6.1 instance so, that the pg_stat_activity is loaded via 'shared_preload_libraries' parameter

shared_preload_libraries=pg_stat_statements,pg_hint_plan

The I rebooted my instance and then check if the pg_stat_statements can be loaded. But I get the error:

[55000] ERROR: pg_stat_statements must be loaded via shared_preload_libraries

The command

SHOW shared_preload_libraries;

does not show the pg_stat_statements library.

And therefore the error above still remains.

Does somebody else has got the same issue ?

Thanks, Detlef

user_1314820 · Answer

Ran into the same problem today.

Turns out I simply had to reboot the database (via CLI or web interface).

As mentioned on the AWS docs:

When you change a static parameter and save the DB parameter group, the parameter change takes effect after you manually reboot the DB instance.