The official list of supported extensions in Render’s docs includes
pg_stat_statements as an option. However, connecting to my database indicates that
pg_stat_statements is already enabled:
database_txxx=> create extension pg_stat_statements; ERROR: extension "pg_stat_statements" already exists
But the views that you’d expect to exist if it was enabled don’t exist:
database_txxx=> select * from pg_stat_statements limit 10; ERROR: relation "pg_stat_statements" does not exist
And the docs for pg_stat_statements suggests that you need to enable it in preload libraries because it requires additional space:
The module must be loaded by adding
pg_stat_statementsto shared_preload_libraries in
postgresql.conf, because it requires additional shared memory.
So: is pg_stat_statements something that Render databases can support? Is it enabled, but I can’t access its view and methods? Do I need to restart my database to get it working?