explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7lPq

Settings
# exclusive inclusive rows x rows loops node
1. 0.429 78,307.410 ↓ 450.0 450 1

GroupAggregate (cost=97.32..97.34 rows=1 width=12) (actual time=78,306.706..78,307.410 rows=450 loops=1)

  • Group Key: users.id
2. 2.754 78,306.981 ↓ 3,932.0 3,932 1

Sort (cost=97.32..97.32 rows=1 width=4) (actual time=78,306.693..78,306.981 rows=3,932 loops=1)

  • Sort Key: users.id
  • Sort Method: quicksort Memory: 281kB
3. 16.407 78,304.227 ↓ 3,932.0 3,932 1

Nested Loop (cost=0.88..97.31 rows=1 width=4) (actual time=0.267..78,304.227 rows=3,932 loops=1)

4. 51.116 51.116 ↓ 3,484.0 3,484 1

Index Scan using idx_users_06_08122018 on users (cost=0.44..6.52 rows=1 width=4) (actual time=0.139..51.116 rows=3,484 loops=1)

  • Index Cond: ((manager_id IS NOT NULL) AND (manager_id = 250))
  • Filter: (status_id <> 1)
5. 78,236.704 78,236.704 ↑ 1.0 1 3,484

Index Scan using index_gamepay_orders_on_user_id on gamepay_orders (cost=0.44..90.78 rows=1 width=4) (actual time=18.005..22.456 rows=1 loops=3,484)

  • Index Cond: (user_id = users.id)
  • Filter: (((status)::text = 'success'::text) AND ((updated_at)::date >= '2020-02-02'::date) AND ((updated_at)::date <= '2020-02-12'::date))
  • Rows Removed by Filter: 176
Planning time : 8.201 ms
Execution time : 78,307.495 ms