SELECT * FROM pg_stat_activity WHERE state = 'active';
So you can identify the PID of the hanging query you want to terminate, run this:
SELECT pg_cancel_backend(PID);
Criteria queries allow for multiple root level objects. Caution should be used when doing this, as it can result in Cartesian products of the two table. The where clause should ensure the two objects are joined in some way.
// Select the employees and the mailing addresses that have the same address.
CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
CriteriaQuery criteriaQuery = criteriaBuilder.createQuery();
Root employee = criteriaQuery.from(Employee.class);
Root address = criteriaQuery.from(MailingAddress.class);
criteriaQuery.multiselect(employee, address);
criteriaQuery.where(criteriaBuilder.equal(employee.get("address"), address.get("address"));
Query query = entityManager.createQuery(criteriaQuery);
List<Object[]> result = query.getResultList();
M. Thein, and M. Thwin. International Journal of Computer Science, Engineering and Information Technology (IJCSEIT), volume 2 of IFIP Advances in Information and Communication Technology, page 13-32. Springer, (December 2012)
E. Voorhees. Proceedings of the 17th annual international ACM SIGIR conference on Research and development in information retrieval, page 61--69. Springer-Verlag New York, Inc., (1994)
R. Navigli, and P. Velardi. Proceedings of the 14th European Conference on Machine Learning, Workshop on Adaptive Text Extraction and Mining, Cavtat-Dubrovnik, Croatia, page 42--49. (2003)
S. Liu, C. Yu, and W. Meng. Proceedings of the 14th ACM International Conference on Information and Knowledge Management, page 525--532. New York, NY, USA, ACM, (2005)
R. Jones, B. Rey, O. Madani, and W. Greiner. WWW '06: Proceedings of the 15th international conference on World Wide Web, page 387--396. New York, NY, USA, ACM, (2006)
J. Singh, W. Nejdl, and A. Anand. Proceedings of the 2016 ACM on Conference on Human Information Interaction and Retrieval, page 183--192. New York, NY, USA, ACM, (2016)