pg_stat_statements not working

[ketys]

Hi, I've got a problem with logging pg_stat_statements ... I've got the module enabled in database (view pg_stat_statements exists in Schemas->public->Views) and there's of course some data. But when I try to access it on frontend, it doesn't show any statistics ... Also host selection is empty (see the picture).

Error log writes only this: ERROR: function zz_utils.get_load_average() does not exist, but I think it's not related to my problem. Any help would be appreciated :)

[ketys]

Ah, maybe I got it ... statStatementsInterval should not be 0? :)

[LappleApple]

@slitsche @a1exsh Can you respond to @ketys?

Thanks for your patience, @ketys. Any updates since your last post?

[ketys]

Yes, I solved it by setting statStatementsInterval to non-zero number :) Thanks (maybe consider to mention this in documentation :))

[LappleApple]

@ketys would you mind making a PR to add it in the docs? we'll merge it then. :)

[dholleran1]

Hi, I'm also having a problem with this. Where is the statStatementsInterval setting you mention?

[a1exsh]

@dholleran1 please go to /hosts URI, there you should see a Settings column which defines a JSON object with settings for gathering data for the hosts. Add "statStatementsInterval": 600, for example if not already there.

[dholleran1]

Yeah I found it. Thanks!