Example: Displaying 1 to 50 of 67.614 items (filtered from 671.531.669 total entries) I want to avoid the calculate of 671.531.669, it is the “select count(*) from table;” without conditions. When I define de getTotalItems only I change de 67.614, it isn`t the solution.

It is No solution, I need avoid de count() from all table ( from 671,531,669 total records) no from filtered rows. The count() is from all table always , I have put a $crud->where([‘transitos.matricula like ?’=>‘8068%’]); and it shows the total from de table.

My postgresql table has 600 millions (at the future 2000 M) rows y the rdbms spends 67 seconds on the count(*). It doesn`t read the datum from db dictionary as mysql. Thank (gracias) for the solution. BR (Saludos)

I have trucated the field to ‘second’ and change de type to timestramp without tz and its works. Thank