Обсуждение: pgagent
hello on pgadmin4 every five seconds this query repeat SELECT J.jobid FROM pgagent.pga_job J WHERE jobenabled AND jobagentid IS NULL AND jobnextrun <= now() AND (jobhostagent = '' OR jobhostagent = 'grafana') ORDER BY jobnextrun my problem is I enable logs of postgresql on log is written
--
--
Ing. Henry G. Cortez
Hi Henry, > On 06. Oct, 2020, at 23:46, Henry Francisco Garcia Cortez <garcortez@gmail.com> wrote: > > hello on pgadmin4 every five seconds this query repeat SELECT J.jobid FROM pgagent.pga_job J WHERE jobenabled ANDjobagentid IS NULL AND jobnextrun <= now() AND (jobhostagent = '' OR jobhostagent = 'grafana') ORDER BY jobnextrunmy problem is I enable logs of postgresql on log is written maybe you take a look at your logging parameters. You may especially set: log_statement = ddl # or none log_min_messages = warning log_min_error_statement = error See: What to Log https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT Cheers, Paul
Thanks, I'll check it out.
El mar., 6 oct. 2020 a las 23:56, Paul Förster (<paul.foerster@gmail.com>) escribió:
Hi Henry,
> On 06. Oct, 2020, at 23:46, Henry Francisco Garcia Cortez <garcortez@gmail.com> wrote:
>
> hello on pgadmin4 every five seconds this query repeat SELECT J.jobid FROM pgagent.pga_job J WHERE jobenabled AND jobagentid IS NULL AND jobnextrun <= now() AND (jobhostagent = '' OR jobhostagent = 'grafana') ORDER BY jobnextrun my problem is I enable logs of postgresql on log is written
maybe you take a look at your logging parameters. You may especially set:
log_statement = ddl # or none
log_min_messages = warning
log_min_error_statement = error
See: What to Log
https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
Cheers,
Paul
--
Ing. Henry G. Cortez