query with deleted = 'f'

   QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Hash Left Join  (cost=217586.70..4322552.25 rows=21690 width=877) (actual time=3356.398..18836.236 rows=5 loops=1)
   Hash Cond: ((aum.id = ausp.usr_message) AND (aum.usr = ausp.usr))
   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 11:59:40.080622-04'::timestamp with time zone)) AND (COALESCE(ausp.usr, aum.usr) = 3690472))
   Rows Removed by Filter: 13555593
   ->  Seq Scan on usr_message aum  (cost=0.00..1849740.15 rows=12885143 width=777) (actual time=0.012..7292.932 rows=12895928 loops=1)
         Filter: (NOT deleted)
         Rows Removed by Filter: 3866687
   ->  Hash  (cost=124647.48..124647.48 rows=6195948 width=44) (actual time=3082.903..3082.903 rows=5670944 loops=1)
         Buckets: 8388608  Batches: 1  Memory Usage: 464608kB
         ->  Seq Scan on usr_standing_penalty ausp  (cost=0.00..124647.48 rows=6195948 width=44) (actual time=0.022..1117.227 rows=6195948 loops=1)
 Planning time: 16.781 ms
 Execution time: 18842.727 ms
(12 rows)

(END)