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.
100000 rows affected
QUERY PLAN
Limit (cost=98.12..98.15 rows=10 width=20) (actual time=0.329..0.332 rows=10 loops=1)
  Buffers: shared hit=45 read=5
  -> Sort (cost=98.12..98.26 rows=53 width=20) (actual time=0.328..0.329 rows=10 loops=1)
        Sort Key: refreshed_utc
        Sort Method: top-N heapsort Memory: 25kB
        Buffers: shared hit=45 read=5
        -> Index Scan using tbl_foo_idx on tbl (cost=0.42..96.98 rows=53 width=20) (actual time=0.205..0.311 rows=48 loops=1)
              Index Cond: ((purged_utc IS NULL) AND (refreshed_utc < '2021-07-11 00:00:00'::timestamp without time zone))
              Buffers: shared hit=45 read=5
Planning:
  Buffers: shared hit=34 read=1
Planning Time: 0.393 ms
Execution Time: 0.409 ms