Sorry, I told you that the status was always populated but not, I need that filter for the index because not all records are using that json structure. When json is not null then yes, Status is always there. I have maybe 20 or 25% of records having json populated, so, I really need that filter.
Yes, that solution is fine. Selectivity is fine, speed is fine and the index is "almost dynamic" -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
