By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 6
| a |
|---|
| 1 |
| 2 |
| 123 |
| 456 |
| 789 |
| 1024 |
SELECT 6
BEGIN
| QUERY PLAN |
|---|
| Delete on t (cost=0.00..48.25 rows=0 width=0) (actual time=0.022..0.023 rows=0 loops=1) |
| -> Seq Scan on t (cost=0.00..48.25 rows=13 width=6) (actual time=0.009..0.010 rows=3 loops=1) |
| Filter: ((a % 2) = 0) |
| Rows Removed by Filter: 3 |
| Planning Time: 0.233 ms |
| Execution Time: 0.123 ms |
EXPLAIN
| a |
|---|
| 1 |
| 123 |
| 789 |
SELECT 3
ROLLBACK
| a |
|---|
| 1 |
| 2 |
| 123 |
| 456 |
| 789 |
| 1024 |
SELECT 6