-
-
Save rightfold/5d7601d8545ff29885c5 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
=# CREATE OR REPLACE VIEW v AS | |
-# SELECT * | |
-# FROM t; | |
CREATE VIEW | |
=# EXPLAIN ANALYSE | |
-# SELECT c | |
-# FROM v | |
-# WHERE d = 'x'; | |
QUERY PLAN | |
--------------------------------------------------------------------------------------------- | |
Seq Scan on t (cost=0.00..5.00 rows=199 width=91) (actual time=0.008..0.025 rows=1 loops=1) | |
Filter: (d = 'x') | |
Rows Removed by Filter: 200 | |
Total runtime: 0.048 ms | |
(4 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment