Skip to content

"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:

1
grant pg_read_all_stats to postgres;