SACGF / SACGF/variantgrid

Admin only - Server stats - duplicate SQL queries

Open
#1,348 0 comments 0 reactions 0 assignees View on GitHub
good first issue
Dominant language
Python
Stars
30
Forks
3
Avg merge
9h 28m
Merged PRs (30d)
42

Description

Found while testing #1341 - but it needs a bit of thought

When you run a large query (eg export an analysis node as CSV) Postgres parallelises things, so you end up seeing the same query 4 times

I think we should instead perhaps group by distinct SQL query, and then make the pid an aggregated query (joined by string) and then kill them as a group if you click them?

I think if you kill 1 of a parallelized query it will kill them all, so probably doesn't matter

You could also just show 1 PID, and maybe (x4 threads) or something

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.