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
count
330264
QUERY PLAN
Finalize Aggregate (cost=12716.88..12716.89 rows=1 width=8) (actual rows=1 loops=1)
  -> Gather (cost=12716.67..12716.88 rows=2 width=8) (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (cost=11716.67..11716.68 rows=1 width=8) (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (cost=0.00..8591.67 rows=416667 width=4) (actual rows=333333 loops=3)
Planning time: 0.144 ms
Execution time: 162.670 ms
QUERY PLAN
Finalize Aggregate (cost=12716.88..12716.89 rows=1 width=8) (actual rows=1 loops=1)
  -> Gather (cost=12716.67..12716.88 rows=2 width=8) (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (cost=11716.67..11716.68 rows=1 width=8) (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (cost=0.00..8591.67 rows=416667 width=4) (actual rows=333333 loops=3)
Planning time: 0.089 ms
Execution time: 171.083 ms
QUERY PLAN
Finalize Aggregate (cost=11675.22..11675.23 rows=1 width=8) (actual rows=1 loops=1)
  -> Gather (cost=11675.00..11675.21 rows=2 width=8) (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (cost=10675.00..10675.01 rows=1 width=8) (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (cost=0.00..8591.67 rows=416667 width=4) (actual rows=333333 loops=3)
Planning time: 0.094 ms
Execution time: 168.808 ms
QUERY PLAN
Finalize Aggregate (cost=11675.22..11675.23 rows=1 width=8) (actual rows=1 loops=1)
  -> Gather (cost=11675.00..11675.21 rows=2 width=8) (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (cost=10675.00..10675.01 rows=1 width=8) (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (cost=0.00..8591.67 rows=416667 width=4) (actual rows=333333 loops=3)
Planning time: 0.063 ms
Execution time: 162.169 ms
QUERY PLAN
Finalize Aggregate (cost=11675.22..11675.23 rows=1 width=8) (actual rows=1 loops=1)
  -> Gather (cost=11675.00..11675.21 rows=2 width=8) (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (cost=10675.00..10675.01 rows=1 width=8) (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (cost=0.00..8591.67 rows=416667 width=4) (actual rows=333333 loops=3)
Planning time: 0.063 ms
Execution time: 157.936 ms
QUERY PLAN
Finalize Aggregate (cost=11675.22..11675.23 rows=1 width=8) (actual rows=1 loops=1)
  -> Gather (cost=11675.00..11675.21 rows=2 width=8) (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (cost=10675.00..10675.01 rows=1 width=8) (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (cost=0.00..8591.67 rows=416667 width=4) (actual rows=333333 loops=3)
Planning time: 0.060 ms
Execution time: 157.274 ms
QUERY PLAN
Finalize Aggregate (cost=10977.30..10977.31 rows=1 width=8) (actual rows=1 loops=1)
  -> Gather (cost=10977.08..10977.29 rows=2 width=8) (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (cost=9977.08..9977.09 rows=1 width=8) (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (cost=0.00..9633.33 rows=137500 width=0) (actual rows=110088 loops=3)
                    Filter: (amount > 100)
                    Rows Removed by Filter: 223245
Planning time: 0.091 ms
Execution time: 128.738 ms
QUERY PLAN
Finalize Aggregate (cost=8430.39..8430.40 rows=1 width=8) (actual rows=1 loops=1)
  -> Gather (cost=8430.07..8430.38 rows=3 width=8) (actual rows=4 loops=1)
        Workers Planned: 3
        Workers Launched: 3
        -> Partial Aggregate (cost=7430.07..7430.08 rows=1 width=8) (actual rows=1 loops=4)
              -> Parallel Index Only Scan using tbl_amount_idx on tbl (cost=0.42..7163.94 rows=106452 width=0) (actual rows=82566 loops=4)
                    Index Cond: (amount > 100)
                    Heap Fetches: 0
Planning time: 0.774 ms
Execution time: 82.306 ms
QUERY PLAN
Finalize Aggregate (cost=8430.39..8430.40 rows=1 width=8) (actual rows=1 loops=1)
  -> Gather (cost=8430.07..8430.38 rows=3 width=8) (actual rows=4 loops=1)
        Workers Planned: 3
        Workers Launched: 3
        -> Partial Aggregate (cost=7430.07..7430.08 rows=1 width=8) (actual rows=1 loops=4)
              -> Parallel Index Only Scan using tbl_amount_idx on tbl (cost=0.42..7163.94 rows=106452 width=0) (actual rows=82566 loops=4)
                    Index Cond: (amount > 100)
                    Heap Fetches: 0
Planning time: 0.155 ms
Execution time: 62.405 ms