Infinite scroll and "Select all"

I have question about how Select All should work (in your opinion/research) together with Infinite Scroll in table.

So I've got this table, which shows 40 items by default. After scrolling to bottom of screen, system loads another 40 items. We also added indicator that says how many items are shown, like: "Items loaded: 40 of 90"

Now, back to Select All.

When showing 40 items should top-checkbox (Select All) select ALL items (in eg. 90 items) in database or just visible (40 items)?

So in first option, user would select all and delete all his data. In second option, user would have to first scroll down to very bottom then scroll back to top and click on Select All checkbox.

Which option is better for ux?

Here's rough lo-fi example:

Clicking checkbox next to column label "name" should select visible items (40) or every item in results (290)?