"insufficient privilege" when accessing pg_stat_statements
如果你在访问 pg_stat_statements 或 查询性能报告 时看到“权限不足”的错误,这意味着 Postgres 角色没有所需的权限。
🌐 If you see the error "insufficient privilege" when accessing pg_stat_statements or when accessing Query Performance Report, it means that the Postgres role does not have required permissions.
在这种情况下,你可以运行以下命令来允许 Postgres 角色读取系统中的所有统计信息:
🌐 In this case, you can run the below command to allow the Postgres role to read all statistics from the system:
1grant pg_read_all_stats to postgres;