aasmc

                                         List of relations
 Schema |         Name         | Type  | Owner | Persistence | Access method |  Size  | Description 
--------+----------------------+-------+-------+-------------+---------------+--------+-------------
 public | duplicate_status_job | table | aasmc | permanent   | heap          | 394 MB | 


create index idx_duplicate_status_success on duplicate_status_job(last_execution_time, create_dt DESC) where status = 'SUCCESS';

create index idx_duplicate_status_error on duplicate_status_job(last_execution_time, create_dt DESC) where status = 'ERROR';