Hi,

I notice that this query takes about 10 seconds on our odoo 12 installation.

SELECT count(u.*)
FROM res_users u
WHERE active=true AND
share=false AND
NOT exists(SELECT 1 FROM res_users_log WHERE create_uid=u.id);

Can I somehow optimize it? For example with an database index?