explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rZdw : transactions

Settings

Optimization(s) for this plan:

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

Sort (cost=480,872.27..487,837.58 rows=2,786,124 width=17) (actual rows= loops=)

  • Sort Key: transactions.id
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=13,766.90..68,345.09 rows=2,786,124 width=17) (actual rows= loops=)

  • Hash Cond: (transactions.account_id = accounts_transactions.id)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,457.50..17,149.91 rows=464,354 width=20) (actual rows= loops=)

  • Hash Cond: (transactions.account_id = imported_accounts.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on transactions (cost=0.00..9,307.54 rows=464,354 width=20) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=956.75..956.75 rows=40,060 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on imported_accounts (cost=0.00..956.75 rows=40,060 width=4) (actual rows= loops=)

  • Filter: (budget_lea_id = 15)
7. 0.000 0.000 ↓ 0.0

Hash (cost=8,365.90..8,365.90 rows=240,360 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=1,357.35..8,365.90 rows=240,360 width=4) (actual rows= loops=)

  • Hash Cond: (imported_account_segments.account_id = accounts_transactions.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on imported_account_segments (cost=0.00..3,703.60 rows=240,360 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=856.60..856.60 rows=40,060 width=4) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on imported_accounts accounts_transactions (cost=0.00..856.60 rows=40,060 width=4) (actual rows= loops=)