Project

General

Profile

Actions

action #94705

open

coordination #80142: [saga][epic] Scale out: Redundant/load-balancing deployments of openQA, easy containers, containers on kubernetes

coordination #92854: [epic] limit overload of openQA webUI by heavy requests

Monitor number of SQL queries in grafana

Added by tinita over 2 years ago. Updated about 1 year ago.

Status:
New
Priority:
Low
Assignee:
-
Category:
Feature requests
Target version:
Start date:
2021-06-25
Due date:
% Done:

0%

Estimated time:
Tags:

Description

Currently we are monitoring the number of returned, fetched, inserted, deleted and updated rows:
https://stats.openqa-monitor.qa.suse.de/d/WebuiDb/webui-summary?orgId=1&viewPanel=89&from=now-9d&to=now&refresh=10s

It can also be helpful to monitor the number of queries. Maybe postgres even provides statistics of cache hits/misses.

Monitoring the number of SQL queries can help analyzing performance, and also possibly find accidental code changes, e.g. a removed prefetch in DBIx::Class (like this one: https://github.com/os-autoinst/openQA/pull/3969)


Related issues 1 (0 open1 closed)

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

Actions
Actions #1

Updated by tinita over 2 years ago

  • Parent task set to #92854
Actions #2

Updated by okurz over 1 year ago

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

Updated by okurz about 1 year ago

  • Tags set to infra
Actions

Also available in: Atom PDF