explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pnFS

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

Hash Join (cost=5,563,761.82..5,563,846.74 rows=1 width=1,519) (actual rows= loops=)

  • Hash Cond: (accounts.user_id = ad_args.user_id)
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=5,563,756.82..5,563,792.57 rows=3,575 width=8) (actual rows= loops=)

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

Gather (cost=1,000.43..5,563,747.89 rows=3,575 width=8) (actual rows= loops=)

  • Workers Planned: 6
4. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.43..5,562,390.39 rows=1,431 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=51.80..7,678.74 rows=1,489 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on dense_balance_transactions (cost=51.37..3,961.63 rows=1,489 width=8) (actual rows= loops=)

  • Recheck 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

Bitmap Index Scan on index_dense_balance_transactions_on_dense_created_at (cost=0.00..50.48 rows=3,574 width=0) (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))
8. 0.000 0.000 ↓ 0.0

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

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

Nested Loop (cost=0.43..5,554,668.74 rows=1 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on comp_point_transactions (cost=0.00..5,554,666.09 rows=1 width=8) (actual rows= loops=)

  • Filter: ((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.43..2.65 rows=1 width=16) (actual rows= loops=)

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

Hash (cost=4.99..4.99 rows=1 width=1,527) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.55..4.99 rows=1 width=1,527) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using index_ad_args_on_btag_net_refer on ad_args (cost=0.12..2.34 rows=1 width=8) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Scan using users_pkey on users (cost=0.43..2.65 rows=1 width=1,519) (actual rows= loops=)

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