Created
November 9, 2022 14:05
-
-
Save ycku/254d4c046c2ffa3a380ccc6fcba58a27 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=4404.56..4404.57 rows=1 width=8) (actual time=65.949..65.950 rows=1 loops=1) | |
| -> Seq Scan on s (cost=2137.12..4274.25 rows=52125 width=0) (actual time=39.009..64.162 rows=37156 loops=1) | |
| Filter: (NOT (hashed SubPlan 1)) | |
| Rows Removed by Filter: 62844 | |
| SubPlan 1 | |
| -> Seq Scan on t (cost=0.00..1876.50 rows=104250 width=4) (actual time=0.029..13.914 rows=100000 loops=1) | |
| Planning Time: 5.089 ms | |
| Execution Time: 66.337 ms | |
| (8 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