4 ms·

SELECT action_type, COUNT(*) FROM pair_actions GROUP BY action_type;