explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WQdP

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 44.566 ↑ 1.0 5 1

Nested Loop Left Join (cost=0.56..9,907.62 rows=5 width=1,697) (actual time=13.258..44.566 rows=5 loops=1)

2. 0.013 44.537 ↑ 1.0 5 1

Nested Loop (cost=0.28..9,902.49 rows=5 width=333) (actual time=13.253..44.537 rows=5 loops=1)

3. 44.494 44.494 ↑ 1.0 5 1

Seq Scan on user_version_viewed userversio0_ (cost=0.00..9,860.96 rows=5 width=24) (actual time=13.238..44.494 rows=5 loops=1)

  • Filter: (version_id = 170,090)
  • Rows Removed by Filter: 522,553
4. 0.030 0.030 ↑ 1.0 1 5

Index Scan using "keep_userPK" on keep_user user1_ (cost=0.28..8.29 rows=1 width=309) (actual time=0.006..0.006 rows=1 loops=5)

  • Index Cond: (id = userversio0_.logged_user_id)
5. 0.020 0.020 ↑ 1.0 1 5

Index Scan using uc_avataruser_id_col on avatar avatar2_ (cost=0.28..1.02 rows=1 width=1,348) (actual time=0.004..0.004 rows=1 loops=5)

  • Index Cond: (user1_.id = user_id)
Planning time : 0.289 ms
Execution time : 44.601 ms