Created
November 9, 2022 14:43
-
-
Save ycku/6a38107e2b2253945b1175b1ebf2957f to your computer and use it in GitHub Desktop.
你又不小心 IN 了嗎？
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| QUERY PLAN | |
| ----------------------------------------------------------------------------------------------------------------------------------------- | |
| Aggregate (cost=10438.81..10438.82 rows=1 width=8) (actual time=80.819..84.547 rows=1 loops=1) | |
| -> Gather (cost=5774.06..10438.80 rows=1 width=0) (actual time=52.857..83.197 rows=27183 loops=1) | |
| Workers Planned: 1 | |
| Workers Launched: 1 | |
| -> Parallel Hash Anti Join (cost=4774.06..9438.70 rows=1 width=0) (actual time=46.786..67.737 rows=13592 loops=2) | |
| Hash Cond: (s.key = t.key) | |
| -> Parallel Seq Scan on s (cost=0.00..2843.47 rows=117647 width=4) (actual time=0.004..8.666 rows=100000 loops=2) | |
| -> Parallel Hash (cost=2843.47..2843.47 rows=117647 width=4) (actual time=22.881..22.882 rows=100000 loops=2) | |
| Buckets: 131072 Batches: 4 Memory Usage: 3008kB | |
| -> Parallel Seq Scan on t (cost=0.00..2843.47 rows=117647 width=4) (actual time=0.008..8.464 rows=100000 loops=2) | |
| Planning Time: 0.193 ms | |
| Execution Time: 84.599 ms | |
| (12 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
https://medium.com/pgsql-tw/%E4%BD%A0%E5%8F%88%E4%B8%8D%E5%B0%8F%E5%BF%83-in-%E4%BA%86%E5%97%8E-eb6e0bb98393