leborchuk commented on PR #1942:
URL: https://github.com/apache/cloudberry/pull/1942#issuecomment-5498417963
Pushed down filters to seq scan. Now execution plan looks like:
```
Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..1689.57 rows=199266
width=386) (actual time=79.213..317.383 rows=100000 loops=1)
-> Hash Right Join (cost=0.00..1402.93 rows=66422 width=386) (actual
time=79.679..251.165 rows=33850 loops=1)
Hash Cond: (a.id = aef.id)
Extra Text: (seg1) Hash chain length 10.1 avg, 20 max, using 3365
of 262144 buckets.
-> Custom Scan (Anser Bloom Consumer) (cost=0.00..499.02
rows=333334 width=353) (actual time=18.552..173.863 rows=3385 loops=1)
Bloom Filter Size: 1048576 bytes
Bloom Filter Stats: memory=1024kB checked=0 rejected=0
Rows Removed by Bloom Filter: 0
-> Seq Scan on applications a (cost=0.00..499.02
rows=333334 width=353) (actual time=1.079..154.374 rows=3385 loops=1)
Rows Removed by Pushdown Runtime Filter: 329406
-> Hash (cost=437.42..437.42 rows=33334 width=33) (actual
time=60.732..60.734 rows=33850 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 4233kB
-> Redistribute Motion 3:3 (slice2; segments: 3)
(cost=0.00..437.42 rows=33334 width=33) (actual time=1.260..57.224 rows=33850
loops=1)
Hash Key: aef.id
-> Custom Scan (Anser Bloom Producer)
(cost=0.00..431.94 rows=33334 width=33) (actual time=0.440..44.779 rows=50000
loops=1)
Bloom Filter Size: 1048576 bytes
Bloom Filter Stats: memory=1024kB
-> Seq Scan on applications_extra_fields aef
(cost=0.00..431.94 rows=33334 width=33) (actual time=0.437..6.862 rows=50000
loops
=1)
Planning Time: 7.103 ms
(slice0) Executor memory: 1143K bytes.
(slice1) Executor memory: 8604K bytes avg x 3x(0) workers, 8636K bytes
max (seg0). Work_mem: 4233K bytes max.
(slice2) Executor memory: 2370K bytes avg x 3x(0) workers, 2370K bytes
max (seg2).
Memory used: 128000kB
Optimizer: GPORCA
Execution Time: 327.988 ms
```
I know right now it's better not use Anser, but it's the subject for future
improvements.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
