- commit
- e09f97f
- parent
- b7cd6ab
- author
- Eric Bower
- date
- 2025-04-18 09:35:45 -0400 EDT
chore(analytics): add indexes for project_id and post_id This is a performance improvement that makes deleting projects go from 20s to 1s.
2 files changed,
+4,
-1
M
Makefile
+2,
-1
1@@ -129,10 +129,11 @@ migrate:
2 $(DOCKER_CMD) exec -i $(DB_CONTAINER) psql -U $(PGUSER) -d $(PGDATABASE) < ./sql/migrations/20250319_add_tuns_event_logs_table.sql
3 $(DOCKER_CMD) exec -i $(DB_CONTAINER) psql -U $(PGUSER) -d $(PGDATABASE) < ./sql/migrations/20250320_add_tunnel_id_to_tuns_event_logs_table.sql
4 $(DOCKER_CMD) exec -i $(DB_CONTAINER) psql -U $(PGUSER) -d $(PGDATABASE) < ./sql/migrations/20250410_add_index_analytics_visits_host_list.sql
5+ $(DOCKER_CMD) exec -i $(DB_CONTAINER) psql -U $(PGUSER) -d $(PGDATABASE) < ./sql/migrations/20250418_add_project_post_idx_analytics.sql
6 .PHONY: migrate
7
8 latest:
9- $(DOCKER_CMD) exec -i $(DB_CONTAINER) psql -U $(PGUSER) -d $(PGDATABASE) < ./sql/migrations/20250410_add_index_analytics_visits_host_list.sql
10+ $(DOCKER_CMD) exec -i $(DB_CONTAINER) psql -U $(PGUSER) -d $(PGDATABASE) < ./sql/migrations/20250418_add_project_post_idx_analytics.sql
11 .PHONY: latest
12
13 psql:
1@@ -0,0 +1,2 @@
2+CREATE INDEX analytics_visits_project_idx ON analytics_visits (project_id);
3+CREATE INDEX analytics_visits_post_idx ON analytics_visits (post_id);