A partial index only indexes the rows that satisfy a condition (WHERE). It is smaller and faster to maintain, and useful when queries target a subset, such as unprocessed orders. The query must contain a condition compatible with the index's for it to be used.
Example
CREATE INDEX ON commandes (date) WHERE statut = 'en_attente';