explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fmg9

Settings
# exclusive inclusive rows x rows loops node
1. 2.121 1,578.639 ↓ 1,002.0 1,002 1

GroupAggregate (cost=9.40..9.42 rows=1 width=12) (actual time=1,574.946..1,578.639 rows=1,002 loops=1)

  • Group Key: users.id
2. 9.500 1,576.518 ↓ 21,689.0 21,689 1

Sort (cost=9.40..9.40 rows=1 width=4) (actual time=1,574.937..1,576.518 rows=21,689 loops=1)

  • Sort Key: users.id
  • Sort Method: quicksort Memory: 1785kB
3. 4.270 1,567.018 ↓ 21,689.0 21,689 1

Nested Loop (cost=0.87..9.39 rows=1 width=4) (actual time=0.049..1,567.018 rows=21,689 loops=1)

4. 36.318 36.318 ↓ 3,485.0 3,485 1

Index Scan using idx_users_06_08122018 on users (cost=0.44..6.72 rows=1 width=4) (actual time=0.029..36.318 rows=3,485 loops=1)

  • Index Cond: ((manager_id IS NOT NULL) AND (manager_id = 250))
  • Filter: (status_id <> 1)
5. 1,526.430 1,526.430 ↓ 6.0 6 3,485

Index Scan using idx_gamepay_orders_on_updated_at_202002_temp4 on gamepay_orders (cost=0.43..2.66 rows=1 width=4) (actual time=0.024..0.438 rows=6 loops=3,485)

  • Index Cond: ((user_id = users.id) AND ((updated_at)::date >= '2020-01-02'::date) AND ((updated_at)::date <= '2020-02-12'::date))
Planning time : 2.760 ms
Execution time : 1,578.721 ms