Postgresql slow transactions

comete-geek · August 11, 2021, 9:44am

Hi,

is it possible for Netdata to monitor Postgresql slow transactions and alerts on them ?

thank you !

Morgan

andrewm4894 · August 17, 2021, 10:39am

I would imagine slow transactions would be picked up on the default charts for the PostgreSQL collector.

https://learn.netdata.cloud/docs/agent/collectors/python.d.plugin/postgres

As for how to then define alarms for slow transactions i’m not so sure. I’d imagine you could maybe use the mysql alarms for inspiration to some extent.

github.com

netdata/netdata/blob/master/health/health.d/mysql.conf


# slow queries

 template: mysql_10s_slow_queries
       on: mysql.queries
    class: Latency
     type: Database
component: MySQL
   lookup: sum -10s of slow_queries
    units: slow queries
    every: 10s
     warn: $this > (($status >= $WARNING)  ? (5)  : (10))
     crit: $this > (($status == $CRITICAL) ? (10) : (20))
    delay: down 5m multiplier 1.5 max 1h
     info: number of slow queries in the last 10 seconds
       to: dba


# -----------------------------------------------------------------------------
# lock waits

This file has been truncated. show original

p.s we also have a “help-me-build-an-alert” channel in our discord where other might be able to help: Discord

comete-geek · August 17, 2021, 11:15am

Hi, thanks for your answer.
Default Postgresql charts don’t show slow queries and I didn’t found any metrics for them…

Topic		Replies	Views
Help with SQL query Postgres and use result for chart Help	1	109	March 5, 2024
Netdata for PostgreSQL monitoring General faq , how-to , announcement	1	721	October 4, 2022
How to manage notifications for PostgreSQL cluster (Primary / Standby) Help agent	0	73	June 17, 2024
unable to disable postgres alarm General question	0	186	November 30, 2023
Monitoring postgresql database Help agent	2	1196	December 18, 2020

Postgresql slow transactions

Related topics