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
10091
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.074 ms
Execution time: 157.230 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.085 ms
Execution time: 159.982 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.062 ms
Execution time: 157.657 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: 154.079 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.084 ms
Execution time: 156.520 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.082 ms
Execution time: 141.427 ms
QUERY PLAN
Finalize Aggregate (cost=10643.97..10643.98 rows=1 width=8) (actual rows=1 loops=1)
  -> Gather (cost=10643.75..10643.96 rows=2 width=8) (actual rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        -> Partial Aggregate (cost=9643.75..9643.76 rows=1 width=8) (actual rows=1 loops=3)
              -> Parallel Seq Scan on tbl (cost=0.00..9633.33 rows=4167 width=0) (actual rows=3364 loops=3)
                    Filter: (amount > 148)
                    Rows Removed by Filter: 329970
Planning time: 0.072 ms
Execution time: 92.633 ms
QUERY PLAN
Aggregate (cost=312.43..312.44 rows=1 width=8) (actual rows=1 loops=1)
  -> Index Only Scan using tbl_amount_idx on tbl (cost=0.42..287.43 rows=10000 width=0) (actual rows=10091 loops=1)
        Index Cond: (amount > 148)
        Heap Fetches: 0
Planning time: 0.284 ms
Execution time: 1.455 ms
QUERY PLAN
Aggregate (cost=312.43..312.44 rows=1 width=8) (actual rows=1 loops=1)
  -> Index Only Scan using tbl_amount_idx on tbl (cost=0.42..287.43 rows=10000 width=0) (actual rows=10091 loops=1)
        Index Cond: (amount > 148)
        Heap Fetches: 0
Planning time: 0.187 ms
Execution time: 1.314 ms