Changes between Version 85 and Version 86 of QueryOptimization

Timestamp:

06/30/26 22:36:25 (5 days ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -47 +47 @@
 }}}
 
-||= QUERY PLAN =||
-||Nested Loop  (cost\=1.01..9625.30 rows\=2264 width\=54) (actual time\=0.868..2.190 rows\=775.00 loops\=1)||||
+||= QUERY PLAN =||=  =||
+||Nested Loop  (cost\=1.01..9625.30 rows\=2264 width\=54) (actual time\=0.868..2.190 rows\=775.00 loops\=1)||
 ||Buffers||shared hit\=21 read\=13 dirtied\=1||
-||->  Nested Loop  (cost\=0.57..25.51 rows\=6 width\=38) (actual time\=0.622..0.627 rows\=5.00 loops\=1)||||
+||->  Nested Loop  (cost\=0.57..25.51 rows\=6 width\=38) (actual time\=0.622..0.627 rows\=5.00 loops\=1)||
 ||Buffers||shared read\=6||
-||        ->  Index Scan using ""Venue_pkey"" on ""Venue"" v  (cost\=0.29..8.30 rows\=1 width\=28) (actual time\=0.071..0.072 rows\=1.00 loops\=1)||||
+||        ->  Index Scan using ""Venue_pkey"" on ""Venue"" v  (cost\=0.29..8.30 rows\=1 width\=28) (actual time\=0.071..0.072 rows\=1.00 loops\=1)||
 ||Index Cond||(venue_id \= 1)||
 ||Index Searches||1||
 ||Buffers||shared read\=3||
-||        ->  Index Scan using uq_section_venue_name on ""Section"" s  (cost\=0.29..17.14 rows\=6 width\=18) (actual time\=0.548..0.550 rows\=5.00 loops\=1)||||
+||        ->  Index Scan using uq_section_venue_name on ""Section"" s  (cost\=0.29..17.14 rows\=6 width\=18) (actual time\=0.548..0.550 rows\=5.00 loops\=1)||
 ||Index Cond||(venue_id \= 1)||
 ||Index Searches||1||
 ||Buffers||shared read\=3||
-||  ->  Index Scan using uq_seat_section_number on ""Seat"" st  (cost\=0.44..1590.95 rows\=901 width\=24) (actual time\=0.056..0.282 rows\=155.00 loops\=5)||||
+||  ->  Index Scan using uq_seat_section_number on ""Seat"" st  (cost\=0.44..1590.95 rows\=901 width\=24) (actual time\=0.056..0.282 rows\=155.00 loops\=5)||
 ||Index Cond||(section_id \= s.section_id)||
 ||Index Searches||5||
 ||Buffers||shared hit\=21 read\=7 dirtied\=1||
-||Planning||||
+||Planning||
 ||Buffers||shared hit\=14 read\=22||
 ||Planning Time||5.752 ms||