search

ankane / pghero

A performance dashboard for Postgres
MIT License
8.01k stars 447 forks source link

GCP Cloud SQL System Stats not enable. #486

Closed ginoliang1130 closed 8 months ago

ginoliang1130 commented 9 months ago

Hi,

I'd like to inquire about something related to system stats. In the error message of pghero, I found:

Started GET "/connection_stats?duration=86400&period=600" for [ip-address] at 2023-12-21 09:36:37 +0000
Processing by PgHero::HomeController#connection_stats as */*
  Parameters: {"duration"=>"86400", "period"=>"600"}
Completed 500 Internal Server Error in 87ms (ActiveRecord: 34.8ms | Allocations: 11177)

PgHero::NotEnabled (System stats not enabled):

My environment is GCP Cloud SQL. I'm quite certain that the corresponding permissions are set correctly. Uncertain about which part of the process the issue lies, I'd like to inquire if anyone has faced a similar problem.

Thanks.

ankane commented 8 months ago

Hi @ginoliang1130, if you're seeing that error after enabling in the config (and the System tab is showing up), there's likely an old process running where it's not enabled.