Changes between Version 46 and Version 47 of QueryOptimization

Timestamp:

05/09/26 22:12:55 (3 weeks ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -31 +31 @@
 
 }}}
+
+||= 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'''