Monitoring template for FastAPI

Objectives

Tracking - Prometheus

• Database operations duration
• API requests duration
• API request/response size

Monitoring - Grafana

• API
• Database
• System
• Logs

Logging - Loki

Tools

• Jmeter for benchmark test
• Postman collection

Run it

• Ensure you have .env configured. See .env.example
• Run schema.sql on your Postgres database
• Run docker compose build && docker compose up -d

Flow

• Ensure Loki is working, http://localhost:3100/ready
• Ensure Prometheus is scrapping the server, http://localhost:9090/targets
• Manually setup pg_stat_statements. See notes/pg_stat_statements
• Import dashboard to grafana, http://localhost:3000/dashboard/import
• Benchmark server with Jmeter. See jmeter_benchmark/
• Monitor database schemas with pg_stat_statements. See notes/pg_stat_statements