QUERY PLAN --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Append (cost=8270.74..8419.86 rows=1973 width=198) (actual time=80.021..81.287 rows=34 loops=1) CTE qsum -> Sort (cost=8266.30..8270.74 rows=1773 width=180) (actual time=80.017..81.211 rows=22 loops=1) Sort Key: or_followup.of_season, orders.or_clis_sub_code Sort Method: quicksort Memory: 28kB -> Hash Left Join (cost=7862.04..8170.63 rows=1773 width=180) (actual time=78.013..81.200 rows=22 loops=1) Hash Cond: (or_followup.of_season = seasons.id_sea) -> Hash Left Join (cost=7860.28..8155.25 rows=1773 width=106) (actual time=77.988..81.147 rows=22 loops=1) Hash Cond: (orders.or_clis_sub_code = clients_sub.clis_sub_code) -> Finalize GroupAggregate (cost=7816.25..8088.82 rows=1773 width=94) (actual time=77.712..80.862 rows=22 loops=1) Group Key: or_followup.of_season, orders.or_clis_sub_code -> Gather Merge (cost=7816.25..8020.10 rows=1478 width=94) (actual time=77.615..80.809 rows=22 loops=1) Workers Planned: 2 Workers Launched: 2 -> Partial GroupAggregate (cost=6816.23..6849.48 rows=739 width=94) (actual time=14.315..14.985 rows=7 loops=3) Group Key: or_followup.of_season, orders.or_clis_sub_code -> Sort (cost=6816.23..6818.07 rows=739 width=20) (actual time=14.233..14.291 rows=1334 loops=3) Sort Key: or_followup.of_season, orders.or_clis_sub_code Sort Method: quicksort Memory: 409kB Worker 0: Sort Method: quicksort Memory: 25kB Worker 1: Sort Method: quicksort Memory: 25kB -> Parallel Hash Join (cost=4324.32..6781.02 rows=739 width=20) (actual time=8.666..14.013 rows=1334 loops=3) Hash Cond: (or_followup.of_id_or = orders.id_or) -> Parallel Append (cost=0.00..2411.26 rows=11295 width=16) (actual time=0.005..12.457 rows=27223 loops=1) -> Parallel Bitmap Heap Scan on or_followup_archiv or_followup_2 (cost=7.76..1867.46 rows=10858 width=16) (actual time=0.222..7.858 rows=18573 loops=1) Recheck Cond: ((of_season >= 22) AND (of_season <= 33)) Rows Removed by Index Recheck: 3234 Heap Blocks: lossy=632 -> Bitmap Index Scan on brin_or_followup_archiv_season (cost=0.00..3.14 rows=19460 width=0) (actual time=0.055..0.055 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.004..3.503 rows=8650 loops=1) Filter: ((of_season >= 22) AND (of_season <= 33)) -> Parallel Hash (cost=4299.48..4299.48 rows=1987 width=12) (actual time=8.612..8.614 rows=1434 loops=3) Buckets: 8192 Batches: 1 Memory Usage: 288kB -> Parallel Hash Join (cost=1896.43..4299.48 rows=1987 width=12) (actual time=6.271..24.967 rows=4301 loops=1) Hash Cond: (orders.or_id_pr = projects.id_pr) -> Parallel Append (cost=0.00..2280.84 rows=30382 width=16) (actual time=0.003..13.978 rows=72918 loops=1) -> Parallel Seq Scan on orders_archiv orders_2 (cost=0.00..1826.94 rows=37594 width=16) (actual time=0.002..9.989 rows=63910 loops=1) -> Parallel Seq Scan on orders orders_1 (cost=0.00..301.99 rows=5299 width=16) (actual time=0.003..1.404 rows=9008 loops=1) -> Parallel Hash (cost=1890.96..1890.96 rows=437 width=4) (actual time=6.247..6.248 rows=1047 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 80kB -> Parallel Append (cost=0.00..1890.96 rows=437 width=4) (actual time=0.007..6.088 rows=1047 loops=1) -> Parallel Seq Scan on projects_archiv projects_2 (cost=0.00..1725.90 rows=412 width=4) (actual time=3.954..5.498 rows=698 loops=1) Filter: (pr_cli_code = 558) Rows Removed by Filter: 78305 -> Parallel Seq Scan on projects projects_1 (cost=0.00..162.88 rows=205 width=4) (actual time=0.006..0.549 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.264..0.264 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.013..0.166 rows=890 loops=1) -> Hash (cost=1.34..1.34 rows=34 width=12) (actual time=0.016..0.016 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.008..0.011 rows=34 loops=1) -> Subquery Scan on "*SELECT* 1" (cost=0.00..62.05 rows=1773 width=284) (actual time=80.021..80.031 rows=22 loops=1) -> CTE Scan on qsum (cost=0.00..35.46 rows=1773 width=236) (actual time=80.020..80.025 rows=22 loops=1) -> Subquery Scan on "*SELECT* 2" (cost=74.70..77.20 rows=200 width=198) (actual time=0.059..0.061 rows=12 loops=1) -> Sort (cost=74.70..75.20 rows=200 width=200) (actual time=0.058..0.059 rows=12 loops=1) Sort Key: qsum_1.of_season Sort Method: quicksort Memory: 26kB -> HashAggregate (cost=62.05..67.06 rows=200 width=200) (actual time=0.033..0.050 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..35.46 rows=1773 width=120) (actual time=0.001..0.003 rows=22 loops=1) Planning Time: 1.476 ms Execution Time: 82.863 ms (66 Zeilen)