Changes between Version 93 and Version 94 of QueryOptimization

Timestamp:

06/30/26 23:44:05 (5 days ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -450 +450 @@
 ||Buffers shared hit\=1 read\=466||
 ||->  Hash  (cost\=260.00..260.00 rows\=256 width\=66) (actual time\=1.525..1.527 rows\=256.00 loops\=1)||
-||Buckets 1024  Batches 1  Memory Usage 33kB||
+||Buckets 1024 Batches 1 Memory Usage 33kB||
 ||Buffers shared hit\=1 read\=134||
 ||              ->  Seq Scan on ""Venue"" v  (cost\=0.00..260.00 rows\=256 width\=66) (actual time\=0.160..1.467 rows\=256.00 loops\=1)||
-||Filter ((address_city)||||text \= 'London'||||text)||
+||Filter ((address_city) text \= 'London' text)||
 ||Rows Removed by Filter 9744||
 ||Buffers shared hit\=1 read\=134||
@@ -550 +550 @@
 ||Buffers shared hit\=3 read\=37||
 ||->  Hash  (cost\=260.00..260.00 rows\=74 width\=66) (actual time\=1.755..1.755 rows\=74.00 loops\=1)||
-||Buckets 1024  Batches 1  Memory Usage 15kB||
+||Buckets 1024 Batches 1 Memory Usage 15kB||
 ||Buffers shared read\=135||
 ||              ->  Seq Scan on ""Venue"" v  (cost\=0.00..260.00 rows\=74 width\=66) (actual time\=0.118..1.700 rows\=74.00 loops\=1)||
-||Filter ((address_city)||||text \= 'Berlin'||||text)||
+||Filter ((address_city) text \= 'Berlin' text)||
 ||Rows Removed by Filter 9926||
 ||Buffers shared read\=135||