explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Evit

Settings
# exclusive inclusive rows x rows loops node
1. 1.951 46.368 ↓ 26.0 52 1

GroupAggregate (cost=1.54..3,411.36 rows=2 width=12) (actual time=1.434..46.368 rows=52 loops=1)

  • Group Key: o.executor_id
2. 1.204 44.417 ↓ 4,622.5 9,245 1

Nested Loop (cost=1.54..3,411.33 rows=2 width=4) (actual time=0.180..44.417 rows=9,245 loops=1)

3. 0.179 3.683 ↓ 5.6 67 1

Nested Loop (cost=1.12..3,316.74 rows=12 width=12) (actual time=0.134..3.683 rows=67 loops=1)

4. 0.214 2.322 ↑ 1.1 394 1

Nested Loop (cost=0.69..3,074.82 rows=420 width=8) (actual time=0.026..2.322 rows=394 loops=1)

5. 0.384 0.384 ↑ 1.0 431 1

Index Scan using users_status_assign_user_id_idx on users_status_assign s (cost=0.27..36.87 rows=431 width=4) (actual time=0.009..0.384 rows=431 loops=1)

  • Filter: ((id IS NOT NULL) AND (status_id = ANY ('{1,2,5,6}'::integer[])))
6. 1.724 1.724 ↑ 1.0 1 431

Index Scan using users_pkey on users u (cost=0.42..7.04 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=431)

  • Index Cond: (id = s.user_id)
  • Filter: (active AND allow_invites AND (id <> 19834))
  • Rows Removed by Filter: 0
7. 1.182 1.182 ↓ 0.0 0 394

Index Only Scan using users_disciplines_unique_idx on users_disciplines d (cost=0.42..0.57 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=394)

  • Index Cond: ((user_id = u.id) AND (discipline_id = 104))
  • Heap Fetches: 67
8. 39.530 39.530 ↓ 34.5 138 67

Index Scan using orders_executor_id_idx on orders o (cost=0.43..7.84 rows=4 width=4) (actual time=0.066..0.590 rows=138 loops=67)

  • Index Cond: (executor_id = u.id)
  • Filter: ((discipline_id = 104) AND (status = 4))
  • Rows Removed by Filter: 476