I have this recurring error that I can't solve on postgres plugin, and I'm not sure where to intervene. The cpu is ok and there are no bottlenecks.
buffer flush took longer time than slow_flush_log_threshold
I always get this error
<match zeek_dns>
type postgres
<buffer>
flush_thread_count 8
</buffer>
host "#{ENV['DB_SERVER']}"
port "#{ENV['DB_PORT']}"
database "#{ENV['DB_NAME']}"
username "#{ENV['DB_USERNAME_FEEDER']}"
password "#{ENV['PSH']}"
key_names ts,uid,id.orig_h,id.orig_p,id.resp_h,id.resp_p,proto,trans_id,rtt,query,qclass,qclass_name,qtype,qtype_name,rcode,rcode_name,AA,TC,RD,RA,Z,answers,TTLs,rejected
sql INSERT INTO dns(ts,uid,id_orig_h,id_orig_p,id_resp_h,id_resp_p,proto,trans_id,rtt,query,qclass,qclass_name,qtype,qtype_name,rcode,rcode_name, aa,tc,rd,ra,z,answers,ttls,rejected) values (to_timestamp($1),$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24)
flush_interval 5s
</match>.
Can you help me?