HangfireIO / HangfireIO/Hangfire

High database CPU usage (postgres)

Open
#2,001 1 comment 7 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
10.1k
Forks
1.8k
Avg merge
1h 19m
Merged PRs (30d)
1

Description

We noticed that the top queries executed on our DB cluster on production are from hangfire:

![image](https://user-images.githubusercontent.com/14803089/154287617-0f44c42e-0471-4d99-9be8-6047d437bd46.png)

The CPU usage from hangfire it's almost the same as our whole platform. Is there a way to tweak these queries? Maybe we can adjust the parameters in order not to be executed so often? Also, have you considered redirecting read-only queries to read-only replicas by allowing specifying 2 different connection strings?

What are your suggestions?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.