Project

General

Profile

action #94705

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 3 months ago. Updated 3 months ago.

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

0%

Estimated time:
Difficulty:

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)

History

#1 Updated by tinita 3 months ago

  • Parent task set to #92854

Also available in: Atom PDF