mediumSQLcomposite and partial indexesSingle-choice MCQ

You create the partial index below to speed up a queue query. Which WHERE clause in a SELECT can the planner use this partial index for?

CREATE INDEX ix_pending ON jobs (created_at) WHERE status = 'pending';