In order to enable tracking with pg_stat_statements on amazon RDS posgress, you need to run this statement in DBeaver or similar:

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

Then you can immediately do things like

select * from pg_stat_statements

However, if you wish to turn it off for a period (Without rebooting the DB), how do you do it?

I don’t have access to the CLI, only sql.