Created
January 20, 2021 08:50
-
-
Save Arfey/8e779c829ed4b4c46c8b7b3d0a0aefb5 to your computer and use it in GitHub Desktop.
This file contains 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 | |
— Index Scan using foo_c1_idx on foo (cost=0.42..34623.01 rows=999519 width=37) (actual time=0.178..1018.045 rows=999500 loops=1) | |
Index Cond: (c1 > 500) | |
Total runtime: 1434.429 ms | |
(3 rows) | |
QUERY PLAN | |
— Seq Scan on foo (cost=0.00..20834.12 rows=999522 width=37) | |
Filter: (c1 > 500) | |
(2 rows) | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment