Untitled*
You must execute the code again to save those values in the database.
Share
QUERY PLAN
Seq Scan on example (cost=0.00..25.00 rows=400 width=36) (actual time=0.006..0.007 rows=3 loops=1)
Filter: (number > 5)
Planning Time: 0.055 ms
Execution Time: 0.022 ms

QUERY PLAN
Hash Join (cost=30.00..55.16 rows=400 width=36) (actual time=0.024..0.026 rows=3 loops=1)
Hash Cond: (example_1.id = example.id)
-> Seq Scan on example example_1 (cost=0.00..22.00 rows=1200 width=36) (actual time=0.003..0.003 rows=3 loops=1)
-> Hash (cost=25.00..25.00 rows=400 width=4) (actual time=0.008..0.008 rows=3 loops=1)
Buckets: 1024 Batches: 1 Memory Usage: 9kB
-> Seq Scan on example (cost=0.00..25.00 rows=400 width=4) (actual time=0.002..0.003 rows=3 loops=1)
Filter: (number > 5)
Planning Time: 0.328 ms
Execution Time: 0.051 ms

CREATE TABLE
CREATE VIEW
INSERT 0 3