buffer flush took longer time than slow_flush_log_threshold POSTGRES

[Vazel]

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?

[José Lecaros]

Hi Vazel,

there are more active users in slack channel slack.Fluentd.org

If you haven't solved your issue, you can try there.