Is it possible to change the interval in which apalis checks for new jobs

[IgnisDa]

When I set RUST_LOG=sqlx=trace, I see that SELECT * FROM Jobs WHERE (status = 'Pending' OR status = 'Failed' and attempts < max_attempts)) and run_at < $1 AND job_type > $2 is run > 10 times per second. I would like to reduce to once every minute.

How can I do this?

[geofmureithi]

You should be able to set this using fetch_interval:

apalis/examples/postgres/src/main.rs

Lines 44 to 50 in 42b1ab2

	.with_storage_config(pg.clone(), |cfg| {
	cfg
	// Set the buffer size to 100 ( Pick 100 jobs per query)
	.buffer_size(250)
	// Lower the fetch interval because postgres is waiting for notifications
	.fetch_interval(Duration::from_millis(200))
	})