3 ms·

I've used triggers to extract json data on insert. quite flexible and allows to store the whole JSON without overhead of inserting data twice.