Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.4\))
Subject: Re: pgagent
From: =?utf-8?Q?Paul_F=C3=B6rster?= <paul.foerster@gmail.com>
In-Reply-To: 
 <CAJP2v3F-HpnRaU5V=_wTty_UNsQk+_-thY65ctOo-8oru5yJsA@mail.gmail.com>
Date: Wed, 7 Oct 2020 07:56:43 +0200
Cc: pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <940B4814-2625-4A8D-A924-EF9748C0EC3B@gmail.com>
References: 
 <CAJP2v3F-HpnRaU5V=_wTty_UNsQk+_-thY65ctOo-8oru5yJsA@mail.gmail.com>
To: Henry Francisco Garcia Cortez <garcortez@gmail.com>
Precedence: bulk

Hi Henry,

> On 06. Oct, 2020, at 23:46, Henry Francisco Garcia Cortez =
<garcortez@gmail.com> wrote:
>=20
> 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 <=3D now()    AND (jobhostagent =3D '' OR jobhostagent =3D =
'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 =3D ddl              # or none
log_min_messages =3D warning
log_min_error_statement =3D error

See: What to Log
=
https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIM=
E-CONFIG-LOGGING-WHAT

Cheers,
Paul=