Prometheus

Queries for python shopify orders api

Awesome! Now that you’ve got Prometheus metrics from your Python Shopify Order API, here’s a comprehensive guide with Prometheus queries to monitor key SLI, SLO, and infrastructure metrics — ready to be used in Grafana dashboards, alerting, or dashboards.

---

✅ Available Metrics (from your metrics.py)

• shopify_orders_fetch_total{status="..."}

• shopify_orders_fetch_duration_seconds

• shopify_orders_returned_total

• shopify_orders_revenue_inr_total

• shopify_orders_last_success_timestamp

---

📊 1. Basic Metric Queries

🔹 Total Successful Order Fetches

increase(shopify_orders_fetch_total{status="success"}[1h])

🔹 Total Errors (last 1 hour)

increase(shopify_orders_fetch_total{status="error"}[1h])

🔹 Exceptions Count

increase(shopify_orders_fetch_total{status="exception"}[1h])

---

🔁 2. SLI Queries

🔹 Availability SLI (% of successful requests)

(
  sum(increase(shopify_orders_fetch_total{status="success"}[1h]))
  /
  sum(increase(shopify_orders_fetch_total[1h]))
) * 100

📈 Use this to set a 95%+ target SLO for availability

---

📏 3. SLO: Response Latency / Performance

🔹 95th Percentile Order Fetch Latency

histogram_quantile(0.95, rate(shopify_orders_fetch_duration_seconds_bucket[5m]))

You can track 95% of requests completed under x seconds.

---

🛒 4. Order-Based Business Metrics

🔹 Current Returned Orders Count

shopify_orders_returned_total

🔹 Approximate Revenue (total in INR)

shopify_orders_revenue_inr_total

---

⏰ 5. Last Order Sync Timestamp

To see when the last successful order fetch occurred:

time() - shopify_orders_last_success_timestamp

Alerts you if no successful fetch happened in the last 5–10 minutes.

---

📉 6. Alert Examples

🔸 No orders fetched in 10 minutes

(shopify_orders_last_success_timestamp < (time() - 600))

🔸 Error rate exceeds 5%

(
  rate(shopify_orders_fetch_total{status="error"}[5m])
  /
  rate(shopify_orders_fetch_total[status!~"exception"][5m])
) > 0.05

---

📈 7. Grafana Chart Ideas

Panel Title	Prometheus Query	Type
API Success Rate (%)	SLI Query Above	Gauge / Line
API Latency (95th %ile)	histogram_quantile(0.95, …)	Line
Orders Returned	shopify_orders_returned_total	Gauge
Revenue in INR	shopify_orders_revenue_inr_total	Stat
Order Fetch Statuses	increase(shopify_orders_fetch_total[1h])	Bar
Last Sync Delay	time() - shopify_orders_last_success_timestamp	Stat / Alert

---

📌 Want more?

Let me know if you want:

• 📄 JSON to import Grafana dashboard

• 📦 Combine with Loki logs or Uptime probes

• 📤 Export data to Google Sheets / BigQuery / CSV

You’re now observability-ready 🚀