SKIP LOCKED
When the SKIP LOCKED
clause is specified, records locked by a different transaction are skipped by the statement and are not deleted.
When a ROWS
clause is specified, the “skip locked” check is performed after skipping the requested number of rows specified, and before counting the number of rows to delete.