Query chooses Bad Index Path

Postgres version: 11.4 Problem: Query choosing Bad Index Path. Details are provided below Table : \d public.distdbentityauditlog1_46625_temp_mahi1; Table "public.distdbentityauditlog1_46625_temp_mahi1" Column |Type | Collation | Nullable | Defa

Query choosing Bad Index Path (ASC/DESC ordering).

Postgres version: 11.4 Problem: Query choosing Bad Index Path (ASC/DESC ordering). Details are provided below Table: \d public.distdbentityauditlog1_46625_temp_mahi3; Table "public.distdbentityauditlog1_46625_temp_mahi3" Column |Type | Collation |