immich-app/immich
1
0
Fork 0
mirror of https://github.com/immich-app/immich.git synced 2026-02-05 00:30:57 +03:00
Code Issues 12 Packages Projects Releases 10 Wiki Activity

The immich_postgres container consumes all server resources #47

New Issue
Closed
opened 2026-02-04 16:58:22 +03:00 by OVERLORD · 10 comments
OVERLORD commented 2026-02-04 16:58:22 +03:00
Owner
Copy Link

Originally created by @HowWof on GitHub (Apr 1, 2022).

I don't know if it's a bug or a configuration problem but immich_postgres is consuming all server resources below the logs
Logs

Originally created by @HowWof on GitHub (Apr 1, 2022). I don't know if it's a bug or a configuration problem but immich_postgres is consuming all server resources below the logs [Logs](https://cloud.howwof.pl/f/7a0fc9a9767247feac52/)
OVERLORD commented 2026-02-04 16:58:35 +03:00
Author
Owner
Copy Link

@alextran1502 commented on GitHub (Apr 1, 2022):

Can you monitor with docker stats to see how much CPU/RAM immich_postgres is pulling?

If I remember correctly, you are running on Ubuntu Server 20.04, correct?

@alextran1502 commented on GitHub (Apr 1, 2022): Can you monitor with `docker stats` to see how much CPU/RAM `immich_postgres` is pulling? If I remember correctly, you are running on Ubuntu Server 20.04, correct?
OVERLORD commented 2026-02-04 16:58:41 +03:00
Author
Owner
Copy Link

@HowWof commented on GitHub (Apr 1, 2022):

67% to 93% of the processor.
RAM Consumption 2.7 GB swap 500 MB
You remember the system correctly

@HowWof commented on GitHub (Apr 1, 2022): 67% to 93% of the processor. RAM Consumption 2.7 GB swap 500 MB You remember the system correctly
OVERLORD commented 2026-02-04 16:58:48 +03:00
Author
Owner
Copy Link

@alextran1502 commented on GitHub (Apr 1, 2022):

Is this behavior happening during idle or during the backup process?

@alextran1502 commented on GitHub (Apr 1, 2022): Is this behavior happening during idle or during the backup process?
OVERLORD commented 2026-02-04 16:59:02 +03:00
Author
Owner
Copy Link

@HowWof commented on GitHub (Apr 1, 2022):

During idle time

@HowWof commented on GitHub (Apr 1, 2022): During idle time
OVERLORD commented 2026-02-04 16:59:09 +03:00
Author
Owner
Copy Link

@alextran1502 commented on GitHub (Apr 1, 2022):

Interesting, I am seeing mine at 0% during idle. Let me investigate this.

What is your docker and docker-compose version?

@alextran1502 commented on GitHub (Apr 1, 2022): Interesting, I am seeing mine at 0% during idle. Let me investigate this. What is your docker and docker-compose version?
OVERLORD commented 2026-02-04 16:59:16 +03:00
Author
Owner
Copy Link

@HowWof commented on GitHub (Apr 2, 2022):

Docker version 20.10.14, build a224086
docker-compose version 1.29.2, build 5becea4c
OS: Ubuntu 20.04.4 LTS x86_64

@HowWof commented on GitHub (Apr 2, 2022): Docker version 20.10.14, build a224086 docker-compose version 1.29.2, build 5becea4c OS: Ubuntu 20.04.4 LTS x86_64
OVERLORD commented 2026-02-04 16:59:21 +03:00
Author
Owner
Copy Link

@Eidenz commented on GitHub (Apr 15, 2022):

The exact same issue happened to me today. 99% CPU on idle from postgres.

Docker version 20.10.14
Docker-compose version 1.29.2, build 5becea4c
OS: Ubuntu 20.04.4 LTS x64

@Eidenz commented on GitHub (Apr 15, 2022): The exact same issue happened to me today. 99% CPU on idle from postgres. Docker version 20.10.14 Docker-compose version 1.29.2, build 5becea4c OS: Ubuntu 20.04.4 LTS x64
OVERLORD commented 2026-02-04 16:59:24 +03:00
Author
Owner
Copy Link

@alextran1502 commented on GitHub (Apr 15, 2022):

@Eidenz Can you access to the database container with

docker exec -it immich_postgres psql -U postgres

then

select * from pg_stat_activity WHERE state='active';

And let me know the output?

@alextran1502 commented on GitHub (Apr 15, 2022): @Eidenz Can you access to the database container with ``` docker exec -it immich_postgres psql -U postgres ``` then ``` select * from pg_stat_activity WHERE state='active'; ``` And let me know the output?
OVERLORD commented 2026-02-04 16:59:27 +03:00
Author
Owner
Copy Link

@HowWof commented on GitHub (Apr 17, 2022):

docker exec -it immich_postgres psql -U postgres
give:
psql (14.2 (Debian 14.2-1.pgdg110+1))
Type "help" for help.
select * from pg_stat_activity WHERE state='active';
give:
LINE 1: docker exec -it immich_postgres psql -U postgres
^

@HowWof commented on GitHub (Apr 17, 2022): docker exec -it immich_postgres psql -U postgres give: psql (14.2 (Debian 14.2-1.pgdg110+1)) Type "help" for help. select * from pg_stat_activity WHERE state='active'; give: LINE 1: docker exec -it immich_postgres psql -U postgres ^
OVERLORD commented 2026-02-04 16:59:34 +03:00
Author
Owner
Copy Link

@alextran1502 commented on GitHub (Jun 12, 2022):

Is this issue still relevant?

@alextran1502 commented on GitHub (Jun 12, 2022): Is this issue still relevant?
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
accessibility
changelog:enhancement
changelog:security
changelog:translation
cli
date-time
documentation
external-library
format
good first issue
needs-answer
nice to have
sharing
tech-debt
📱mobile
🖥️web
🗄️server
🧠machine-learning
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: immich-app/immich#47
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?