Changes between Version 10 and Version 11 of QueryOptimization

Timestamp:

05/18/26 11:44:27 (8 days ago)

Author:

231017

Comment:

--

QueryOptimization

@@ -498 +498 @@
                           Hash Cond: (s.owner_artist_id = a.id)
                           ->  Hash Left Join  (cost=46637.31..89522.94 rows=43884 width=84) (actual time=1076.395..1343.191 rows=60789 loops=5)
-                                Hash Cond: (s.published_by_label_admin_id = la.id)
+                                Hash Cond: (s.published_by_label_id = l.id)
                                 ->  Hash Join  (cost=43501.50..86090.08 rows=43884 width=48) (actual time=1071.308..1327.862 rows=60789 loops=5)
                                       Hash Cond: (s.id = sc.song_id)
@@ -535 +535 @@
 "  Timing: Generation 14.075 ms (Deform 6.062 ms), Inlining 0.000 ms, Optimization 5.950 ms, Emission 133.686 ms, Total 153.711 ms"
 Execution Time: 1682.017 ms
+
 }}}