| | 33 | |
| | 34 | ||= QUERY PLAN =|||| |
| | 35 | ||= Nested Loop (cost\=1.14..73.38 rows\=7 width\=68) (actual time\=1505.862..3249.242 rows\=4 loops\=1) =|||| |
| | 36 | ||= -> Nested Loop (cost\=0.86..70.92 rows\=7 width\=37) (actual time\=1079.648..2259.465 rows\=4 loops\=1) =|||| |
| | 37 | ||= -> 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) =|||| |
| | 38 | ||= Index Cond =||(performer_id \= 10)|| |
| | 39 | ||= -> Nested Loop (cost\=0.57..62.55 rows\=7 width\=24) (actual time\=378.637..1558.442 rows\=4 loops\=1) =|||| |
| | 40 | ||= -> 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) =|||| |
| | 41 | ||= Index Cond =||(performer_id \= 10)|| |
| | 42 | ||= Heap Fetches =||0|| |
| | 43 | ||= -> 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) =|||| |
| | 44 | ||= Index Cond =||(event_happening_id \= ehp.event_happening_id)|| |
| | 45 | ||= -> 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) =|||| |
| | 46 | ||= Index Cond =||(event_id \= eh.event_id)|| |
| | 47 | ||= Planning Time =||1816.633 ms|| |
| | 48 | ||= Execution Time =||3249.314 ms|| |
