Hi Jakub Radlica as explained at the end of the User Guide Limits and offsets paragraph
When limits or pagination are combined with a fetch join, Hibernate must retrieve all matching results from the database and apply the limit in memory!