Re: pgagent

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