SACGF / SACGF/variantgrid

Server stats - idle SQL queries

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

Description

I've had some users (who had admin) report that there are queries running.

These are idle queries presumably due to connection pooling

Have idle eg:

```
pid Duration Query State
57395 10m SELECT "django_migrations"."id", "django_migrations"."app", "django_migrations"."name", "django_migrations"."applied" FROM "django_migrations" idle
58601 9m 36s UPDATE "upload_uploadstep" SET "celery_task" = '95e08b35-7d21-447d-a48a-659c1c4fbf06' WHERE "upload_uploadstep"."id" = 2992 idle
```

**FIXES**

* Dumbest way would be just filter for "idle"
* Perhaps if we use new [Django 5.1 has connection pooling, mentioned in recommended Django fixes](https://github.com/SACGF/variantgrid_private/issues/3756) it could fix it

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.