I enabled extension pg_stat_statements for PostgreSQL
create EXTENSION pg_stat_statements;
How can I stop using extension pg_stat_statements in PostgreSQL 9.x?
Even original documentation does not contain any examples.
Each PSQL database table is a separate file with a default file extension of . mkd.
Get a list of all the extensions installed on a database by using the \dx command. For example, the output for \dx when run on the Databases for PostgreSQL default database shows the only installed extension.
The pg_stat_statements module provides a means for tracking planning and execution statistics of all SQL statements executed by a server. The module must be loaded by adding pg_stat_statements to shared_preload_libraries in postgresql. conf , because it requires additional shared memory.
DROP EXTENSION pg_stat_statements;
DROP EXTENSION IF EXISTS <extension name>; CREATE EXTENSION <extension name>;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With