Last active
November 9, 2022 15:53
-
-
Save ycku/b97dd4979de300bb62c81fc1f36a59b6 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 | |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| Finalize Aggregate (cost=247880438.47..247880438.48 rows=1 width=8) (actual time=1219349.866..1219350.085 rows=1 loops=1) | |
| -> Gather (cost=247880438.25..247880438.46 rows=2 width=8) (actual time=1219349.805..1219350.074 rows=3 loops=1) | |
| Workers Planned: 2 | |
| Workers Launched: 2 | |
| -> Partial Aggregate (cost=247879438.25..247879438.26 rows=1 width=8) (actual time=1218624.458..1218624.460 rows=1 loops=3) | |
| -> Parallel Index Only Scan using s_key_idx on s (cost=0.42..247879334.09 rows=41667 width=0) (actual time=326.082..1218608.814 rows=9061 loops=3) | |
| Filter: (NOT (SubPlan 1)) | |
| Rows Removed by Filter: 57606 | |
| Heap Fetches: 360 | |
| SubPlan 1 | |
| -> Materialize (cost=0.00..5449.00 rows=200000 width=4) (actual time=0.003..13.255 rows=86808 loops=200000) | |
| -> Seq Scan on t (cost=0.00..3667.00 rows=200000 width=4) (actual time=0.002..8.019 rows=86394 loops=106809) | |
| Planning Time: 0.133 ms | |
| JIT: | |
| Functions: 20 | |
| Options: Inlining true, Optimization true, Expressions true, Deforming true | |
| Timing: Generation 4.112 ms, Inlining 139.255 ms, Optimization 62.684 ms, Emission 39.348 ms, Total 245.398 ms | |
| Execution Time: 1219353.850 ms | |
| (18 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