| 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))
|
ANALYZEto update the server's statistics.EXPLAINand interpreting its output, see the Postgres documentation, in particular theEXPLAINandANALYZEreferences pages, and Using Explain.