In this video, I'm showing you what options you have to index JSON columns when using PostgreSQL.
I explain how to index logical conditions that check for the existence of a given JSON attribute, as well as if a given key/value pair is contained withing the JSON object.
Next, I will explain how GIN indexes work and the difference between json_ops and json_path_ops operators.