explain analyze
select
    count(*)
from
    "assets"
left join "exif" on
    "exif"."assetId" = "assets"."id"
where
    "assets"."resizePath" is not null
    and "assets"."isVisible"
    and "exif"."latitude" is not null
    and "exif"."longitude" is not null;

explain analyze
select
    count(*)
from
    "assets"
left join "exif" on
    "exif"."assetId" = "assets"."id"
where
    "assets"."resizePath" is not null
    and "assets"."isVisible"
    and "exif"."latitude" is not null
    and "exif"."longitude" is not null;

server {
    listen 443 ssl;
    listen [::]:443 ssl;

    server_name image.*;

    include /config/nginx/ssl.conf;

    location / {
        proxy_pass http://immich:8080;
    }
}

server {
    listen 443 ssl;
    listen [::]:443 ssl;

    server_name image.*;

    include /config/nginx/ssl.conf;

    location / {
        proxy_pass http://immich:8080;
    }
}