# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 1,352.809 | 377,543.106 | ↓ 0.0 | 0 | 1 |
→
Hash Join (cost=8,922,136.28..15,041,940.52 rows=759,891 width=143) (actual time=377,543.105..377,543.106 rows=0 loops=1)
|
2. | 0.008 | 0.046 | ↑ 2,282,640.3 | 3 | 1 |
→
Nested Loop (cost=1,066,687.06..6,453,541.76 rows=6,847,921 width=37) (actual time=0.026..0.046 rows=3 loops=1) |
3. | 0.015 | 0.015 | ↑ 1.0 | 1 | 1 |
→
Index Scan using ledger_account_unique_account_name on ledger_account (cost=0.27..8.33 rows=1 width=29) (actual time=0.011..0.015 rows=1 loops=1)
|
4. | 0.014 | 0.023 | ↑ 17,032,009.3 | 3 | 1 |
→
Bitmap Heap Scan on ledger_posting (cost=1,066,686.79..5,942,573.14 rows=51,096,028 width=16) (actual time=0.013..0.023 rows=3 loops=1)
|
5. | 0.009 | 0.009 | ↑ 17,032,009.3 | 3 | 1 |
→
Bitmap Index Scan on idx_ledger_posting_ledger_account_id (cost=0.00..1,053,912.78 rows=51,096,028 width=0) (actual time=0.009..0.009 rows=3 loops=1)
|
6. | 14,473.938 | 376,190.251 | ↑ 1.3 | 17,039,295 | 1 |
→
Hash (cost=7,164,363.76..7,164,363.76 rows=22,253,797 width=122) (actual time=376,190.250..376,190.251 rows=17,039,295 loops=1)
|
7. | 59,981.855 | 361,716.313 | ↑ 1.3 | 17,039,295 | 1 |
→
Hash Left Join (cost=16.78..7,164,363.76 rows=22,253,797 width=122) (actual time=0.342..361,716.313 rows=17,039,295 loops=1)
|
8. | 301,734.128 | 301,734.128 | ↓ 1.0 | 200,488,998 | 1 |
→
Seq Scan on ledger_entry (cost=0.00..6,638,601.00 rows=200,284,176 width=114) (actual time=0.005..301,734.128 rows=200,488,998 loops=1)
|
9. | 0.170 | 0.330 | ↓ 1.1 | 603 | 1 |
→
Hash (cost=9.68..9.68 rows=568 width=16) (actual time=0.330..0.330 rows=603 loops=1)
|
10. | 0.160 | 0.160 | ↓ 1.1 | 603 | 1 |
→
Seq Scan on posted_timestamp_override (cost=0.00..9.68 rows=568 width=16) (actual time=0.005..0.160 rows=603 loops=1) |