Partition pruning is the optimization by which the engine ignores the partitions that cannot contain results, based on the query's filter. It only works if the filter is directly on the partitioning column, with no function masking it.
Example
WHERE date_vente >= '2025-01-01' AND date_vente < '2025-02-01'