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
unable to disable postgres alarm General question	0	129	November 30, 2023
Marking metrics or collectors as required for alerting purposes General feedback	2	286	September 7, 2023
Alarms set to "silent" or commented out keep sending notifications Help agent , alerts , notifications	12	290	November 16, 2023
Can't view alerts Help	5	63	April 10, 2024
Adjust mysql replication sensitivity Help database-monitoring , agent	2	554	April 24, 2021

Postgresql slow transactions

Related Topics