After further testing, I’ve found that indexing seq_no and publish_status cause this worse performance
Look like other issue Filtering is slow on large amount of data - #6 by diggy
Removing these index help increase performance, but the problem that I need to query and apply the filter in the publish_status over GraphQL, removing its index mean removing filter on these field.