Store WHERE IN condition / filter from query to a table postgres

Viewed 27

I need to create a view to reduce query time over JSONB. To do this I want to create a table that keeps track of the WHERE IN condition of this exact query SELECT data_timestamp, key, value FROM hit_count CROSS JOIN jsonb_each(data) WHERE key IN ('2134','1234',...); as it comes in. How could I accomplish this?

0 Answers
Related