Stats Command

[IanMitchell]

Run this query and output results:

SELECT
	category,
	COUNT(category) AS value_occurrence
FROM
	analytic_events
WHERE
	context ->> 'userId' = '176793948025520128'
GROUP BY
	category
ORDER BY
	value_occurrence DESC
LIMIT 10;

[IanMitchell]

Per Sindalf, this should be added:

CREATE INDEX context_userid ON analytic_events USING btree ((context -> 'userId'));