ci: add CodSpeed workflow and pytest-codspeed for performance testing #8016

Job	Run time
Should Run CI	1s
Filter Paths	8s
Test Docs Build	0s
Run Backend Tests / Test CLI - Python 3.10	12s
Lint Backend / Run Mypy (3.12)	55s
Run Backend Tests / Integration Tests - Python 3.10	1m 34s
Run Backend Tests / Unit Tests - Python 3.10 - Group 1	2m 10s
Lint Backend / Run Mypy (3.11)	1m 6s
Run Backend Tests / Unit Tests - Python 3.10 - Group 2	2m 26s
Lint Backend / Run Mypy (3.10)	1m 0s
Run Backend Tests / Unit Tests - Python 3.10 - Group 3	2m 18s
Run Frontend Tests / Playwright Tests - Group 1	5m 44s
Run Backend Tests / Unit Tests - Python 3.10 - Group 4	2m 23s
Run Frontend Tests / Playwright Tests - Group 2	5m 58s
Run Backend Tests / Unit Tests - Python 3.10 - Group 5	2m 8s
Run Frontend Tests / Playwright Tests - Group 3	6m 1s
Run Frontend Tests / Playwright Tests - Group 4	5m 21s
Run Frontend Tests / Playwright Tests - Group 5	4m 58s
Run Frontend Tests / Playwright Tests - Group 6	8m 4s
Run Frontend Tests / Playwright Tests - Group 7	6m 15s
Run Frontend Tests / Playwright Tests - Group 8	6m 16s
Run Frontend Tests / Playwright Tests - Group 9	5m 8s
Run Frontend Tests / Playwright Tests - Group 10	4m 55s
Run Frontend Tests / merge-reports	3s
CI Success	1s
	1h 15m 5s

Provide feedback