By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT 50000
ALTER TABLE
ANALYZE
DROP TABLE
SELECT 20000
| QUERY PLAN |
|---|
| Seq Scan on public.t2 (cost=847.00..1219.69 rows=11348 width=4) (actual time=33.189..38.629 rows=19052 loops=1) |
| Output: t2.id |
| Filter: (NOT (hashed SubPlan 1)) |
| Rows Removed by Filter: 948 |
| SubPlan 1 |
| -> Seq Scan on public.t1 (cost=0.00..722.00 rows=50000 width=4) (actual time=0.013..6.657 rows=50000 loops=1) |
| Output: t1.id |
| Planning Time: 0.287 ms |
| Execution Time: 39.984 ms |
EXPLAIN