query without deleted = 'f'

                                                                                                     QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Hash Full Join  (cost=12.33..121.65 rows=12 width=877) (actual time=0.054..0.067 rows=5 loops=1)
   Hash Cond: ((aum.usr = ausp.usr) AND (aum.id = ausp.usr_message))
   Filter: (((ausp.id IS NOT NULL) OR (NOT aum.deleted)) AND ((LEAST(ausp.stop_date, aum.stop_date) IS NULL) OR (LEAST(ausp.stop_date, aum.stop_date) > '2020-09-10 12:03:16.286173-04'::timestamp with time zone)))
   ->  Index Scan using aum_usr on usr_message aum  (cost=0.43..109.11 rows=36 width=777) (actual time=0.010..0.015 rows=5 loops=1)
         Index Cond: (usr = 3690472)
   ->  Hash  (cost=11.85..11.85 rows=3 width=44) (actual time=0.031..0.031 rows=5 loops=1)
         Buckets: 1024  Batches: 1  Memory Usage: 9kB
         ->  Index Scan using actor_usr_standing_penalty_usr_idx on usr_standing_penalty ausp  (cost=0.43..11.85 rows=3 width=44) (actual time=0.019..0.027 rows=5 loops=1)
               Index Cond: (usr = 3690472)
 Planning time: 0.354 ms
 Execution time: 0.107 ms
(11 rows)

(END)