describe process relative dating - Updating table high processor utlization
By default, Redshift uses 5 query slots and allocates one slot per query.Many of the steps are using disk so we need to optimize this query.
The best way to make your SQL queries run faster is to have them do less work.
A great way to do less work is to query a materialized view that's already done the heavy lifting.
clause to filter for only these two event types greatly speeds up this query.
It runs in about 5 seconds and doesn't hit the disk at all.
Or perhaps the query shares a common core with several other queries that also need to run, and resources are wasted recomputing that common data for every query.