explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rNtt

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 0.046 ↑ 16.0 1 1

Nested Loop (cost=0.86..75.52 rows=16 width=119) (actual time=0.045..0.046 rows=1 loops=1)

  • -> Index Scan using idx_user_name on "user" (cost=0.43..11.59 rows=9 width=8) (actual time=0.031..0.
  • Index Cond: (name = '\u0000'::text)
  • -> Index Scan using ids_user_rel on tweet (cost=0.43..7.05 rows=5 width=127) (actual time=0.011..0.0
  • Index Cond: (user_id = "user".id)
Planning time : 1.605 ms
Execution time : 0.062 ms