| 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|| |
