explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7JWJ : migracija_pon_spor

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=25.43..7,850.42 rows=500 width=20) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Foreign Scan on user_log (cost=25.00..1,025.00 rows=1,000 width=20) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_user_userid on buff_user (cost=0.43..8.10 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (user_id = user_log.user_id)