CHT app slowing down

[binod]

In that case, you can have a look at the telemetry and feedback data from these materialized views:

• useview_telemetry
• useview_telemetry_devices
• useview_telemetry_metrics
• useview_feedback

Here are some forum posts with SQL query examples that you might find helpful:

Some helpful SQL to look into number of days per month a HW opened the CHT

Telemetry data is recorded any time a user opens their app. We can understand how many days per month a user opens their app by looking at the number of unique days a telemetry record was recorded for them. I wanted to share some SQL that can be helpful for those that are interested in knowing how many days per month users are opening their app The SQL provided below will return a table like this (plus some other useful fields). user_name january february march user123 19 25 27 user…

User telemetry and Performance Data

…and if you do end up deciding to use couch2pg and want to explore using SQL, here’s a sample statement to get you started. couch2pg will put data from CouchDB’s medic-users-meta DB into a table called couchdb_users_meta in PostgreSQL. SELECT doc#>>'{metadata,user}' AS t_user, doc#>>'{metadata,versions,app}' AS t_app_version, doc#>>'{metadata,year}' AS t_year, lpad(doc#>>'{metadata,month}',2,'0') AS t_month, lpad(doc#>>'{metadata,day}',2,'0') AS t_day, jsonb_pretty(doc) AS obj_key …