query-plan-1222

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
0.068 100.00% 
 Nested Loop Left Join (cost=0.0..16.55 rows=1 width=139) (actual time=0.058..0.068 rows=1 loops=1)
0.040 58.82% 
   -> Index Scan using facilities_pkey on facilities (cost=0.0..8.27 rows=1 width=125) (actual time=0.036..0.040 rows=1 loops=1)
         Index Cond: (fc_facility_id = 509)
0.003 4.41% 
   -> Index Scan using people_pk on people (cost=0.0..8.27 rows=1 width=18) (actual time=0.003..0.003 rows=0 loops=1)
         Index Cond: (facilities.fc_director_id = people.pp_id)
Run-time
0.201 ms