add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1000000 rows affected
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.151 ms
Execution Time: 123.914 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.083 ms
Execution Time: 125.158 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.102 ms
Execution Time: 145.015 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.082 ms
Execution Time: 130.637 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.068 ms
Execution Time: 123.298 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.105 ms
Execution Time: 116.779 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=3298 loops=3)
                    Filter: (amount > 148)
                    Rows Removed by Filter: 330035
Planning Time: 0.176 ms
Execution Time: 94.109 ms
QUERY PLAN
Aggregate (actual rows=1 loops=1)
  -> Seq Scan on tbl (actual rows=1000000 loops=1)
Planning Time: 0.053 ms
Execution Time: 101.731 ms
QUERY PLAN
Aggregate (actual rows=1 loops=1)
  -> Seq Scan on tbl (actual rows=9895 loops=1)
        Filter: (amount > 148)
        Rows Removed by Filter: 990105
Planning Time: 0.087 ms
Execution Time: 78.811 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.066 ms
Execution Time: 118.727 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.065 ms
Execution Time: 125.569 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.068 ms
Execution Time: 127.247 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.066 ms
Execution Time: 124.717 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.068 ms
Execution Time: 124.939 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=333333 loops=3)
Planning Time: 0.065 ms
Execution Time: 121.624 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (actual rows=110364 loops=3)
                    Filter: (amount > 100)
                    Rows Removed by Filter: 222969
Planning Time: 0.080 ms
Execution Time: 107.858 ms
QUERY PLAN
Aggregate (actual rows=1 loops=1)
  -> Seq Scan on tbl (actual rows=1000000 loops=1)
Planning Time: 0.054 ms
Execution Time: 109.489 ms
QUERY PLAN
Aggregate (actual rows=1 loops=1)
  -> Seq Scan on tbl (actual rows=331092 loops=1)
        Filter: (amount > 100)
        Rows Removed by Filter: 668908
Planning Time: 0.067 ms
Execution Time: 94.977 ms
QUERY PLAN
Aggregate (actual rows=1 loops=1)
  -> Index Only Scan using tbl_amount_idx on tbl (actual rows=9895 loops=1)
        Index Cond: (amount > 148)
        Heap Fetches: 0
Planning Time: 0.281 ms
Execution Time: 0.876 ms
QUERY PLAN
Finalize Aggregate (actual rows=1 loops=1)
  -> Gather (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (actual rows=1 loops=3)
              -> Parallel Index Only Scan using tbl_amount_idx on tbl (actual rows=110364 loops=3)
                    Index Cond: (amount > 100)
                    Heap Fetches: 0
Planning Time: 0.052 ms
Execution Time: 40.505 ms
QUERY PLAN
Aggregate (actual rows=1 loops=1)
  -> Index Only Scan using tbl_amount_idx on tbl (actual rows=331092 loops=1)
        Index Cond: (amount > 100)
        Heap Fetches: 0
Planning Time: 0.086 ms
Execution Time: 26.008 ms