[cherry-pick][gql] need to add object_status=0 to use partial indexes (#20176)

[cherry-pick][gql] need to add object_status=0 to use partial indexes (#20176) #48276