11 lines
347 B
SQL
11 lines
347 B
SQL
-- Créer l'extension pg_stat_statements
|
|
CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
|
|
|
|
-- Configurer les paramètres pg_stat_statements
|
|
ALTER SYSTEM SET pg_stat_statements.max = 10000;
|
|
ALTER SYSTEM SET pg_stat_statements.track = 'all';
|
|
ALTER SYSTEM SET pg_stat_statements.save = 'on';
|
|
|
|
-- Recharger la configuration
|
|
SELECT pg_reload_conf();
|