100hundred million select query (Zabbix5.4.12, PostgreSQL,TimesclaeDB)
Hello. I got incident connected with our Zabbix. Last night i was called from our l1 support request that our monitoring didn't work. I went on different metrics and queryes and noticed a strange behavior.
In one moment out database got 100 hundred million select in a second for 20 min. This query created 6-4 thousand access share locks. If check pg_activivty with pg_top or other explain on spam query can be seen that chanks were unpacking. IDK that i can do to resolve this problem. I need some help to resolve it
In one moment out database got 100 hundred million select in a second for 20 min. This query created 6-4 thousand access share locks. If check pg_activivty with pg_top or other explain on spam query can be seen that chanks were unpacking. IDK that i can do to resolve this problem. I need some help to resolve it
Comment