CREATE INDEX "last_modified_user_notnull_idx" ON "my_table" ("last_modified_user_id") WHERE "last_modified_user_id" IS NOT NULL;
Bitmap Heap Scan on "my_table" (cost=382.01..98244.14 rows=33236 width=335) (actual time=16.535..125347.800 rows=12327 loops=1)
Recheck Cond: (last_modified_user_id = 1)
Heap Blocks: exact=10206
-> Bitmap Index Scan on distinct_last_modified_user_id_ce6ebb4d (cost=0.00..373.70 rows=33236 width=0) (actual time=10.260..10.260 rows=122079 loops=1)
Index Cond: (last_modified_user_id = 1)
Planning Time: 0.096 ms
Execution Time: 125350.313 ms
(7 rows)
location /api {
proxy_pass http://your_backend/
}
location api/ {
proxy_pass http://your_backend
}