performance optimalisation

[phavekes]

This issue is imported from pivotal - Originaly created at Apr 13, 2023 by Bart Geesink

Our production influx is experiencing some issues with its performance, so I was looking into the database what current query is running:
435 SELECT count(distinct(user_id)) AS distinct_count_user_id INTO log_logins.autogen.sp_idp_pa_users_year_unique FROM log_logins.autogen.EBAUTH WHERE state = 'prodaccepted' AND time >= '1970-01-01T00:00:00Z' AND time < '2071-08-02T23:34:33.709551616Z' GROUP BY sp_entity_id, idp_entity_id, time(12600w), year log_logins 17m2s running

It seems to me it is querying everything, not only this year. Is there a way to optimise this particular query? I'll have a look into the log to check for other long running queries