Find active queries with pg_stat_activity, then cancel them gracefully with pg_cancel_backend(pid) or terminate them forcefully with pg_terminate_backend(pid).