Project

General

Profile

action #112850

openQA Project - coordination #128366: [epic] further improvement after we did ensure all our database tables accomodate enough data

Make pgstatstatements persistent on OSD (in salt)

Added by okurz 11 months ago. Updated about 1 month ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
QA - future
Start date:
Due date:
% Done:

0%

Estimated time:

Description

Motivation

In #112718 we have enabled https://www.postgresql.org/docs/current/pgstatstatements.html but it's not yet made persistent. We should make sure it is.

Related issues

Copied from openQA Infrastructure - coordination #112718: [alert][osd] openqa.suse.de is not reachable anymore, response times > 30s, multiple alerts over the weekendResolved2022-06-22

History

#1 Updated by okurz 11 months ago

  • Copied from coordination #112718: [alert][osd] openqa.suse.de is not reachable anymore, response times > 30s, multiple alerts over the weekend added

#2 Updated by okurz 11 months ago

  • Parent task set to #109846

#3 Updated by okurz 11 months ago

  • Target version changed from Ready to future

#4 Updated by nicksinger 11 months ago

  • Status changed from New to Feedback
  • Assignee set to nicksinger

https://progress.opensuse.org/issues/112850 as a first draft. Need to get some feedback from mkittler (https://suse.slack.com/archives/C02AJ1E568M/p1658223896087059) what was actually changed. The following lines might need to be included in this MR:

# Debugging for https://progress.opensuse.org/issues/112718
compute_query_id = on
pg_stat_statements.max = 10000
pg_stat_statements.track = all

#5 Updated by nicksinger 11 months ago

  • Status changed from Feedback to New
  • Assignee deleted (nicksinger)

Clarified, additional lines have been added. Further discussion needs to happen if we enable this feature by default all the time or just have it in the config (see discussion in https://suse.slack.com/archives/C02AJ1E568M/p1658223896087059). Putting back into new due to this

#6 Updated by okurz about 1 month ago

  • Parent task changed from #109846 to #128366

Also available in: Atom PDF