query-plan-1166

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
0.099 100.00% 
 Aggregate (cost=5.15..5.16 rows=1 width=0) (actual time=0.099..0.099 rows=1 loops=1)
0.088 88.89% 
   -> Hash Join (cost=1.07..5.14 rows=1 width=0) (actual time=0.056..0.088 rows=1 loops=1)
         Hash Cond: (users.id = messages.sender_id)
0.037 37.37% 
         -> Seq Scan on users (cost=0.0..3.77 rows=77 width=4) (actual time=0.011..0.037 rows=77 loops=1)
0.015 15.15% 
         -> Hash (cost=1.06..1.06 rows=1 width=4) (actual time=0.015..0.015 rows=1 loops=1)
0.013 13.13% 
               -> Seq Scan on messages (cost=0.0..1.06 rows=1 width=4) (actual time=0.010..0.013 rows=1 loops=1)
                     Filter: ((read_at IS NULL) AND (receiver_id = 1))
Run-time
0.227 ms