Skip to main content

Query Analytics

Identify slow queries, monitor active queries, and optimize database performance.

Analytics Summary​

Get an overview of query performance:

curl -X GET https://api.lordbase.com/e/v1/developer/databases/{database_id}/analytics/ \
  -H "Authorization: Bearer lb_pat_your_token"

Query Statistics​

View detailed statistics for all queries:

curl -X GET https://api.lordbase.com/e/v1/developer/databases/{database_id}/analytics/queries/ \
  -H "Authorization: Bearer lb_pat_your_token"

Statistics include:

  • Total calls per query
  • Average execution time
  • Total execution time
  • Rows returned per query

Slow Queries​

Identify queries that exceed performance thresholds:

curl -X GET https://api.lordbase.com/e/v1/developer/databases/{database_id}/analytics/slow/ \
  -H "Authorization: Bearer lb_pat_your_token"
tip

Review slow queries regularly. Common fixes include adding indexes, rewriting JOINs, and reducing result set sizes.

Active Queries​

Monitor currently running queries in real-time:

curl -X GET https://api.lordbase.com/e/v1/developer/databases/{database_id}/analytics/active/ \
  -H "Authorization: Bearer lb_pat_your_token"

Useful for:

  • Identifying long-running transactions
  • Detecting connection leaks
  • Debugging deadlocks

Resetting Query Statistics​

Clear accumulated query statistics:

curl -X POST https://api.lordbase.com/e/v1/developer/databases/{database_id}/analytics/reset/ \
  -H "Authorization: Bearer lb_pat_your_token"
warning

This resets all pg_stat_statements data. Use with caution in production.

Optimization Tips​

IssueSolution
Slow SELECT queriesAdd indexes on filtered/joined columns
High tuple writesBatch INSERT/UPDATE operations
Low cache hit ratioIncrease shared_buffers or optimize queries
Long-running queriesAdd query timeouts, review transaction isolation

Next Steps​