PostgreSQL database locks
A query that only reads data will not block normal user activity. Readers don't block writers and vice versa.
However, it may consume substantial resouces on the database server, which could impair performance for the users.