Changes between Version 12 and Version 13 of QueryOptimization

Timestamp:

05/26/26 23:03:16 (16 hours ago)

Author:

231088

Comment:

--

QueryOptimization

@@ -411 +411 @@
 
 {{{
-HashAggregate  (cost=1485307.72..1485320.22 rows=200 width=87) (actual time=32833.146..32833.154 rows=0 loops=1)
-  Group Key: b.bookable_id
+HashAggregate  (cost=1485307.72..1485320.22 rows=200 width=87) (actual time=66672.114..66672.131 rows=0 loops=1)
+Group Key: b.bookable_id
   Filter: (round(avg(r.rating), 2) >= 4.5)
   ->  Hash Right Join
@@ -421 +421 @@
               ->  Seq Scan on review r
 Planning Time: 0.945 ms
-Execution Time: 32835.819 ms
+Execution Time: 66721.664 ms
 }}}