CHTSync taking long in refreshes

[billwambua]

When I recreated the dbt schema and ran the brac config from an empty schema, after the initial rebuild, subsequent refreshes are now taking very long. Initially they were taking less than 2 minutes, now they are taking up to 6hours, almost the same time as a build.
Before
tmux-history-chtsync-0-0-20220820T050708.log

After
tmux-log.log

cc @njogz @derickl

[derickl]

@billwambua Could you run an explain on the actual query being executed to get more insights on why it's taking long?