Today, my team and I observed a scenario with our Auth0 Data Explorer query that worked successfully in the past, but starting today, threw a
PG::QueryCanceled: ERROR: canceling statement due to statement timeout error.
We believe the error might be thrown because of the numerous JOIN statements in the query when normalizing the data from different tables.
At the moment, we’ve worked around the problem by separating it into individual queries, but would like to know if it’s possible to use a single query to accomplish our results?
Please let me know if you would like me to DM you a copy of our query for you to see.