Features
Games
Add-ons
Docs
Pricing
Forums
Blog
Log in
Sign Up

Features

Games

Add-ons

Docs

Pricing

Support

Blog

Log in

Sign Up

  • Ask a question
  • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Topics
    • Questions
    • Ideas
    • Articles
    • Users
    • Badges
  • Home /
  • General Discussion /
avatar image
Question by totaloncue · Oct 08, 2018 at 07:40 AM · analytics

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

Comment

People who like this

0 Show 1
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image totaloncue · Dec 02, 2018 at 04:04 AM 0
Share

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

1 Reply

· Add your reply
  • Sort: 
avatar image
Best Answer

Answer by Andy · Oct 09, 2018 at 05:42 AM

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

Comment

People who like this

0 Show 5 · Share
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image totaloncue · Oct 09, 2018 at 05:06 PM 0
Share

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

avatar image Andy ♦♦ totaloncue · Oct 11, 2018 at 06:21 PM 0
Share

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.

avatar image totaloncue Andy ♦♦ · Oct 12, 2018 at 11:24 AM 0
Share

Thanks! This has fixed the issue for us.

Show more comments

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Navigation

Spaces
  • General Discussion
  • API and SDK Questions
  • Feature Requests
  • PlayStream
  • Bugs
  • Add-on Marketplace
  • Follow this Question

    Answers Answers and Comments

    2 People are following this question.

    avatar image avatar image

    Related Questions

    Can't group by custom fields in events 1 Answer

    Can I increase data retention for Event History? Now it's only 30 days 1 Answer

    Ignore (or mark) developer accounts in tracking 1 Answer

    Google Ads "App analytics provider Id" 1 Answer

    How to get most active time of the day for players 1 Answer

    Tickets

    Need help with a confidential issue? We've got your back!

  • Create Ticket
  • View Open Tickets
  • Stay up-to-date with the latest from PlayFab:  
    Sign up for newsletter
    Engineers
    • Documentation
    • Tutorials
    • API Reference
    • SDKs
    • Usage Limits
    PLAYFAB
    • Features
    • Games
    • Add-ons
    • Pricing
    Support
    • Forums
    • Videos
    • File a Ticket
    • Service Health
    • Blog
    About
    • About
    • Jobs
    • Contact
    • Press Room
    • Privacy Policy
    • Terms of Service
    • Acceptable Use
    • Style Guide
     
     
    Sign Up

    ©2017 PlayFab, Inc.

    ©2016 PlayFab, Inc. All rights reserved. PlayFab® is a registered trademark of PlayFab, Inc. | Privacy | Terms | Acceptable Use
    • Anonymous
    • Sign in
    • Create
    • Ask a question
    • Post an idea
    • Create an article
    • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Explore
    • Topics
    • Questions
    • Ideas
    • Articles
    • Users
    • Badges