evergreen=# explain analyze SELECT  "aump".id,
        "aump".create_date,
        "aump".ausp_set_date,
        "aump".aum_create_date,
        "aump".read_date,
        "aump".org_unit,
        "aump".ausp_org_unit,
        "aump".aum_sending_lib,
        "aump".ausp_id,
        "aump".aum_id,
        "aump".deleted,
        "aump".title,
        "aump".usr,
        "aump".ausp_usr,
        "aump".aum_usr,
        "aump".message,
        "aump".pub,
        "aump".stop_date,
        "aump".ausp_stop_date,
        "aump".aum_stop_date,
        "aump".editor,
        "aump".edit_date,
        "aump".staff,
        "aump".standing_penalty,
        "aump".ausp_usr_message
        FROM actor.usr_message_penalty AS "aump"
        WHERE "aump".id = '2048501:11778169';
-[ RECORD 1 ]------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUERY PLAN | Hash Full Join  (cost=202096.81..3676686.99 rows=83858 width=875) (actual time=20666.143..23754.688 rows=1 loops=1)
-[ RECORD 2 ]------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUERY PLAN |   Hash Cond: (aum.id = ausp.usr_message)
-[ RECORD 3 ]------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUERY PLAN |   Filter: (((ausp.id IS NOT NULL) OR (NOT aum.deleted)) AND (((COALESCE((ausp.id)::text, ''::text) || ':'::text) || COALESCE((aum.id)::text, ''::text)) = '2048501:11778169'::text))
-[ RECORD 4 ]------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUERY PLAN |   Rows Removed by Filter: 17947287
-[ RECORD 5 ]------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUERY PLAN |   ->  Seq Scan on usr_message aum  (cost=0.00..1849829.01 rows=16771501 width=775) (actual time=0.089..6607.371 rows=16762614 loops=1)
-[ RECORD 6 ]------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUERY PLAN |   ->  Hash  (cost=124647.47..124647.47 rows=6195947 width=44) (actual time=3077.683..3077.683 rows=6195947 loops=1)
-[ RECORD 7 ]------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUERY PLAN |         Buckets: 8388608  Batches: 1  Memory Usage: 495454kB
-[ RECORD 8 ]------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUERY PLAN |         ->  Seq Scan on usr_standing_penalty ausp  (cost=0.00..124647.47 rows=6195947 width=44) (actual time=0.034..1116.154 rows=6195947 loops=1)
-[ RECORD 9 ]------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUERY PLAN | Planning time: 1.296 ms
-[ RECORD 10 ]-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUERY PLAN | Execution time: 23784.303 ms