# Result: Y5B

Settings
# exclusive inclusive rows x rows loops node
1. 0.489 408.799 ↓ 15.9 44,260 1

(cost=1,000.85..10,379.05 rows=2,776 width=568) (actual time=3.228..408.799 rows=44,260 loops=1)

2. 0.045 0.045 ↑ 1.0 1 1

Seq Scan on part1a p1a (cost=0.00..3.13 rows=1 width=100) (actual time=0.040..0.045 rows=1 loops=1)

• Filter: (cat_id = 11432)
• Rows Removed by Filter: 89
3. 46.894 408.265 ↓ 15.9 44,260 1

Gather (cost=1,000.85..10,348.16 rows=2,776 width=348) (actual time=3.183..408.265 rows=44,260 loops=1)

• Workers Planned: 1
• Workers Launched: 1
4. 26.884 361.371 ↓ 13.6 22,130 2 / 2

(cost=0.85..9,070.56 rows=1,633 width=348) (actual time=1.214..361.371 rows=22,130 loops=2)

5. 14.673 46.797 ↓ 13.6 22,130 2 / 2

(cost=0.43..7,773.79 rows=1,633 width=341) (actual time=1.171..46.797 rows=22,130 loops=2)

6. 9.804 9.804 ↑ 1.2 496 2 / 2

Parallel Seq Scan on part1b p1b (cost=0.00..2,942.37 rows=584 width=219) (actual time=1.129..9.804 rows=496 loops=2)

• Filter: (cat_id = 11432)
• Rows Removed by Filter: 28157
7. 22.320 22.320 ↓ 45.0 45 992 / 2

Index Scan using europe_part2_cat_id_f1_f2_idx on part2 p (cost=0.43..8.26 rows=1 width=142) (actual time=0.009..0.045 rows=45 loops=992)

• Index Cond: ((cat_id = 11432) AND (f1 = p1b.f1) AND (f2 = p1b.f2))
8. 287.690 287.690 ↑ 1.0 1 44,260 / 2

Index Scan using europe_finis_number_number_idx on finis_number s (cost=0.42..0.78 rows=1 width=20) (actual time=0.013..0.013 rows=1 loops=44,260)

• Index Cond: (number = p.number2)
Planning time Execution time : 7.151 ms : 429.101 ms