1 -- Change to grouping by ECI+eUTRANTraceId
3 DEFINE{query_name 'throughput_meas_crnti';
4 max_lfta_disorder '1'; max_hfta_disorder '1';
5 comment 'throughput experienced by a UE';
8 select $window*(TB+1) as TS, eci, eutran_trace_id,
9 sum((8.0*sumOfSentNonGbrBytes+sumOfSentGbrBytes)) / sum(numOfTtiPositiveDlBuf/1000.0) as ue_lte_tput
10 from LTE_PCMD.lte_thpt_meas
11 group by timestamp_ms/$window as TB, eci, eutran_trace_id
15 DEFINE{query_name 'throughput_meas_alt_crnti';
16 max_lfta_disorder '1'; max_hfta_disorder '1';
17 comment 'throughput experienced by a UE (alternative version)';
20 select $window*(TB+1) as TS, eci, eutran_trace_id,
21 sum((8.0*sumOfSentNonGbrBytes+sumOfSentGbrBytes)) / sum(numOfTtiUeSched/1000.0) as ue_lte_tput
22 from LTE_PCMD.lte_thpt_meas
23 Where numOfTtiUeSched>0
24 group by timestamp_ms/$window as TB, eci, eutran_trace_id
28 DEFINE{query_name 'drb_pdcp_pdu_stats';
29 max_lfta_disorder '1'; max_hfta_disorder '1';
30 comment 'drb pdcp pdu stats';
33 select $window*(TB+1) as TS, eci, eutran_trace_id, drb_Id,
34 sum(numOfPdcpPduRcvdForTx) as ue_drb_pdcppdu_count,
35 sum(numOfPdcpPduRcvdForTx) / sum(dataCollectionDuration/1000.0) as ue_drb_pdcppdu_count_per_time,
36 100.0*sum(numOfPdcpPduDiscarded) / (sum(1.0*numOfPdcpPduRcvdForTx)) as ue_drb_pdcppdu_discard_rate
37 from LTE_PCMD.lte_rb_thpt
38 group by timestamp_ms/$window as TB, eci, eutran_trace_id, drb_Id
41 DEFINE{query_name 'ue_drb_count';
42 max_lfta_disorder '1'; max_hfta_disorder '1';
43 comment 'ue drb count';
46 select TS, eci, eutran_trace_id,
47 count(*) as ue_drb_count
48 from drb_pdcp_pdu_stats
49 group by TS, eci, eutran_trace_id
52 DEFINE{query_name 'dl_sched_trace_stats';
53 max_lfta_disorder '1'; max_hfta_disorder '1';
54 comment 'dl sched trace stats';
57 select $window*(TB+1) as TS, eci, eutran_trace_id,
58 sum(numOfTtiUeSched) as ue_num_schedTTIs,
59 sum(numOfTtiUeSched) / (sum(recordCollectionDuration)/1000.0) as ue_num_schedTTIs_per_time,
60 sum(numOfPrbUsed) / (sum(recordCollectionDuration)/1000.0) as ue_avg_PRB_alloc_rate,
61 sum(numOfPrbUsed) / (1.0*sum(numOfTtiUeSched)) as ue_avg_PRB_alloc_rate_per_TTI,
62 sum(numOfHarq1stTx) as ue_HARQ_pid_count,
63 sum(numOfHarq1stTx) / (sum(numOfTtiUeSched)/1000.0) as ue_HARQ_pid_count_per_time,
64 100.0*sum(numOfTtiUeSchedMimo) / (1.0*sum(numOfTtiUeSched)) as ue_schedTTIs_MIMO_percent,
65 100.0*sum(numOfTtiUeSched - numOfTtiUeSchedMimo) / (1.0*sum(numOfTtiUeSched)) as ue_schedTTIs_TxDiversity_percent,
66 100.0*sum(numOfHarqReTx) / (1.0*sum(numOfHarq1stTx)) as ue_HARQ_retx_pid_count,
67 100.0*sum(numOfBad1stMacPduTx) / (1.0*sum(numOfHarq1stTx)) as ue_MAC_PDU_init_Tx_failed_percent,
68 100.0*sum(numOfBadLastMacPduTx) / (1.0*sum(numOfHarq1stTx)) as ue_MAC_PDU_last_Tx_failed_percent
69 from LTE_PCMD.lte_dl_sched_trace
70 group by timestamp_ms/$window as TB, eci, eutran_trace_id