explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R9h1

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

Gather (cost=17,167,930.43..75,510,747.95 rows=277,489,137 width=269) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=17,166,930.43..47,760,834.25 rows=115,620,474 width=269) (actual rows= loops=)

  • Hash Cond: (t.account_id = a.id)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=16,952,472.63..41,798,074.44 rows=115,620,474 width=165) (actual rows= loops=)

  • Hash Cond: (s.transaction_id = t.id)
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=12,631,198.37..31,804,121.43 rows=115,620,474 width=132) (actual rows= loops=)

  • Hash Cond: (s.target_balance_id = bt.id)
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=12,263,764.68..26,797,013.91 rows=115,620,474 width=124) (actual rows= loops=)

  • Hash Cond: (s.source_balance_id = bs.id)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,896,330.99..22,015,726.35 rows=115,620,474 width=116) (actual rows= loops=)

  • Hash Cond: (le.step_id = s.id)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=436,904.95..5,993,490.55 rows=115,620,474 width=8) (actual rows= loops=)

  • Hash Cond: (le.ledger_id = l.id)
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on ledger_entry le (cost=0.00..4,081,372.74 rows=115,620,474 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=257,981.20..257,981.20 rows=10,905,820 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on ledger l (cost=0.00..257,981.20 rows=10,905,820 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=5,716,903.24..5,716,903.24 rows=190,920,224 width=116) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on step s (cost=0.00..5,716,903.24 rows=190,920,224 width=116) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=205,219.53..205,219.53 rows=9,331,853 width=16) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on balance bs (cost=0.00..205,219.53 rows=9,331,853 width=16) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=205,219.53..205,219.53 rows=9,331,853 width=16) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on balance bt (cost=0.00..205,219.53 rows=9,331,853 width=16) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash (cost=2,255,727.89..2,255,727.89 rows=97,023,789 width=41) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on transaction t (cost=0.00..2,255,727.89 rows=97,023,789 width=41) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash (cost=125,145.47..125,145.47 rows=5,137,947 width=16) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on account a (cost=0.00..125,145.47 rows=5,137,947 width=16) (actual rows= loops=)