The Prophet ﷺ said, "The believer will be given in Paradise such and such strength for sexual relations."Someone asked, "Messenger of Allah, will he be capable of that?"He replied, "He will be given the strength of a hundred."
حدثنا محمد بن بشار ومحمود بن غيلان قالا حدثنا أبو داود الطيالسي عن عمران القطان عن قتادة
عن النبي ﷺ قال يعطى المؤمن في الجنة قوة كذا وكذا من الجماع قيل يا رسول الله أو يطيق ذلك قال يعطى قوة مائة
[Hasan] Bayhaqi narrated it in Bath and Nushur, p. 204, no. 402, from the hadith of Abu Dawud Tayalisi with this wording, and it is found in his Musnad, no. 2012. Ibn Hibban graded it sahih, no. 2635. Qatada uses "an" (indicating a possible break in the chain), and the hadith has many corroborating narrations found in Bayhaqi's Bath and Nushur and in Bazzar's Kashf Astar, 4/198, no. 3526, and others. On this subject there is also a narration from Zayd bin Arqam [Ahmad, 4/367, 371].