{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/48bb136113c14fa881559b259e4732c4\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/os/loom-media-content/loom/95cdfc1b-36fc-40fe-8132-df3029db3286/0a456184-9cb5-4e0b-bc1c-78998f7bf2c4/sessions-thumbnails-48bb136113c14fa881559b259e4732c4-48db6805be805b72.gif/binary?authToken=eyJraWQiOiJtaWNyb3MtZ3JvdXAvdGRwLW9zLWFyY2hldHlwZS9wN2syNWplYmdrZ2R0YnUxIiwiYWxnIjoiUlMyNTYifQ.eyJicyI6Imxvb20tbWVkaWEtY29udGVudCIsImF1ZCI6InRkcC1vcy1hcmNoZXR5cGUiLCJuYmYiOjE3OTI1MzAyMzUsInRpIjoiYTlhYmU3Y2EtYzc0Mi00MGYxLTgzNjMtZmNhZDRiOTczM2VkIiwiYWRpIjoibG9vbS9sb29tIiwiaXNzIjoibWljcm9zLWdyb3VwL3RkcC1vcy1hcmNoZXR5cGUiLCJwaWQiOiJkNzE1OWM0MC0wNGYwLTQ3YzUtYjIzNy0wYzVkNWE1OTA1YzgiLCJ3YSI6ImZhbHNlIiwib2lkIjoic2Vzc2lvbnMtdGh1bWJuYWlscy00OGJiMTM2MTEzYzE0ZmE4ODE1NTliMjU5ZTQ3MzJjNC00OGRiNjgwNWJlODA1YjcyLmdpZiIsImV4cCI6MTc5MjUzMDgzNSwiaWF0IjoxNzkyNTMwMjM1LCJqdGkiOiJkYWY4NGJjZi1hOGMzLTQ5ZjAtOTFlOS0xZDJlMzBkMDhjZGQifQ.ROqwU1-MQLwS32mYUEsbuhxHkxz7Nw8lSSwsLz4fs_qXusJ0wsEZXwHE4pEmZ_lh878_QKD5zkQ6EkqTFSY8T6VGCpKwUvq75Spz-qaqpiHUY4o---FQlktx2NO9MIGZf-8AWukKDkQ5VEM7Ffsv6knOBRn8qm6eyOuOdOI1L5vBUsDnEocoUtJbsrZobHO2CFOSCNTrB3YBoFkFZ4eVnrR_PwXzqB2fu0SLvBMwASTf6rl3lVsGklJ5ff3YueqhXdD5FJocWTbD1EMcZCQSu2zLSL40H5k7KK34VcFaDtfZJ7PnzcgL9mLxeaIfRsEmDhQ58I0x9vEhH9lCeTT7yg&Expires=1792530835&Signature=lTjbY6MRt2r8ym2xbwKd89lncQcYeCbC%7ENIyXLKRh3e%7EbrGD0M2QMYT4OpRoPRAfI3PbNPphuQQerdRHAfdumwKCGMzXZzTQwq6VhfLblyT3U0BoUojo4cYA85GhxHAV5xrKGh6ORV2wjEa4vOx7JeErPLeizYviMdgldRkIUP7SbF734eoPvBqEwQgvx3f-f6N-AWRPS6BcPn-EaaFAyRy%7EKIznPkwuLUmk1A6LBeLHJO3AsxwrkLN-RbQYA%7Eli9L9KzZEKE0nLBixAfv3cWZLLImYJWC9jKr6BWkA6Q9aRAmkrwvpp3H32ZuVTRj4qpV8SbPDZvgKmp8bfglAT7Q__&Key-Pair-Id=KQOSYIR44AIC0","duration":320.22,"title":"Fix Slow Timescale Queries Safely With Forks","description":"This Loom explains how to fix slow production time series queries using a fork stroke fix stroke delete approach to avoid breaking tables and locking. The creator uses Copilot agent mode to fork the production TigerCloud timescale database, creating db_63453_test as an independent copy in US Virginia, then reproduces the issue on the fork and compares explain-analyzed plans before and after. The sequential scan baseline was 0.748 ms with 66 shared buffer hits, while the corrected indexed plan became 0.155 ms with 3 shared buffer hits, improving execution time about 4.8x. After confirming no fatal logs, the fork is deleted and monitoring shows clean checkpoints, with expected fork shutdown errors."}