explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gvnl

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

Nested Loop (cost=50,182.65..53,484.37 rows=140 width=1,655) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=50,182.23..53,270.27 rows=141 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=50,181.81..50,186.44 rows=463 width=8) (actual rows= loops=)

  • Group Key: accounts.user_id
4. 0.000 0.000 ↓ 0.0

Append (cost=0.85..50,180.66 rows=463 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..3,478.80 rows=462 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using index_dense_balance_transactions_on_dense_created_at on dense_balance_transactions (cost=0.43..28.67 rows=462 width=8) (actual rows= loops=)

  • Index Cond: ((dense_created_at >= '2019-06-06 13:47:06.497573'::timestamp without time zone) AND (dense_created_at < '2019-06-07 13:47:06.497687'::timestamp without time zone))
7. 0.000 0.000 ↓ 0.0

Index Scan using accounts_pkey on accounts (cost=0.42..7.47 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = dense_balance_transactions.account_id)
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=193.45..46,697.23 rows=1 width=8) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on comp_point_transactions (cost=193.03..46,688.79 rows=1 width=8) (actual rows= loops=)

  • Recheck Cond: ((created_at >= '2019-06-06 13:47:06.497573'::timestamp without time zone) AND (created_at < '2019-06-07 13:47:06.497687'::timestamp without time zone))
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_comp_point_transactions_on_created_at (cost=0.00..193.03 rows=12,413 width=0) (actual rows= loops=)

  • Index Cond: ((created_at >= '2019-06-06 13:47:06.497573'::timestamp without time zone) AND (created_at < '2019-06-07 13:47:06.497687'::timestamp without time zone))
11. 0.000 0.000 ↓ 0.0

Index Scan using comp_point_accounts_pkey on comp_point_accounts (cost=0.42..8.44 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = comp_point_transactions.comp_point_account_id)
12. 0.000 0.000 ↓ 0.0

Index Scan using index_ad_args_on_user_id on ad_args (cost=0.42..6.64 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (user_id = accounts.user_id)
  • Filter: (btag_net_refer IS NOT NULL)
13. 0.000 0.000 ↓ 0.0

Index Scan using users_pkey on users (cost=0.42..1.52 rows=1 width=1,655) (actual rows= loops=)

  • Index Cond: (id = ad_args.user_id)
  • Filter: (NOT disabled)