read committed

a consistency level that prohibits dirty writes, aborted reads, intermediate reads, and cyclic information flow

“Read committed is the default isolation level in PostgreSQL and many other SQL databases.”