title: Difference between range and lte/gte django filters
body: <p>I am using filters for a model with following two ways: </p>
  
  <blockquote>
    <p>Model.objects.filter(created_date__gte=datetime(2018, 1, 11, 00, 00, 00), created_date__lte=datetime(2018, 11, 11, 23, 59, 59), user_id=135)</p>
  </blockquote>
  
  <p>And </p>
  
  <blockquote>
    <p>Model.objects.filter(user_id=135, created_date__range=["2018-11-1 00:00:00", "2018-11-11 23:59:59"])</p>
  </blockquote>
  
  <p>When i check the count of the both filters there is huge difference of count. </p>
  
  <p>The main question is what is difference between range and gte/lte in filters ?</p>
  
  <p>While using postgres SQL raw query </p>
  
  <blockquote>
    <p>SELECT <em>, count(</em>) OVER() AS full_count FROM table_name 
    WHERE user_id=135 AND created_date BETWEEN DATE('2018-11-01 00:00:00') AND DATE('2018-11-12 23:59:59') ORDER BY created_date;</p>
  </blockquote>
  
  <p>counts are also different with django ORM </p>