Suggested index by PgHero

[AliOsm]

While monitoring my Rails app using PgHero, I got a suggestion to add an index to good_jobs table:

add_index :good_jobs, [:error], algorithm: :concurrently

The cause was this query:

SELECT COUNT(*) FROM "good_jobs" WHERE "good_jobs"."retried_good_job_id" IS NULL AND "good_jobs"."finished_at" IS NOT NULL AND "good_jobs"."retried_good_job_id" IS NULL AND "good_jobs"."error" IS NOT NULL

Do you think it is important?