Changes between Version 44 and Version 45 of QueryOptimization

Timestamp:

05/09/26 22:03:06 (2 weeks ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -32 +32 @@
 }}}
 
-||= QUERY PLAN =||||
-||= Nested Loop  (cost\=1.14..73.38 rows\=7 width\=68) (actual time\=1505.862..3249.242 rows\=4 loops\=1) =||||
-||= ->  Nested Loop  (cost\=0.86..70.92 rows\=7 width\=37) (actual time\=1079.648..2259.465 rows\=4 loops\=1) =||||
-||=         ->  Index Scan using ""Performer_pkey"" on ""Performer"" p  (cost\=0.28..8.30 rows\=1 width\=21) (actual time\=701.003..701.005 rows\=1 loops\=1) =||||
-||= Index Cond =||(performer_id \= 10)||
-||= ->  Nested Loop  (cost\=0.57..62.55 rows\=7 width\=24) (actual time\=378.637..1558.442 rows\=4 loops\=1) =||||
-||=               ->  Index Only Scan using uq_performer_at_time on ""Event_Happening_Performer"" ehp  (cost\=0.29..4.41 rows\=7 width\=16) (actual time\=90.817..90.838 rows\=4 loops\=1) =||||
-||= Index Cond =||(performer_id \= 10)||
-||= Heap Fetches =||0||
-||=               ->  Index Scan using ""Event_Happening_pkey"" on ""Event_Happening"" eh  (cost\=0.29..8.30 rows\=1 width\=24) (actual time\=366.888..366.889 rows\=1 loops\=4) =||||
-||= Index Cond =||(event_happening_id \= ehp.event_happening_id)||
-||=   ->  Index Scan using ""Event_pkey"" on ""Event"" e  (cost\=0.29..0.35 rows\=1 width\=39) (actual time\=247.432..247.432 rows\=1 loops\=4) =||||
-||= Index Cond =||(event_id \= eh.event_id)||
-||= Planning Time =||1816.633 ms||
-||= Execution Time =||3249.314 ms||
+||= QUERY PLAN =||=  =||
+||Nested Loop  (cost\=1.14..73.38 rows\=7 width\=68) (actual time\=1505.862..3249.242 rows\=4 loops\=1)||||
+||->  Nested Loop  (cost\=0.86..70.92 rows\=7 width\=37) (actual time\=1079.648..2259.465 rows\=4 loops\=1)||||
+||        ->  Index Scan using ""Performer_pkey"" on ""Performer"" p  (cost\=0.28..8.30 rows\=1 width\=21) (actual time\=701.003..701.005 rows\=1 loops\=1)||||
+||Index Cond||(performer_id \= 10)||
+||->  Nested Loop  (cost\=0.57..62.55 rows\=7 width\=24) (actual time\=378.637..1558.442 rows\=4 loops\=1)||||
+||              ->  Index Only Scan using uq_performer_at_time on ""Event_Happening_Performer"" ehp  (cost\=0.29..4.41 rows\=7 width\=16) (actual time\=90.817..90.838 rows\=4 loops\=1)||||
+||Index Cond||(performer_id \= 10)||
+||Heap Fetches||0||
+||              ->  Index Scan using ""Event_Happening_pkey"" on ""Event_Happening"" eh  (cost\=0.29..8.30 rows\=1 width\=24) (actual time\=366.888..366.889 rows\=1 loops\=4)||||
+||Index Cond||(event_happening_id \= ehp.event_happening_id)||
+||  ->  Index Scan using ""Event_pkey"" on ""Event"" e  (cost\=0.29..0.35 rows\=1 width\=39) (actual time\=247.432..247.432 rows\=1 loops\=4)||||
+||Index Cond||(event_id \= eh.event_id)||
+||Planning Time||1816.633 ms||
+||Execution Time||3249.314 ms||
 
  * '''INSERT'''