-- 记录超过1秒的查询
ALTER SYSTEM SET log_min_duration_statement = 1000;
SELECT pg_reload_conf();

CREATE EXTENSION pg_stat_statements;

-- 最慢的10个查询
SELECT
    query,
    calls,
    mean_exec_time,
    total_exec_time
FROM pg_stat_statements
ORDER BY mean_exec_time DESC
LIMIT 10;