We sell different types of products and services to both investment professionals and individual investors. These products and services are usually sold through license agreements or subscriptions ...

If you are trying to investigate locking delays you might want to set a shorter than normal deadlock_timeout. max_locks_per_transaction (integer) # The shared lock table has space for ...

This is OK because the subquery is an independent computation that computes its own aggregate separately from what is happening in the outer query.