Amazon Postgres RDS pg_stat_statements not loaded


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

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

The command

does not show the pg_stat_statements library.

And therefore the error above still remains.

Does somebody else has got the same issue ?



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.

Leave a Reply