Result: Suum : Line 19-41 Original

Settings
# exclusive inclusive rows x rows loops node
1. 1.621 5,322.362 ↓ 4.1 842 1

(cost=1,697,501.46..1,752,276.66 rows=206 width=76) (actual time=5,318.055..5,322.362 rows=842 loops=1)

2. 0.588 5,318.215 ↑ 8.3 842 1

(cost=1,697,501.03..1,697,570.93 rows=6,990 width=88) (actual time=5,318.032..5,318.215 rows=842 loops=1)

• Group Key: hh.company_number, hh.cusip, hh."position
3. 0.067 5,317.627 ↑ 8.3 842 1

(cost=1,636.04..1,697,448.60 rows=6,990 width=88) (actual time=205.410..5,317.627 rows=842 loops=1)

4. 742.086 5,315.732 ↓ 9.0 9 1

(cost=1,636.04..1,669,112.57 rows=1 width=22) (actual time=205.410..5,315.732 rows=9 loops=1)

• Hash Cond: ((s.cusip)::bpchar = hh.cusip)
5. 1,414.234 4,573.056 ↓ 169.8 9,202,101 1

Gather (cost=1,000.00..1,661,568.32 rows=54,182 width=10) (actual time=0.496..4,573.056 rows=9,202,101 loops=1)

• Workers Planned: 2
• Workers Launched: 2
6. 3,158.822 3,158.822 ↓ 135.9 3,067,367 3

Parallel Seq Scan on own_secmas s (cost=0.00..1,655,150.12 rows=22,576 width=10) (actual time=0.475..3,158.822 rows=3,067,367 loops=3)

• Filter: (lower((fi_flag)::text) = 'true'::text)
• Rows Removed by Filter: 544746
7. 0.008 0.590 ↑ 11.1 9 1

(cost=634.79..634.79 rows=100 width=22) (actual time=0.590..0.590 rows=9 loops=1)

• Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.582 0.582 ↑ 11.1 9 1

Index Scan using "IX_own_schedule_d_hist_snapshot_ix_own_schedule_d_hist_snapshot" on own_schedule_d_hist_snapshot hh (cost=0.56..634.79 rows=100 width=22) (actual time=0.156..0.582 rows=9 loops=1)