explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QIXN

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

Nested Loop (cost=5.30..544.42 rows=95 width=1,655) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on community_users cus (cost=5.02..55.20 rows=95 width=8) (actual rows= loops=)

  • Recheck Cond: (community_id = 9)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_community_users_on_community_id_and_user_id (cost=0.00..4.99 rows=95 width=0) (actual rows= loops=)

  • Index Cond: (community_id = 9)
4. 0.000 0.000 ↓ 0.0

Index Scan using users_pkey on users u (cost=0.28..5.14 rows=1 width=1,655) (actual rows= loops=)

  • Index Cond: (id = cus.user_id)