You're viewing **Apigee Edge** documentation.  
[Go to the
**Apigee X** documentation](http://cloud.google.com/apigee/docs/api-platform/analytics/analytics-case-study). info

> [!NOTE]
> **Note:** This topic applies to Edge Private Cloud only.


These topics explain how to troubleshoot issues with Analytics such as data not showing up in
the Analytics dashboard, issues with custom reports, Postgres disk running out of space, and so on.

### Playbooks


This section provides information and guidance on some specific procedures that can be
followed for troubleshooting and resolving the common Analytics problems.

| Problem | Error message or description | Playbook |
| Analytics Reports timing out | `The report timed out: Try again with a smaller date range or a larger aggregation interval.` | [Analytics reports timing out](https://docs.apigee.com/api-platform/troubleshoot/analytics/analytics-reports-timing-out) or: [Report timed out](https://docs.apigee.com/api-platform/troubleshoot/analytics/report-timed-out) |
| Data not showing up in Analytics dashboards | `No traffic in the selected date range` | [Data not showing up on analytics dashboards](https://docs.apigee.com/api-platform/troubleshoot/analytics/data-not-showing-analytics-dashboards) |
| Custom variable not visible in Custom Reports | None | [Custom variable not visible to analytics custom reports](https://docs.apigee.com/api-platform/troubleshoot/analytics/custom-variable-not-visible-analytics-custom-reports) or [Custom Dimensions not appearing when multiple axgroups have been configured](https://docs.apigee.com/api-platform/troubleshoot/analytics/custom-dimensions-not-appearing) |
|---|---|---|

### Diagnostic information


If you need assistance from [Apigee Support](https://cloud.google.com/apigee/support)
on the Analytics problems, then gather the following diagnostic information and share it in
the support case:

| Diagnostic information | Where can I gather this information? | How do I gather this information? |
|---|---|---|
| Analytics Group and Status Output | Management Server | ``` curl -u sysadminEmail:password http://MGMT_SERVER_HOST:8080/v1/analytics/groups/ax ``` ``` curl -u sysadminEmail:sysadminPwd http://MGMT_SERVER_HOST:8080/v1/organizations/ORGNAME/environments/ENVNAME/provisioning/axstatus ``` |
| Qpidd queue stats | Qpid Server | ``` qpid-stat -q 2>&1 | tee /tmp/qpid_stat_q_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` <br /> |
| Qpidd and Qpid Server logs | Qpid Server | ``` tar cvzf /tmp/qpid_logs_$(hostname)_$(date +%Y.%m.%d_%H.%M.%S).tar.gz /opt/apigee/var/log/apigee-qpidd/apigee-qpidd* /opt/apigee/var/log/edge-qpid-server/logs/system.log ``` <br /> |
| Data in Postgres DB | Postgres Server | Login to Postgres SQL, get the latest timestamp and size of data: ``` psql -h /opt/apigee/var/run/apigee-postgresql -U apigee apigee ``` ``` SELECT min(client_received_start_timestamp), max(client_received_start_timestamp) FROM analytics."ORGNAME.ENVNAME.fact"; ``` ``` SELECT relname as "Table",pg_size_pretty(pg_total_relation_size(relid)) As "Size",  pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size" FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC; ``` ``` SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA_COLUMNS analytics."ORGNAME.ENVNAME.fact"; ``` > [!NOTE] > **Note:** Replace <var translate="no">ORGNAME</var> and <var translate="no">ENVNAME</var> with the actual `org` and `env` names before running the above SQL queries. |
| Postgresql and Postgres Server logs | Postgres Server | ``` tar cvzf /tmp/postgres_logs_$(hostname)_$(date +%Y.%m.%d_%H.%M.%S).tar.gz /opt/apigee/var/log/apigee-postgresql/apigee-postgresql* /opt/apigee/var/log/edge-postgres-server/logs/system* ``` <br /> |
| ZooKeeper Tree Output | ZooKeeper | ``` sudo /opt/apigee/apigee-zookeeper/contrib/zk-tree.sh > zktree-output.txt ``` <br /> |

> [!NOTE]
> **Note:** Attach all of the above files and command outputs to the support case.

### Postgres disk space issue


This section provides information and guidance on some specific procedures that can be
followed for troubleshooting and resolving Postgres running out of disk space.

#### Playbooks

| Problem | Error message or description | Playbook |
|---|---|---|
| Postgres server running out of disk space | None | [Postgres server running out of disk space](https://docs.apigee.com/api-platform/troubleshoot/analytics/postgres-server-running-out-disk-space) |

#### Diagnostic information


If you need assistance from [Apigee Edge Support](https://docs.apigee.com/api-platform/troubleshoot/support) on this issue, then gather the following diagnostic
information and share it in the support case:

| Diagnostic information | Where can I gather this information? | How do I gather this information? |
|---|---|---|
| Disk Space | Postgres server | ``` df -h 2>&1 | tee /tmp/postgres_df_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` ``` free -h 2>&1 | tee /tmp/postgres_mem_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` |
| Data in Postgres DB | Postgres server | Login to Postgres SQL, get the latest timestamp and size of data ``` psql -h /opt/apigee/var/run/apigee-postgresql -U apigee apigee ``` ``` SELECT min(client_received_start_timestamp), max(client_received_start_timestamp) FROM analytics."ORGNAME.ENVNAME.fact"; ``` ``` SELECT relname as "Table",pg_size_pretty(pg_total_relation_size(relid)) As "Size", pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size" FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC; ``` |

> [!NOTE]
> **Note:** Attach all of the above files and command outputs to the support case.