describe process relative dating - Updating table high processor utlization

by  |  19-May-2019 10:40

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.

updating table high processor utlization-6

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.

Community Discussion