vorpal-buildbot
commented
1 year ago Exceeded slow_query limit (3.9 > 0.5) in mysql: ```
SELECT
d.id,
d.finish,
d.decklist_hash,
cache.active_date,
cache.wins,
cache.losses,
cache.draws,
cache.color_sort,
ct.name AS competition_type_name
FROM
deck AS d
LEFT JOIN
competition AS c ON d.competition_id = c.id
LEFT JOIN
competition_series AS cs ON cs.id = c.competition_series_id
LEFT JOIN
competition_type AS ct ON ct.id = cs.competition_type_id
LEFT JOIN
deck_cache AS cache ON d.id = cache.deck_id
LEFT JOIN deck_cache AS season ON d.id = season.deck_id
WHERE
(d.id IN (SELECT deck_id FROM deck_card WHERE card IN ('Favored Hoplite', 'Cut Down', 'Temple of Enlightenment', 'Brineborn Cutthroat', 'Chain Lightning', 'Grave Titan', 'Changeling Outcast', 'Zof Consumption', 'Psychic Possession', 'Luminarch Ascension', 'Silver-Fur Master', 'Malakir Rebirth', 'Boon-Bringer Valkyrie', 'Mana Leak', 'Isolated Chapel', 'Defabricate', 'Gitaxian Probe', 'Gryff''s Boon', 'Shambling Vent', 'Timely Reinforcements', 'Caves of Koilos', 'Scarab Feast', 'Shardless Agent', 'Frantic Search', 'Detention Sphere', 'Dread Return', 'Tidehollow Sculler', 'Folio of Fancies', 'Runed Halo', 'Slip Out the Back', 'Mikokoro, Center of the Sea', 'Ghost Quarter', 'Kaito, Dancing Shadow', 'Thopter Spy Network', 'Ulcerate', 'Spikefield Hazard', 'Nissa, Worldwaker', 'Disrupting Shoal', 'Timeless Dragon', 'Orim''s Chant', 'Dire-Strain Rampage', 'Tanglepool Bridge', 'Blackbloom Rogue', 'Phoenix Chick', 'Mind''s Desire', 'Commit // Memory', 'Kaya, Ghost Assassin', 'Goblin Charbelcher', 'Akoum Warrior', 'Rift Bolt', 'Ghitu Lavarunner', 'Hyena Umbra', 'Biting-Palm Ninja', 'Resurgent Belief', 'Dryad Militant', 'Kumano Faces Kakkazan', 'Ingenious Infiltrator', 'Lotleth Giant', 'Ossification', 'Silverbluff Bridge', 'Seething Song', 'Narcomoeba', 'Prosperous Thief', 'Scour All Possibilities', 'Glaring Aegis', 'Cabal Ritual', 'Ground Seal', 'Loran''s Escape', 'Azami, Lady of Scrolls', 'Nevermore', 'Slagwoods Bridge', 'Ethereal Armor', 'Duress', 'Vindicate', 'Undercity Informer', 'Illuminator Virtuoso', 'Phantasmagorian', 'Balustrade Spy', 'Flame Rift', 'Vapor Snag', 'Search for Azcanta', 'Strike It Rich', 'Memory Lapse', 'Sweltering Suns', 'Big Score', 'Phyrexian Dreadnought', 'Mazemind Tome', 'Ponder', 'Laboratory Maniac', 'Thousand-Faced Shadow', 'Fetid Heath', 'Moon-Circuit Hacker', 'Celestial Colonnade', 'Fae of Wishes', 'Wayward Guide-Beast', 'Drowned Catacomb', 'Barbarian Ring', 'Incinerate', 'Solitary Confinement', 'Day of Judgment', 'Cleansing Wildfire', 'Dark Ritual', 'Angel of Glory''s Rise', 'Delver of Secrets', 'Choked Estuary', 'Mishra''s Factory', 'Spell Pierce', 'Pelakka Predation', 'Night of Souls'' Betrayal', 'Simian Spirit Guide', 'Ornithopter', 'Haunted Dead', 'Goblin Electromancer', 'Bloodchief''s Thirst', 'Treasure Cruise', 'Judge''s Familiar', 'Lost Legacy', 'Lose Focus', 'Phalanx Leader', 'Shard Volley', 'Bloodbraid Elf', 'Fallen Shinobi', 'Lightning Strike', 'Burst Lightning', 'Jokulhaups', 'Izzet Boilerworks', 'Viashino Pyromancer', 'Glacial Fortress', 'Kunoros, Hound of Athreos'))) AND (TRUE)
GROUP BY
d.id,
d.competition_id, -- Every deck has only one competition_id but if we want to use competition_id in the HAVING clause we need this.
season.season_id -- In theory this is not necessary as all decks are in a single season and we join on the date but MySQL cannot work that out so give it the hint it needs.
HAVING
TRUE
ORDER BY
active_date DESC, d.finish IS NULL, d.finish
```[] (slow_query, 3.9, mysql)
Reported on decksite by mysql-perf
Location Hash: 4dbce9248778bac49eac85ba20d34a2316a2426e
Labels: decksite
[](slow_query, 9.5, mysql)Reported on decksite by mysql-perf
Location Hash: 4dbce9248778bac49eac85ba20d34a2316a2426e