question

totaloncue avatar image
totaloncue asked

Slowdown in Snowflake queries

We are currently seeing a significant slowdown in querying data related to our game in Snowflake and are trying to find the cause.

Our query which references the PLAYFAB_SHARED database used to run in ~1minute over the last couple of weeks, but as of yesterday, the same query runs for >15+ minutes without completion and without any change in the size of the data queried.

Further context: we create a replica of our game's data for the previous 7 days (copying from the PLAYFAB_SHARED database into our own database) in order to run further queries at a faster speed, without having to access the PLAYFAB_SHARED database for each query. Our game is currently in soft launch and records ~300k events over a 7-day period (~50MB of data).

The specific query we use is:

select *

from PLAYFAB_SHARED.PLAYFAB_SHARED.PLAYFAB_ARCHIVE_SHARED

WHERE title_id = 'A0D3'

AND ts >= dateadd(days, -7, current_date)

AND ts < current_date

Any ideas on what we should be looking at to investigate the reason for the slowdown in the query would be great.

Thanks

analytics
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

totaloncue avatar image totaloncue commented ·

I just tried the query again and it ran in <10 seconds just now; so issue seems resolved. Thanks Andy

0 Likes 0 ·

1 Answer

·
Andy avatar image
Andy answered

I'm seeing the slowdown as well. I'm checking with the team on the status of our regular reclustering jobs.

5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

totaloncue avatar image totaloncue commented ·

Thank you. Please do let us know when a solution is found/deployed.

0 Likes 0 ·
Andy avatar image Andy ♦♦ totaloncue commented ·

Apologies for the delay. Snowflake performance should have returned to normal sometime yesterday afternoon. There was a bit of a log-jam in the job queue that was delaying reclustering.

0 Likes 0 ·
totaloncue avatar image totaloncue Andy ♦♦ commented ·

Thanks! This has fixed the issue for us.

0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.