Analytics সংক্রান্ত সমস্যা

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

qpid-stat -q 2>&1 | tee /tmp/qpid_stat_q_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt

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

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";

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*

sudo /opt/apigee/apigee-zookeeper/contrib/zk-tree.sh > zktree-output.txt

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

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;