QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Append (cost=8284.93..8437.72 rows=2022 width=198) (actual time=31.506..32.637 rows=34 loops=1) CTE qsum -> Sort (cost=8280.38..8284.93 rows=1822 width=180) (actual time=31.502..32.577 rows=22 loops=1) Sort Key: or_followup.of_season, orders.or_clis_sub_code Sort Method: quicksort Memory: 28kB -> Hash Left Join (cost=7864.72..8181.70 rows=1822 width=180) (actual time=31.274..32.566 rows=22 loops=1) Hash Cond: (or_followup.of_season = seasons.id_sea) -> Hash Left Join (cost=7862.95..8165.94 rows=1822 width=106) (actual time=31.252..32.523 rows=22 loops=1) Hash Cond: (orders.or_clis_sub_code = clients_sub.clis_sub_code) -> Finalize GroupAggregate (cost=7818.93..8098.89 rows=1822 width=94) (actual time=30.987..32.251 rows=22 loops=1) Group Key: or_followup.of_season, orders.or_clis_sub_code -> Gather Merge (cost=7818.93..8028.30 rows=1518 width=94) (actual time=30.978..32.207 rows=30 loops=1) Workers Planned: 2 Workers Launched: 2 -> Partial GroupAggregate (cost=6818.91..6853.06 rows=759 width=94) (actual time=24.688..25.201 rows=10 loops=3) Group Key: or_followup.of_season, orders.or_clis_sub_code -> Sort (cost=6818.91..6820.80 rows=759 width=20) (actual time=24.601..24.652 rows=1334 loops=3) Sort Key: or_followup.of_season, orders.or_clis_sub_code Sort Method: quicksort Memory: 53kB Worker 0: Sort Method: quicksort Memory: 179kB Worker 1: Sort Method: quicksort Memory: 203kB -> Parallel Hash Join (cost=4325.21..6782.59 rows=759 width=20) (actual time=19.738..24.311 rows=1334 loops=3) Hash Cond: (or_followup.of_id_or = orders.id_or) -> Parallel Append (cost=0.00..2411.63 rows=11358 width=16) (actual time=0.111..3.899 rows=9074 loops=3) -> Parallel Bitmap Heap Scan on or_followup_archiv or_followup_2 (cost=7.80..1867.52 rows=10947 width=16) (actual time=0.108..2.485 rows=6191 loops=3) Recheck Cond: ((of_season >= 22) AND (of_season <= 33)) Rows Removed by Index Recheck: 1078 Heap Blocks: lossy=60 -> Bitmap Index Scan on brin_or_followup_archiv_season (cost=0.00..3.14 rows=19462 width=0) (actual time=0.153..0.153 rows=6400 loops=1) Index Cond: ((of_season >= 22) AND (of_season <= 33)) -> Parallel Seq Scan on or_followup or_followup_1 (cost=0.00..487.32 rows=5088 width=16) (actual time=0.017..3.097 rows=8650 loops=1) Filter: ((of_season >= 22) AND (of_season <= 33)) -> Parallel Hash (cost=4299.83..4299.83 rows=2030 width=12) (actual time=17.321..17.325rows=1434 loops=3) Buckets: 8192 Batches: 1 Memory Usage: 288kB -> Parallel Hash Join (cost=1896.60..4299.83 rows=2030 width=12) (actual time=10.133..16.658 rows=1434 loops=3) Hash Cond: (orders.or_id_pr = projects.id_pr) -> Parallel Append (cost=0.00..2280.84 rows=30382 width=16) (actual time=0.010..8.750 rows=24306 loops=3) -> Parallel Seq Scan on orders_archiv orders_2 (cost=0.00..1826.94 rows=37594 width=16) (actual time=0.008..4.511 rows=21303 loops=3) -> Parallel Seq Scan on orders orders_1 (cost=0.00..301.99 rows=5299 width=16) (actual time=0.007..1.519 rows=9008 loops=1) -> Parallel Hash (cost=1891.01..1891.01 rows=447 width=4) (actual time=2.818..2.820 rows=349 loops=3) Buckets: 2048 Batches: 1 Memory Usage: 112kB -> Parallel Append (cost=0.00..1891.01 rows=447 width=4) (actual time=0.211..3.386 rows=524 loops=2) -> Parallel Seq Scan on projects_archiv projects_2 (cost=0.00..1725.90 rows=426 width=4) (actual time=1.975..3.086 rows=349 loops=2) Filter: (pr_cli_code = 558) Rows Removed by Filter: 39152 -> Parallel Seq Scan on projects projects_1 (cost=0.00..162.88 rows=205 width=4) (actual time=0.005..0.545 rows=349 loops=1) Filter: (pr_cli_code = 558) Rows Removed by Filter: 6434 -> Hash (cost=32.90..32.90 rows=890 width=16) (actual time=0.257..0.258 rows=890 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 52kB -> Seq Scan on clients_sub (cost=0.00..32.90 rows=890 width=16) (actual time=0.008..0.162 rows=890 loops=1) -> Hash (cost=1.34..1.34 rows=34 width=12) (actual time=0.012..0.013 rows=34 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 10kB -> Seq Scan on seasons (cost=0.00..1.34 rows=34 width=12) (actual time=0.005..0.008 rows=34 loops=1) -> Subquery Scan on "*SELECT* 1" (cost=0.00..63.77 rows=1822 width=284) (actual time=31.505..31.514 rows=22 loops=1) -> CTE Scan on qsum (cost=0.00..36.44 rows=1822 width=236) (actual time=31.504..31.509 rows=22 loops=1) -> Subquery Scan on "*SELECT* 2" (cost=76.41..78.91 rows=200 width=198) (actual time=0.044..0.046 rows=12 loops=1) -> Sort (cost=76.41..76.91 rows=200 width=200) (actual time=0.043..0.044 rows=12 loops=1) Sort Key: qsum_1.of_season Sort Method: quicksort Memory: 26kB -> HashAggregate (cost=63.77..68.77 rows=200 width=200) (actual time=0.022..0.036 rows=12 loops=1) Group Key: qsum_1.of_season, qsum_1.sea_name Batches: 1 Memory Usage: 48kB -> CTE Scan on qsum qsum_1 (cost=0.00..36.44 rows=1822 width=120) (actual time=0.000..0.002 rows=22 loops=1) Planning Time: 0.820 ms Execution Time: 33.183 ms (66 rows)