測試報告是指把測試的過程和結果寫成文檔，對發現的問題和缺陷進行分析，為糾正軟件的存在的質量問題提供依據，同時為軟件驗收和交付打下基?， 以下是為大家整理的關于材料測試報告3篇 , 供大家參考選擇。
材料測試報告3篇
【篇1】材料測試報告
GreenPlum測試報告1、配置信息1.1硬件配置
數據庫Segment host ：4 臺
型號：華賽T3500
內存：8*4G = 32 GB
CPU：2*4 core，Xeon(R) CPU E5430 2.66GHz
網卡：4個千兆網卡
硬盤：22*1T SATA / 7.2K轉
Disk ：2 * 1T SATA RAID 1 操作系統
5*1T SATA RAID 1+0 data (共4組RAID)
數據庫master host ：1 臺
型號：華賽T3500
內存：8*4G = 32G
CPU：2*4 core，Xeon(R) CPU E5430 2.66GHz
網卡：5個千兆網卡
硬盤：4*1T SATA / 7.2K轉
Disk ：2 * 1T SATA RAID 1 操作系統
2*1T SATA RAID 1+0 data
千兆網絡交換機一臺：
4臺segment host 使用4塊千兆網口和1臺master host做內聯；
Master host 使用第五個千兆網口做public ip
操作系統：Suse 11 SP1
1.2測試環境
1、 總共32個PostGreSql實例，每臺支持8個，所有表的數據幾乎被等分在32個數據庫實例中，無segment instance的鏡像。
2、測試案例綜述2.1案例設計
1. 此次測試主要可以從兩個角度來分析：串行和并行以及在此基礎上的數據入庫和sql查詢；
2. 測試過程中記錄性能指標（cpu/memory/io/network）；
3. 分區輪換測試；
4. 在segment instance無mirror的情況下，宕掉一個instance能否繼續使用GP；
5. 主備mater部署及切換；
6. 在配置了segment instance級別的mirror之后，宕一個instance，測試GP能否繼續使用，且要求不影響數據的準確性；在此基礎上，繼續測試宕掉整臺設備看是否GP還能繼續使用，且不影響數據的準確性。
2.2測試數據
共5張表（ne_cell_c / ne_cell_c_bj / ne_bts_c / mod_cdr_hw / mod_do_hw）
其中：ne_cell_c 共65558條記錄 21.3M；
ne_cell_c_bj 共10199條記錄 3.27M；
Ne_bts_c 共18064條記錄 4.08M；
Mod_cdr_hw（700列） 廣州（city_id=20）一天的數據，28,018,657條記錄，44.8GByte；
Mod_do_hw（459列） 北京（city_id=10）一天的數據，73,027,740條記錄，97GByte；
9個查詢sql（在測試時根據情況又添加了一些sql，具體請看測試結果中的sql文本）：
-------------------------------------------------------------------------------------------------------------------
1)
select * from mod_cdr_hw
where access_time > To_Date("2010-12-28 00:00:00", "yyyy-mm-dd hh24:mi:ss")
and access_time < To_Date("2010-12-29 00:00:00", "yyyy-mm-dd hh24:mi:ss")
and access_cell=1039;
2)
select OMCID,
CITY_ID,
NE_SYS_ID,
RELATED_CELL,
RELATED_BTS,
RELATED_BSC,
RELATED_OMC,
HANDLE_INDEX,
CALL_REF_NUM,
TIME_STAMP,
CHR_VER,
CHR_TYPE,
RELEASE_CFC,
RELEASE_CAUSE,
IMSI,
ESN,
CALL_STATE,
DIALED_DIGITS,
BAND_CLASS,
PG_DURATION,
ACCESS_TIME,
ACCESS_TIME_MSEC,
SRV_CONN_START_TIME,
ASSIGN_DURATION,
PREAMBLE_DURATION,
NEGO_DURATION,
CALL_DURATION,
CALL_OR_CALLED_OR_HHO,
SERVICE_OPTION,
FINAL_SERVICE_OPTION,
MOBILE_PROTOCOL_REV,
MOBILE_PROTOCOL_REV_INUSE,
SCM,
QOS_INDEX,
USER_QOS_GRADE,
REV_FCH_GATING,
PCF_IP,
IWF_CPU_ID,
MD_PATH_CH_NO,
PSTN_PATH_CH_NO,
PCM,
A_E1_SLOT,
SERVICE_ONE_WAY_DELAY,
AUTH_MODE,
SLOT_CYCLE_INDEX,
SIGNAL_TYPE,
ALERT_PITCH,
SIGNAL,
PRIVACY_CURR_TYPE,
MOB_TERM,
DCCH_SUPPORTED,
FCH_SUPPORTED,
OTD_SUPPORTED,
QPCH_SUPPORTED,
GEO_LOCATION_TYPE,
FCH_FRM_SIZE_CAP,
DCCH_FRM_SIZE_CAP,
FCH_FWD_RC_CAP,
DCCH_FWD_RC_CAP,
FCH_REV_RC_CAP,
DCCH_REV_RC_CAP,
CALL_NOTPROC_COUNT,
ACCESS_CHNANNEL,
ASSIGN_CHANNEL,
ACCPROBE_HO_COUNT,
ADDT_PILOT_COUNT,
ACC_HO_FLAG,
ACCESS_CELL,
ACCESS_SECTOR,
ACCESS_STRENGTH,
ADDTPN1_CELL_ID,
ADDTPN1_SECTOR_ID,
ADDTPN1_PN_OFFSET,
ADDTPN1_STRENGTH,
ADDTPN2_CELL_ID,
ADDTPN2_SECTOR_ID,
ADDTPN2_PN_OFFSET,
ADDTPN2_STRENGTH,
PPU_CPU_ID,
MS_PARA_METER_TYPE,
MS_PARA_METER1_VALUE,
MS_PARA_METER2_VALUE,
MS_PARA_METER3_VALUE,
MS_PARA_METER4_VALUE,
MS_PARA_METER5_VALUE,
MS_PARA_METER6_VALUE,
MS_PARA_METER7_VALUE,
MS_PARA_METER8_VALUE,
MS_PARA_METER9_VALUE,
MS_PARA_METER10_VALUE,
MS_PARA_METER11_VALUE,
MS_PARA_METER12_VALUE,
MS_PARA_METER13_VALUE,
MS_PARA_METER14_VALUE,
MS_PARA_METER15_VALUE,
MS_PARA_METER16_VALUE,
MS_PARA_METER17_VALUE,
MS_PARA_METER18_VALUE,
CCM_RESERVED
from mod_cdr_hw
where access_time >
To_Date("2010-12-28 00:00:00", "yyyy-mm-dd hh24:mi:ss")
and access_time To_Date("2010-12-28 00:00:00", "yyyy-mm-dd hh24:mi:ss")
and access_time < To_Date("2010-12-29 00:00:00", "yyyy-mm-dd hh24:mi:ss")
and release_cfc="4";
---------------------------------------------------------------------------------------------------------------------------
5) select * from mod_cdr_hw
where access_time > To_Date("2010-12-28 00:00:00", "yyyy-mm-dd hh24:mi:ss")
and access_time < To_Date("2010-12-29 00:00:00", "yyyy-mm-dd hh24:mi:ss")
and imsi="460036271583050";
----------------------------------------------------------------------------------------------------------------------------
6) select * from mod_cdr_hw
where access_time > To_Date("2010-12-28 00:00:00", "yyyy-mm-dd hh24:mi:ss")
and access_time < To_Date("2010-12-29 00:00:00", "yyyy-mm-dd hh24:mi:ss")
and imsi="460030912862245";
-----------------------------------------------------------------------------------------------------------------------------
7) select * from mod_cdr_hw
where access_time > To_Date("2010-12-28 9:00:00", "yyyy-mm-dd hh24:mi:ss")
and access_time < To_Date("2010-12-28 10:00:00", "yyyy-mm-dd hh24:mi:ss");
------------------------------------------------------------------------------------------------------------------------------
8) select b.* from mod_cdr_hw b, ne_cell_c c
where access_cell=1038 and c.ne_sys_id = b.related_cell;
-------------------------------------------------------------------------------------------------------------------------------
9) select * from mod_cdr_hw b, ne_cell_c c
where b.related_bts =1080810030078000 and c.ne_sys_id = b.related_cell;
--------------------------------------------------------------------------------------------------------------------------------
13) select omcid , city_id , ne_sys_id , related_cell , related_bts , related_bsc , related_omc , handle_index , call_ref_num , time_stamp , chr_ver , chr_type , release_cfc , release_cause , imsi , esn , call_state , dialed_digits , band_class , pg_duration , access_time , access_time_msec , srv_conn_start_time , assign_duration , preamble_duration , nego_duration , call_duration , call_or_called_or_hho , service_option , final_service_option , mobile_protocol_rev , mobile_protocol_rev_inuse , scm , qos_index , user_qos_grade , rev_fch_gating , pcf_ip , iwf_cpu_id , md_path_ch_no , pstn_path_ch_no , pcm , a_e1_slot , service_one_way_delay , auth_mode , slot_cycle_index , signal_type , alert_pitch , signal , privacy_curr_type , mob_term , dcch_supported , fch_supported , otd_supported , qpch_supported , geo_location_type , fch_frm_size_cap , dcch_frm_size_cap , fch_fwd_rc_cap , dcch_fwd_rc_cap , fch_rev_rc_cap , dcch_rev_rc_cap , call_notproc_count , access_chnannel , assign_channel , accprobe_ho_count , addt_pilot_count , acc_ho_flag , access_cell , access_sector , access_strength , addtpn1_cell_id , addtpn1_sector_id , addtpn1_pn_offset , addtpn1_strength , addtpn2_cell_id , addtpn2_sector_id , addtpn2_pn_offset , addtpn2_strength , ppu_cpu_id , ms_para_meter_type , ms_para_meter1_value , ms_para_meter2_value , ms_para_meter3_value , ms_para_meter4_value , ms_para_meter5_value , ms_para_meter6_value , ms_para_meter7_value , ms_para_meter8_value , ms_para_meter9_value , ms_para_meter10_value , ms_para_meter11_value , ms_para_meter12_value , ms_para_meter13_value , ms_para_meter14_value , ms_para_meter15_value , ms_para_meter16_value , ms_para_meter17_value , ms_para_meter18_value , ccm_reserved , access_carr_fwd_load from mod_cdr_hw where imsi="460036271583050";
-----------------------------------------------------------------------------------------------------------------------------
14）select omcid , city_id , ne_sys_id , related_cell , related_bts , related_bsc , related_omc , handle_index , call_ref_num , time_stamp , chr_ver , chr_type , release_cfc , release_cause , imsi , esn , call_state , dialed_digits , band_class , pg_duration , access_time , access_time_msec , srv_conn_start_time , assign_duration , preamble_duration , nego_duration , call_duration , call_or_called_or_hho , service_option , final_service_option , mobile_protocol_rev , mobile_protocol_rev_inuse , scm , qos_index , user_qos_grade , rev_fch_gating , pcf_ip , iwf_cpu_id , md_path_ch_no , pstn_path_ch_no , pcm , a_e1_slot , service_one_way_delay , auth_mode , slot_cycle_index , signal_type , alert_pitch , signal , privacy_curr_type , mob_term , dcch_supported , fch_supported , otd_supported , qpch_supported , geo_location_type , fch_frm_size_cap , dcch_frm_size_cap , fch_fwd_rc_cap , dcch_fwd_rc_cap , fch_rev_rc_cap , dcch_rev_rc_cap , call_notproc_count , access_chnannel , assign_channel , accprobe_ho_count , addt_pilot_count , acc_ho_flag , access_cell , access_sector , access_strength , addtpn1_cell_id , addtpn1_sector_id , addtpn1_pn_offset , addtpn1_strength , addtpn2_cell_id , addtpn2_sector_id , addtpn2_pn_offset , addtpn2_strength , ppu_cpu_id , ms_para_meter_type , ms_para_meter1_value , ms_para_meter2_value , ms_para_meter3_value , ms_para_meter4_value , ms_para_meter5_value , ms_para_meter6_value , ms_para_meter7_value , ms_para_meter8_value , ms_para_meter9_value , ms_para_meter10_value , ms_para_meter11_value , ms_para_meter12_value , ms_para_meter13_value , ms_para_meter14_value , ms_para_meter15_value , ms_para_meter16_value , ms_para_meter17_value , ms_para_meter18_value , ccm_reserved , access_carr_fwd_load ,access_carr_fwd_basic_thresh , access_carr_fwd_badleg_ratio , access_carr_channle_count , access_carr_rvs_equ_user , access_carr_rvs_rssi , access_carr_rvs_badleg_ratio , access_carr_access_load , access_carr_access_fail_rate , init_rf_conn_count , init_rf_conn1_cell , init_rf_conn1_sector , init_rf_conn2_cell , init_rf_conn2_sector , init_rf_conn3_cell , init_rf_conn3_sector , last_rf_conn_time_vos , last_rf_conn_count , last_rf_conn1_cell , last_rf_conn1_sector , last_rf_conn1_str , last_rf_conn1_onewaydelay , last_rf_conn2_cell , last_rf_conn2_sector , last_rf_conn2_str , last_rf_conn2_onewaydelay , last_rf_conn3_cell , last_rf_conn3_sector , last_rf_conn3_str , last_rf_conn3_onewaydelay , fwd_fer0 , fwd_fer1 , fwd_fer2 , fwd_fer3 , fwd_fer4 , fwd_fer5 , fwd_fer6 , fwd_fer7 , fwd_fer8 , fwd_fer9 , rev_totframe0 , rev_totframe1 , rev_totframe2 , rev_totframe3 , rev_totframe4 , rev_totframe5 , rev_totframe6 , rev_totframe7 , rev_totframe8 , rev_totframe9 , rev_errframe0 , rev_errframe1 , rev_errframe2 , rev_errframe3 , rev_errframe4 , rev_errframe5 , rev_errframe6 , rev_errframe7 , rev_errframe8 , rev_errframe9 , rev_leg1_totframe0 , rev_leg1_totframe1 , rev_leg1_totframe2 , rev_leg1_totframe3 , rev_leg1_totframe4 , rev_leg1_totframe5 , rev_leg1_totframe6 , rev_leg1_totframe7 , rev_leg1_totframe8 , rev_leg1_totframe9 , rev_leg1_errframe0 , rev_leg1_errframe1 , rev_leg1_errframe2 , rev_leg1_errframe3 , rev_leg1_errframe4 , rev_leg1_errframe5 , rev_leg1_errframe6 , rev_leg1_errframe7 , rev_leg1_errframe8 , rev_leg1_errframe9 , rev_leg2_totframe0 , rev_leg2_totframe1 , rev_leg2_totframe2 , rev_leg2_totframe3 , rev_leg2_totframe4 , rev_leg2_totframe5 , rev_leg2_totframe6 , rev_leg2_totframe7 , rev_leg2_totframe8 , rev_leg2_totframe9 , rev_leg2_errframe0 , rev_leg2_errframe1 , rev_leg2_errframe2 , rev_leg2_errframe3 , rev_leg2_errframe4 , rev_leg2_errframe5 , rev_leg2_errframe6 , rev_leg2_errframe7 , rev_leg2_errframe8 , rev_leg2_errframe9 from mod_cdr_hw , rev_leg3_totframe0 where imsi="460036271583050";
-------------------------------------------------------------------------------------------------------------------------------
15) select omcid , city_id , ne_sys_id , related_cell , related_bts , related_bsc , related_omc , handle_index , call_ref_num , time_stamp , chr_ver , chr_type , release_cfc , release_cause , imsi , esn , call_state , dialed_digits , band_class , pg_duration , access_time , access_time_msec , srv_conn_start_time , assign_duration , preamble_duration , nego_duration , call_duration , call_or_called_or_hho , service_option , final_service_option , mobile_protocol_rev , mobile_protocol_rev_inuse , scm , qos_index , user_qos_grade , rev_fch_gating , pcf_ip , iwf_cpu_id , md_path_ch_no , pstn_path_ch_no , pcm , a_e1_slot , service_one_way_delay , auth_mode , slot_cycle_index , signal_type , alert_pitch , signal , privacy_curr_type , mob_term , dcch_supported , fch_supported , otd_supported , qpch_supported , geo_location_type , fch_frm_size_cap , dcch_frm_size_cap , fch_fwd_rc_cap , dcch_fwd_rc_cap , fch_rev_rc_cap , dcch_rev_rc_cap , call_notproc_count , access_chnannel , assign_channel , accprobe_ho_count , addt_pilot_count , acc_ho_flag , access_cell , access_sector , access_strength , addtpn1_cell_id , addtpn1_sector_id , addtpn1_pn_offset , addtpn1_strength , addtpn2_cell_id , addtpn2_sector_id , addtpn2_pn_offset , addtpn2_strength , ppu_cpu_id , ms_para_meter_type , ms_para_meter1_value , ms_para_meter2_value , ms_para_meter3_value , ms_para_meter4_value , ms_para_meter5_value , ms_para_meter6_value , ms_para_meter7_value , ms_para_meter8_value , ms_para_meter9_value , ms_para_meter10_value , ms_para_meter11_value , ms_para_meter12_value , ms_para_meter13_value , ms_para_meter14_value , ms_para_meter15_value , ms_para_meter16_value , ms_para_meter17_value , ms_para_meter18_value , ccm_reserved , access_carr_fwd_load ,access_carr_fwd_basic_thresh , access_carr_fwd_badleg_ratio , access_carr_channle_count , access_carr_rvs_equ_user , access_carr_rvs_rssi , access_carr_rvs_badleg_ratio , access_carr_access_load , access_carr_access_fail_rate , init_rf_conn_count , init_rf_conn1_cell , init_rf_conn1_sector , init_rf_conn2_cell , init_rf_conn2_sector , init_rf_conn3_cell , init_rf_conn3_sector , last_rf_conn_time_vos , last_rf_conn_count , last_rf_conn1_cell , last_rf_conn1_sector , last_rf_conn1_str , last_rf_conn1_onewaydelay , last_rf_conn2_cell , last_rf_conn2_sector , last_rf_conn2_str , last_rf_conn2_onewaydelay , last_rf_conn3_cell , last_rf_conn3_sector , last_rf_conn3_str , last_rf_conn3_onewaydelay , fwd_fer0 , fwd_fer1 , fwd_fer2 , fwd_fer3 , fwd_fer4 , fwd_fer5 , fwd_fer6 , fwd_fer7 , fwd_fer8 , fwd_fer9 , rev_totframe0 , rev_totframe1 , rev_totframe2 , rev_totframe3 , rev_totframe4 , rev_totframe5 , rev_totframe6 , rev_totframe7 , rev_totframe8 , rev_totframe9 , rev_errframe0 , rev_errframe1 , rev_errframe2 , rev_errframe3 , rev_errframe4 , rev_errframe5 , rev_errframe6 , rev_errframe7 , rev_errframe8 , rev_errframe9 , rev_leg1_totframe0 , rev_leg1_totframe1 , rev_leg1_totframe2 , rev_leg1_totframe3 , rev_leg1_totframe4 , rev_leg1_totframe5 , rev_leg1_totframe6 , rev_leg1_totframe7 , rev_leg1_totframe8 , rev_leg1_totframe9 , rev_leg1_errframe0 , rev_leg1_errframe1 , rev_leg1_errframe2 , rev_leg1_errframe3 , rev_leg1_errframe4 , rev_leg1_errframe5 , rev_leg1_errframe6 , rev_leg1_errframe7 , rev_leg1_errframe8 , rev_leg1_errframe9 , rev_leg2_totframe0 , rev_leg2_totframe1 , rev_leg2_totframe2 , rev_leg2_totframe3 , rev_leg2_totframe4 , rev_leg2_totframe5 , rev_leg2_totframe6 , rev_leg2_totframe7 , rev_leg2_totframe8 , rev_leg2_totframe9 , rev_leg2_errframe0 , rev_leg2_errframe1 , rev_leg2_errframe2 , rev_leg2_errframe3 , rev_leg2_errframe4 , rev_leg2_errframe5 , rev_leg2_errframe6 , rev_leg2_errframe7 , rev_leg2_errframe8 , rev_leg2_errframe9,rev_leg3_totframe0 ,rev_leg3_totframe1 , rev_leg3_totframe2 , rev_leg3_totframe3 , rev_leg3_totframe4 , rev_leg3_totframe5 , rev_leg3_totframe6 , rev_leg3_totframe7 , rev_leg3_totframe8 , rev_leg3_totframe9 , rev_leg3_errframe0 , rev_leg3_errframe1 , rev_leg3_errframe2 , rev_leg3_errframe3 , rev_leg3_errframe4 , rev_leg3_errframe5 , rev_leg3_errframe6 , rev_leg3_errframe7 , rev_leg3_errframe8 , rev_leg3_errframe9 , rev_ebnt0 , rev_ebnt1 , rev_ebnt2 , rev_ebnt3 , rev_ebnt4 , rev_ebnt5 , rev_ebnt6 , rev_ebnt7 , rev_ebnt8 , rev_ebnt9 , rev_leg1_ebnt0 , rev_leg1_ebnt1 , rev_leg1_ebnt2 , rev_leg1_ebnt3 , rev_leg1_ebnt4 , rev_leg1_ebnt5 , rev_leg1_ebnt6 , rev_leg1_ebnt7 , rev_leg1_ebnt8 , rev_leg1_ebnt9 , rev_leg2_ebnt0 , rev_leg2_ebnt1 , rev_leg2_ebnt2 , rev_leg2_ebnt3 , rev_leg2_ebnt4 , rev_leg2_ebnt5 , rev_leg2_ebnt6 , rev_leg2_ebnt7 , rev_leg2_ebnt8 , rev_leg2_ebnt9 , rev_leg3_ebnt0 , rev_leg3_ebnt1 , rev_leg3_ebnt2 , rev_leg3_ebnt3 , rev_leg3_ebnt4 , rev_leg3_ebnt5 , rev_leg3_ebnt6 , rev_leg3_ebnt7 , rev_leg3_ebnt8 , rev_leg3_ebnt9 , fwd_tch_fer_ratio_0_to_3 , fwd_tch_fer_ratio_3_to_7 , fwd_tch_fer_ratio_7_to_15 , fwd_tch_fer_ratio_more_than_15 , fwd_tch_expect_fer , fwd_totframe , fwd_errframe , fwd_sch_totframe , fwd_sch_errframe , fwd_quality , rvs_quality , last_rf_higa1_count , last_rf_higa1_temp , last_rf_higa1_intervals , last_rf_higa1_begin , last_rf_higa1_end , last_rf_higa2_count , last_rf_higa2_temp , last_rf_higa2_intervals , last_rf_higa2_begin , last_rf_higa2_end , last_rf_higa3_count , last_rf_higa3_temp , last_rf_higa3_intervals , last_rf_higa3_begin , last_rf_higa3_end , last_rf_setp_count , last_rf_setp_temp , last_rf_setp_intervals , last_rf_setp_begin , last_rf_setp_end , first_psmm_time , first_psmm_act_str , first_psmm_pn_count , first_psmm_cell1 , first_psmm_sector1 , first_psmm_pn1_strength , first_psmm_pn1_onewaydelay , first_psmm_maho_pn1_keep , first_psmm_pn1_pilotset,first_psmm_cell2 from mod_cdr_hw where imsi="460036271583050";
------------------------------------------------------------------------------------------------------------------------------
16) select omcid , city_id , ne_sys_id , related_cell , related_bts , related_bsc , related_omc , handle_index , call_ref_num , time_stamp , chr_ver , chr_type , release_cfc , release_cause , imsi , esn , call_state , dialed_digits , band_class , pg_duration , access_time , access_time_msec , srv_conn_start_time , assign_duration , preamble_duration , nego_duration , call_duration , call_or_called_or_hho , service_option , final_service_option , mobile_protocol_rev , mobile_protocol_rev_inuse , scm , qos_index , user_qos_grade , rev_fch_gating , pcf_ip , iwf_cpu_id , md_path_ch_no , pstn_path_ch_no , pcm , a_e1_slot , service_one_way_delay , auth_mode , slot_cycle_index , signal_type , alert_pitch , signal , privacy_curr_type , mob_term , dcch_supported , fch_supported , otd_supported , qpch_supported , geo_location_type , fch_frm_size_cap , dcch_frm_size_cap , fch_fwd_rc_cap , dcch_fwd_rc_cap , fch_rev_rc_cap , dcch_rev_rc_cap , call_notproc_count , access_chnannel , assign_channel , accprobe_ho_count , addt_pilot_count , acc_ho_flag , access_cell , access_sector , access_strength , addtpn1_cell_id , addtpn1_sector_id , addtpn1_pn_offset , addtpn1_strength , addtpn2_cell_id , addtpn2_sector_id , addtpn2_pn_offset , addtpn2_strength , ppu_cpu_id , ms_para_meter_type , ms_para_meter1_value , ms_para_meter2_value , ms_para_meter3_value , ms_para_meter4_value , ms_para_meter5_value , ms_para_meter6_value , ms_para_meter7_value , ms_para_meter8_value , ms_para_meter9_value , ms_para_meter10_value , ms_para_meter11_value , ms_para_meter12_value , ms_para_meter13_value , ms_para_meter14_value , ms_para_meter15_value , ms_para_meter16_value , ms_para_meter17_value , ms_para_meter18_value , ccm_reserved , access_carr_fwd_load ,access_carr_fwd_basic_thresh , access_carr_fwd_badleg_ratio , access_carr_channle_count , access_carr_rvs_equ_user , access_carr_rvs_rssi , access_carr_rvs_badleg_ratio , access_carr_access_load , access_carr_access_fail_rate , init_rf_conn_count , init_rf_conn1_cell , init_rf_conn1_sector , init_rf_conn2_cell , init_rf_conn2_sector , init_rf_conn3_cell , init_rf_conn3_sector , last_rf_conn_time_vos , last_rf_conn_count , last_rf_conn1_cell , last_rf_conn1_sector , last_rf_conn1_str , last_rf_conn1_onewaydelay , last_rf_conn2_cell , last_rf_conn2_sector , last_rf_conn2_str , last_rf_conn2_onewaydelay , last_rf_conn3_cell , last_rf_conn3_sector , last_rf_conn3_str , last_rf_conn3_onewaydelay , fwd_fer0 , fwd_fer1 , fwd_fer2 , fwd_fer3 , fwd_fer4 , fwd_fer5 , fwd_fer6 , fwd_fer7 , fwd_fer8 , fwd_fer9 , rev_totframe0 , rev_totframe1 , rev_totframe2 , rev_totframe3 , rev_totframe4 , rev_totframe5 , rev_totframe6 , rev_totframe7 , rev_totframe8 , rev_totframe9 , rev_errframe0 , rev_errframe1 , rev_errframe2 , rev_errframe3 , rev_errframe4 , rev_errframe5 , rev_errframe6 , rev_errframe7 , rev_errframe8 , rev_errframe9 , rev_leg1_totframe0 , rev_leg1_totframe1 , rev_leg1_totframe2 , rev_leg1_totframe3 , rev_leg1_totframe4 , rev_leg1_totframe5 , rev_leg1_totframe6 , rev_leg1_totframe7 , rev_leg1_totframe8 , rev_leg1_totframe9 , rev_leg1_errframe0 , rev_leg1_errframe1 , rev_leg1_errframe2 , rev_leg1_errframe3 , rev_leg1_errframe4 , rev_leg1_errframe5 , rev_leg1_errframe6 , rev_leg1_errframe7 , rev_leg1_errframe8 , rev_leg1_errframe9 , rev_leg2_totframe0 , rev_leg2_totframe1 , rev_leg2_totframe2 , rev_leg2_totframe3 , rev_leg2_totframe4 , rev_leg2_totframe5 , rev_leg2_totframe6 , rev_leg2_totframe7 , rev_leg2_totframe8 , rev_leg2_totframe9 , rev_leg2_errframe0 , rev_leg2_errframe1 , rev_leg2_errframe2 , rev_leg2_errframe3 , rev_leg2_errframe4 , rev_leg2_errframe5 , rev_leg2_errframe6 , rev_leg2_errframe7 , rev_leg2_errframe8 , rev_leg2_errframe9,rev_leg3_totframe0 ,rev_leg3_totframe1 , rev_leg3_totframe2 , rev_leg3_totframe3 , rev_leg3_totframe4 , rev_leg3_totframe5 , rev_leg3_totframe6 , rev_leg3_totframe7 , rev_leg3_totframe8 , rev_leg3_totframe9 , rev_leg3_errframe0 , rev_leg3_errframe1 , rev_leg3_errframe2 , rev_leg3_errframe3 , rev_leg3_errframe4 , rev_leg3_errframe5 , rev_leg3_errframe6 , rev_leg3_errframe7 , rev_leg3_errframe8 , rev_leg3_errframe9 , rev_ebnt0 , rev_ebnt1 , rev_ebnt2 , rev_ebnt3 , rev_ebnt4 , rev_ebnt5 , rev_ebnt6 , rev_ebnt7 , rev_ebnt8 , rev_ebnt9 , rev_leg1_ebnt0 , rev_leg1_ebnt1 , rev_leg1_ebnt2 , rev_leg1_ebnt3 , rev_leg1_ebnt4 , rev_leg1_ebnt5 , rev_leg1_ebnt6 , rev_leg1_ebnt7 , rev_leg1_ebnt8 , rev_leg1_ebnt9 , rev_leg2_ebnt0 , rev_leg2_ebnt1 , rev_leg2_ebnt2 , rev_leg2_ebnt3 , rev_leg2_ebnt4 , rev_leg2_ebnt5 , rev_leg2_ebnt6 , rev_leg2_ebnt7 , rev_leg2_ebnt8 , rev_leg2_ebnt9 , rev_leg3_ebnt0 , rev_leg3_ebnt1 , rev_leg3_ebnt2 , rev_leg3_ebnt3 , rev_leg3_ebnt4 , rev_leg3_ebnt5 , rev_leg3_ebnt6 , rev_leg3_ebnt7 , rev_leg3_ebnt8 , rev_leg3_ebnt9 , fwd_tch_fer_ratio_0_to_3 , fwd_tch_fer_ratio_3_to_7 , fwd_tch_fer_ratio_7_to_15 , fwd_tch_fer_ratio_more_than_15 , fwd_tch_expect_fer , fwd_totframe , fwd_errframe , fwd_sch_totframe , fwd_sch_errframe , fwd_quality , rvs_quality , last_rf_higa1_count , last_rf_higa1_temp , last_rf_higa1_intervals , last_rf_higa1_begin , last_rf_higa1_end , last_rf_higa2_count , last_rf_higa2_temp , last_rf_higa2_intervals , last_rf_higa2_begin , last_rf_higa2_end , last_rf_higa3_count , last_rf_higa3_temp , last_rf_higa3_intervals , last_rf_higa3_begin , last_rf_higa3_end , last_rf_setp_count , last_rf_setp_temp , last_rf_setp_intervals , last_rf_setp_begin , last_rf_setp_end , first_psmm_time , first_psmm_act_str , first_psmm_pn_count , first_psmm_cell1 , first_psmm_sector1 , first_psmm_pn1_strength , first_psmm_pn1_onewaydelay , first_psmm_maho_pn1_keep , first_psmm_pn1_pilotset,first_psmm_cell2, first_psmm_sector2 , first_psmm_pn2_strength , first_psmm_pn2_onewaydelay , first_psmm_pn2_keep , first_psmm_pn2_pilotset , first_psmm_cell3 , first_psmm_sector3 , first_psmm_pn3_strength , first_psmm_pn3_onewaydelay , first_psmm_pn3_keep , first_psmm_pn3_pilotset , first_psmm_cell4 , first_psmm_sector4 , first_psmm_pn4_strength , first_psmm_pn4_onewaydelay , first_psmm_pn4_keep , first_psmm_pn4_pilotset , first_psmm_cell5 , first_psmm_sector5 , first_psmm_pn5_strength , first_psmm_pn5_onewaydelay , first_psmm_pn5_keep , first_psmm_pn5_pilotset , first_psmm_cell6 , first_psmm_sector6 , first_psmm_pn6_strength , first_psmm_pn6_onewaydelay , first_psmm_pn6_keep , first_psmm_pn6_pilotset , first_sho_time , first_sho_cause , first_sho_post_agst , first_sho_result , last_maho_time , init_maho_act_str , last_maho_pn_count , last_maho_cell1 , last_maho_sector1 , last_maho_pn1_strength , last_maho_pn1_onewaydelay , last_maho_pn1_keep , last_maho_pn1_pilotset , last_maho_cell2 , last_maho_sector2 , last_maho_pn2_strength , last_maho_pn2_onewaydelay , last_maho_pn2_keep , last_maho_pn2_pilotset , last_maho_cell3 , last_maho_sector3 , last_maho_pn3_strength , last_maho_pn3_onewaydelay , last_maho_pn3_keep , last_maho_pn3_pilotset , last_maho_cell4 , last_maho_sector4 , last_maho_pn4_strength , last_maho_pn4_onewaydelay , last_maho_pn4_keep , last_maho_pn4_pilotset , last_maho_cell5 , last_maho_sector5 , last_maho_pn5_strength , last_maho_pn5_onewaydelay , last_maho_pn5_keep , last_maho_pn5_pilotset , last_maho_cell6 , last_maho_sector6 , last_maho_pn6_strength , last_maho_pn6_onewaydelay , last_maho_pn6_keep , last_maho_pn6_pilotset , last_sho_time , last_sho_cause , last_sho_result , last_sho_post_agst , last_psmm_time , init_psmm_act_str , last_psmm_pn_count , last_psmm_cell1 , last_psmm_sector1 , last_psmm_pn1_strength , last_psmm_pn1_onewaydelay , last_psmm_pn1_keep , last_psmm_pn1_pilotset , last_psmm_cell2 , last_psmm_sector2 , last_psmm_pn2_strength , last_psmm_pn2_onewaydelay , last_psmm_pn2_keep , last_psmm_pn2_pilotset , last_psmm_cell3 , last_psmm_sector3 , last_psmm_pn3_strength , last_psmm_pn3_onewaydelay , last_psmm_pn3_keep , last_psmm_pn3_pilotset , last_psmm_cell4 , last_psmm_sector4 ,last_psmm_pn4_strength from mod_cdr_hw where imsi="460036271583050";
-------------------------------------------------------------------------------------------------------------------------------
17) select omcid , city_id , ne_sys_id , related_cell , related_bts , related_bsc , related_omc , handle_index , call_ref_num , time_stamp , chr_ver , chr_type , release_cfc , release_cause , imsi , esn , call_state , dialed_digits , band_class , pg_duration , access_time , access_time_msec , srv_conn_start_time , assign_duration , preamble_duration , nego_duration , call_duration , call_or_called_or_hho , service_option , final_service_option , mobile_protocol_rev , mobile_protocol_rev_inuse , scm , qos_index , user_qos_grade , rev_fch_gating , pcf_ip , iwf_cpu_id , md_path_ch_no , pstn_path_ch_no , pcm , a_e1_slot , service_one_way_delay , auth_mode , slot_cycle_index , signal_type , alert_pitch , signal , privacy_curr_type , mob_term , dcch_supported , fch_supported , otd_supported , qpch_supported , geo_location_type , fch_frm_size_cap , dcch_frm_size_cap , fch_fwd_rc_cap , dcch_fwd_rc_cap , fch_rev_rc_cap , dcch_rev_rc_cap , call_notproc_count , access_chnannel , assign_channel , accprobe_ho_count , addt_pilot_count , acc_ho_flag , access_cell , access_sector , access_strength , addtpn1_cell_id , addtpn1_sector_id , addtpn1_pn_offset , addtpn1_strength , addtpn2_cell_id , addtpn2_sector_id , addtpn2_pn_offset , addtpn2_strength , ppu_cpu_id , ms_para_meter_type , ms_para_meter1_value , ms_para_meter2_value , ms_para_meter3_value , ms_para_meter4_value , ms_para_meter5_value , ms_para_meter6_value , ms_para_meter7_value , ms_para_meter8_value , ms_para_meter9_value , ms_para_meter10_value , ms_para_meter11_value , ms_para_meter12_value , ms_para_meter13_value , ms_para_meter14_value , ms_para_meter15_value , ms_para_meter16_value , ms_para_meter17_value , ms_para_meter18_value , ccm_reserved , access_carr_fwd_load ,access_carr_fwd_basic_thresh , access_carr_fwd_badleg_ratio , access_carr_channle_count , access_carr_rvs_equ_user , access_carr_rvs_rssi , access_carr_rvs_badleg_ratio , access_carr_access_load , access_carr_access_fail_rate , init_rf_conn_count , init_rf_conn1_cell , init_rf_conn1_sector , init_rf_conn2_cell , init_rf_conn2_sector , init_rf_conn3_cell , init_rf_conn3_sector , last_rf_conn_time_vos , last_rf_conn_count , last_rf_conn1_cell , last_rf_conn1_sector , last_rf_conn1_str , last_rf_conn1_onewaydelay , last_rf_conn2_cell , last_rf_conn2_sector , last_rf_conn2_str , last_rf_conn2_onewaydelay , last_rf_conn3_cell , last_rf_conn3_sector , last_rf_conn3_str , last_rf_conn3_onewaydelay , fwd_fer0 , fwd_fer1 , fwd_fer2 , fwd_fer3 , fwd_fer4 , fwd_fer5 , fwd_fer6 , fwd_fer7 , fwd_fer8 , fwd_fer9 , rev_totframe0 , rev_totframe1 , rev_totframe2 , rev_totframe3 , rev_totframe4 , rev_totframe5 , rev_totframe6 , rev_totframe7 , rev_totframe8 , rev_totframe9 , rev_errframe0 , rev_errframe1 , rev_errframe2 , rev_errframe3 , rev_errframe4 , rev_errframe5 , rev_errframe6 , rev_errframe7 , rev_errframe8 , rev_errframe9 , rev_leg1_totframe0 , rev_leg1_totframe1 , rev_leg1_totframe2 , rev_leg1_totframe3 , rev_leg1_totframe4 , rev_leg1_totframe5 , rev_leg1_totframe6 , rev_leg1_totframe7 , rev_leg1_totframe8 , rev_leg1_totframe9 , rev_leg1_errframe0 , rev_leg1_errframe1 , rev_leg1_errframe2 , rev_leg1_errframe3 , rev_leg1_errframe4 , rev_leg1_errframe5 , rev_leg1_errframe6 , rev_leg1_errframe7 , rev_leg1_errframe8 , rev_leg1_errframe9 , rev_leg2_totframe0 , rev_leg2_totframe1 , rev_leg2_totframe2 , rev_leg2_totframe3 , rev_leg2_totframe4 , rev_leg2_totframe5 , rev_leg2_totframe6 , rev_leg2_totframe7 , rev_leg2_totframe8 , rev_leg2_totframe9 , rev_leg2_errframe0 , rev_leg2_errframe1 , rev_leg2_errframe2 , rev_leg2_errframe3 , rev_leg2_errframe4 , rev_leg2_errframe5 , rev_leg2_errframe6 , rev_leg2_errframe7 , rev_leg2_errframe8 , rev_leg2_errframe9,rev_leg3_totframe0 ,rev_leg3_totframe1 , rev_leg3_totframe2 , rev_leg3_totframe3 , rev_leg3_totframe4 , rev_leg3_totframe5 , rev_leg3_totframe6 , rev_leg3_totframe7 , rev_leg3_totframe8 , rev_leg3_totframe9 , rev_leg3_errframe0 , rev_leg3_errframe1 , rev_leg3_errframe2 , rev_leg3_errframe3 , rev_leg3_errframe4 , rev_leg3_errframe5 , rev_leg3_errframe6 , rev_leg3_errframe7 , rev_leg3_errframe8 , rev_leg3_errframe9 , rev_ebnt0 , rev_ebnt1 , rev_ebnt2 , rev_ebnt3 , rev_ebnt4 , rev_ebnt5 , rev_ebnt6 , rev_ebnt7 , rev_ebnt8 , rev_ebnt9 , rev_leg1_ebnt0 , rev_leg1_ebnt1 , rev_leg1_ebnt2 , rev_leg1_ebnt3 , rev_leg1_ebnt4 , rev_leg1_ebnt5 , rev_leg1_ebnt6 , rev_leg1_ebnt7 , rev_leg1_ebnt8 , rev_leg1_ebnt9 , rev_leg2_ebnt0 , rev_leg2_ebnt1 , rev_leg2_ebnt2 , rev_leg2_ebnt3 , rev_leg2_ebnt4 , rev_leg2_ebnt5 , rev_leg2_ebnt6 , rev_leg2_ebnt7 , rev_leg2_ebnt8 , rev_leg2_ebnt9 , rev_leg3_ebnt0 , rev_leg3_ebnt1 , rev_leg3_ebnt2 , rev_leg3_ebnt3 , rev_leg3_ebnt4 , rev_leg3_ebnt5 , rev_leg3_ebnt6 , rev_leg3_ebnt7 , rev_leg3_ebnt8 , rev_leg3_ebnt9 , fwd_tch_fer_ratio_0_to_3 , fwd_tch_fer_ratio_3_to_7 , fwd_tch_fer_ratio_7_to_15 , fwd_tch_fer_ratio_more_than_15 , fwd_tch_expect_fer , fwd_totframe , fwd_errframe , fwd_sch_totframe , fwd_sch_errframe , fwd_quality , rvs_quality , last_rf_higa1_count , last_rf_higa1_temp , last_rf_higa1_intervals , last_rf_higa1_begin , last_rf_higa1_end , last_rf_higa2_count , last_rf_higa2_temp , last_rf_higa2_intervals , last_rf_higa2_begin , last_rf_higa2_end , last_rf_higa3_count , last_rf_higa3_temp , last_rf_higa3_intervals , last_rf_higa3_begin , last_rf_higa3_end , last_rf_setp_count , last_rf_setp_temp , last_rf_setp_intervals , last_rf_setp_begin , last_rf_setp_end , first_psmm_time , first_psmm_act_str , first_psmm_pn_count , first_psmm_cell1 , first_psmm_sector1 , first_psmm_pn1_strength , first_psmm_pn1_onewaydelay , first_psmm_maho_pn1_keep , first_psmm_pn1_pilotset,first_psmm_cell2, first_psmm_sector2 , first_psmm_pn2_strength , first_psmm_pn2_onewaydelay , first_psmm_pn2_keep , first_psmm_pn2_pilotset , first_psmm_cell3 , first_psmm_sector3 , first_psmm_pn3_strength , first_psmm_pn3_onewaydelay , first_psmm_pn3_keep , first_psmm_pn3_pilotset , first_psmm_cell4 , first_psmm_sector4 , first_psmm_pn4_strength , first_psmm_pn4_onewaydelay , first_psmm_pn4_keep , first_psmm_pn4_pilotset , first_psmm_cell5 , first_psmm_sector5 , first_psmm_pn5_strength , first_psmm_pn5_onewaydelay , first_psmm_pn5_keep , first_psmm_pn5_pilotset , first_psmm_cell6 , first_psmm_sector6 , first_psmm_pn6_strength , first_psmm_pn6_onewaydelay , first_psmm_pn6_keep , first_psmm_pn6_pilotset , first_sho_time , first_sho_cause , first_sho_post_agst , first_sho_result , last_maho_time , init_maho_act_str , last_maho_pn_count , last_maho_cell1 , last_maho_sector1 , last_maho_pn1_strength , last_maho_pn1_onewaydelay , last_maho_pn1_keep , last_maho_pn1_pilotset , last_maho_cell2 , last_maho_sector2 , last_maho_pn2_strength , last_maho_pn2_onewaydelay , last_maho_pn2_keep , last_maho_pn2_pilotset , last_maho_cell3 , last_maho_sector3 , last_maho_pn3_strength , last_maho_pn3_onewaydelay , last_maho_pn3_keep , last_maho_pn3_pilotset , last_maho_cell4 , last_maho_sector4 , last_maho_pn4_strength , last_maho_pn4_onewaydelay , last_maho_pn4_keep , last_maho_pn4_pilotset , last_maho_cell5 , last_maho_sector5 , last_maho_pn5_strength , last_maho_pn5_onewaydelay , last_maho_pn5_keep , last_maho_pn5_pilotset , last_maho_cell6 , last_maho_sector6 , last_maho_pn6_strength , last_maho_pn6_onewaydelay , last_maho_pn6_keep , last_maho_pn6_pilotset , last_sho_time , last_sho_cause , last_sho_result , last_sho_post_agst , last_psmm_time , init_psmm_act_str , last_psmm_pn_count , last_psmm_cell1 , last_psmm_sector1 , last_psmm_pn1_strength , last_psmm_pn1_onewaydelay , last_psmm_pn1_keep , last_psmm_pn1_pilotset , last_psmm_cell2 , last_psmm_sector2 , last_psmm_pn2_strength , last_psmm_pn2_onewaydelay , last_psmm_pn2_keep , last_psmm_pn2_pilotset , last_psmm_cell3 , last_psmm_sector3 , last_psmm_pn3_strength , last_psmm_pn3_onewaydelay , last_psmm_pn3_keep , last_psmm_pn3_pilotset , last_psmm_cell4 , last_psmm_sector4 ,last_psmm_pn4_strength,last_psmm_pn4_onewaydelay , last_psmm_pn4_keep , last_psmm_pn4_pilotset , last_psmm_cell5 , last_psmm_sector5 , last_psmm_pn5_strength , last_psmm_pn5_onewaydelay , last_psmm_pn5_keep , last_psmm_pn5_pilotset , last_psmm_cell6 , last_psmm_sector6 , last_psmm_pn6_strength , last_psmm_pn6_onewaydelay , last_psmm_pn6_keep , last_psmm_pn6_pilotset , first_sho_fail_time , first_sho_fail_cause , last_ho_block_time , last_ho_block_cause , last_ho_block_pn_count , last_ho_block_pn , last_sho_fail_time , last_sho_fail_cause , one_pilot_count , one_pilot_duration , two_pilots_count , two_pilot_duration , three_pilots_count , threr_pilot_duration , four_pilots_count , four_pilot_duration , five_pilots_count , five_pilot_duration , six_pilots_count , six_pilot_duration , psmm_received_count , ppsmm_received_count , sho_count , sho_fail_count , loc_s_add_count , loc_s_add_fail_count , loc_sr_add_count , loc_sr_add_fail_count , loc_s_drop_count , loc_s_drop_fail_count , loc_sr_drop_count , loc_sr_drop_fail_count , ext_s_add_count , ext_s_add_fail_count , ext_s_drop_count , ext_s_drop_fail_count , hho_type , hho_tgt_freq , hho_tgt_count , hho_tgt1_market_id , hho_tgt1_switch_number , hho_tgt1_cell , hho_tgt1_sector , hho_tgt2_cell , hho_tgt2_sector , hho_tgt3_cell , hho_tgt3_sector , hho_result , hho_maho_time , hho_maho_act_count , hho_maho_act_str , hho_maho_pn_count , hho_maho_cell1 , hho_maho_sector1 , hho_maho_pn1_strength , hho_maho_pn1_onewaydelay , hho_maho_pn1_pilotset , hho_maho_cell2 , hho_maho_sector2 , hho_maho_pn2_strength , hho_maho_pn2_onewaydelay , hho_maho_pn2_pilotset , hho_maho_cell3 , hho_maho_sector3 , hho_maho_pn3_strength , hho_maho_pn3_onewaydelay , hho_maho_pn3_pilotset , hho_maho_cell4 , hho_maho_sector4 , hho_maho_pn4_strength , hho_maho_pn4_onewaydelay , hho_maho_pn4_pilotset , hho_maho_cell5 , hho_maho_sector5 , hho_maho_pn5_strength , hho_maho_pn5_onewaydelay , hho_maho_pn5_pilotset , hho_maho_cell6 , hho_maho_sector6 , hho_maho_pn6_strength , hho_maho_pn6_onewaydelay , hho_maho_pn6_pilotset , ics_count , ics_fail_count ,ics_begin_time from mod_cdr_hw where imsi="460036271583050";
---------------------------------------------------------------------------------------------------------------------------
18) select omcid , city_id , ne_sys_id , related_cell , related_bts , related_bsc , related_omc , handle_index , call_ref_num , time_stamp , chr_ver , chr_type , release_cfc , release_cause , imsi , esn , call_state , dialed_digits , band_class , pg_duration , access_time , access_time_msec , srv_conn_start_time , assign_duration , preamble_duration , nego_duration , call_duration , call_or_called_or_hho , service_option , final_service_option , mobile_protocol_rev , mobile_protocol_rev_inuse , scm , qos_index , user_qos_grade , rev_fch_gating , pcf_ip , iwf_cpu_id , md_path_ch_no , pstn_path_ch_no , pcm , a_e1_slot , service_one_way_delay , auth_mode , slot_cycle_index , signal_type , alert_pitch , signal , privacy_curr_type , mob_term , dcch_supported , fch_supported , otd_supported , qpch_supported , geo_location_type , fch_frm_size_cap , dcch_frm_size_cap , fch_fwd_rc_cap , dcch_fwd_rc_cap , fch_rev_rc_cap , dcch_rev_rc_cap , call_notproc_count , access_chnannel , assign_channel , accprobe_ho_count , addt_pilot_count , acc_ho_flag , access_cell , access_sector , access_strength , addtpn1_cell_id , addtpn1_sector_id , addtpn1_pn_offset , addtpn1_strength , addtpn2_cell_id , addtpn2_sector_id , addtpn2_pn_offset , addtpn2_strength , ppu_cpu_id , ms_para_meter_type , ms_para_meter1_value , ms_para_meter2_value , ms_para_meter3_value , ms_para_meter4_value , ms_para_meter5_value , ms_para_meter6_value , ms_para_meter7_value , ms_para_meter8_value , ms_para_meter9_value , ms_para_meter10_value , ms_para_meter11_value , ms_para_meter12_value , ms_para_meter13_value , ms_para_meter14_value , ms_para_meter15_value , ms_para_meter16_value , ms_para_meter17_value , ms_para_meter18_value , ccm_reserved , access_carr_fwd_load ,access_carr_fwd_basic_thresh , access_carr_fwd_badleg_ratio , access_carr_channle_count , access_carr_rvs_equ_user , access_carr_rvs_rssi , access_carr_rvs_badleg_ratio , access_carr_access_load , access_carr_access_fail_rate , init_rf_conn_count , init_rf_conn1_cell , init_rf_conn1_sector , init_rf_conn2_cell , init_rf_conn2_sector , init_rf_conn3_cell , init_rf_conn3_sector , last_rf_conn_time_vos , last_rf_conn_count , last_rf_conn1_cell , last_rf_conn1_sector , last_rf_conn1_str , last_rf_conn1_onewaydelay , last_rf_conn2_cell , last_rf_conn2_sector , last_rf_conn2_str , last_rf_conn2_onewaydelay , last_rf_conn3_cell , last_rf_conn3_sector , last_rf_conn3_str , last_rf_conn3_onewaydelay , fwd_fer0 , fwd_fer1 , fwd_fer2 , fwd_fer3 , fwd_fer4 , fwd_fer5 , fwd_fer6 , fwd_fer7 , fwd_fer8 , fwd_fer9 , rev_totframe0 , rev_totframe1 , rev_totframe2 , rev_totframe3 , rev_totframe4 , rev_totframe5 , rev_totframe6 , rev_totframe7 , rev_totframe8 , rev_totframe9 , rev_errframe0 , rev_errframe1 , rev_errframe2 , rev_errframe3 , rev_errframe4 , rev_errframe5 , rev_errframe6 , rev_errframe7 , rev_errframe8 , rev_errframe9 , rev_leg1_totframe0 , rev_leg1_totframe1 , rev_leg1_totframe2 , rev_leg1_totframe3 , rev_leg1_totframe4 , rev_leg1_totframe5 , rev_leg1_totframe6 , rev_leg1_totframe7 , rev_leg1_totframe8 , rev_leg1_totframe9 , rev_leg1_errframe0 , rev_leg1_errframe1 , rev_leg1_errframe2 , rev_leg1_errframe3 , rev_leg1_errframe4 , rev_leg1_errframe5 , rev_leg1_errframe6 , rev_leg1_errframe7 , rev_leg1_errframe8 , rev_leg1_errframe9 , rev_leg2_totframe0 , rev_leg2_totframe1 , rev_leg2_totframe2 , rev_leg2_totframe3 , rev_leg2_totframe4 , rev_leg2_totframe5 , rev_leg2_totframe6 , rev_leg2_totframe7 , rev_leg2_totframe8 , rev_leg2_totframe9 , rev_leg2_errframe0 , rev_leg2_errframe1 , rev_leg2_errframe2 , rev_leg2_errframe3 , rev_leg2_errframe4 , rev_leg2_errframe5 , rev_leg2_errframe6 , rev_leg2_errframe7 , rev_leg2_errframe8 , rev_leg2_errframe9,rev_leg3_totframe0 ,rev_leg3_totframe1 , rev_leg3_totframe2 , rev_leg3_totframe3 , rev_leg3_totframe4 , rev_leg3_totframe5 , rev_leg3_totframe6 , rev_leg3_totframe7 , rev_leg3_totframe8 , rev_leg3_totframe9 , rev_leg3_errframe0 , rev_leg3_errframe1 , rev_leg3_errframe2 , rev_leg3_errframe3 , rev_leg3_errframe4 , rev_leg3_errframe5 , rev_leg3_errframe6 , rev_leg3_errframe7 , rev_leg3_errframe8 , rev_leg3_errframe9 , rev_ebnt0 , rev_ebnt1 , rev_ebnt2 , rev_ebnt3 , rev_ebnt4 , rev_ebnt5 , rev_ebnt6 , rev_ebnt7 , rev_ebnt8 , rev_ebnt9 , rev_leg1_ebnt0 , rev_leg1_ebnt1 , rev_leg1_ebnt2 , rev_leg1_ebnt3 , rev_leg1_ebnt4 , rev_leg1_ebnt5 , rev_leg1_ebnt6 , rev_leg1_ebnt7 , rev_leg1_ebnt8 , rev_leg1_ebnt9 , rev_leg2_ebnt0 , rev_leg2_ebnt1 , rev_leg2_ebnt2 , rev_leg2_ebnt3 , rev_leg2_ebnt4 , rev_leg2_ebnt5 , rev_leg2_ebnt6 , rev_leg2_ebnt7 , rev_leg2_ebnt8 , rev_leg2_ebnt9 , rev_leg3_ebnt0 , rev_leg3_ebnt1 , rev_leg3_ebnt2 , rev_leg3_ebnt3 , rev_leg3_ebnt4 , rev_leg3_ebnt5 , rev_leg3_ebnt6 , rev_leg3_ebnt7 , rev_leg3_ebnt8 , rev_leg3_ebnt9 , fwd_tch_fer_ratio_0_to_3 , fwd_tch_fer_ratio_3_to_7 , fwd_tch_fer_ratio_7_to_15 , fwd_tch_fer_ratio_more_than_15 , fwd_tch_expect_fer , fwd_totframe , fwd_errframe , fwd_sch_totframe , fwd_sch_errframe , fwd_quality , rvs_quality , last_rf_higa1_count , last_rf_higa1_temp , last_rf_higa1_intervals , last_rf_higa1_begin , last_rf_higa1_end , last_rf_higa2_count , last_rf_higa2_temp , last_rf_higa2_intervals , last_rf_higa2_begin , last_rf_higa2_end , last_rf_higa3_count , last_rf_higa3_temp , last_rf_higa3_intervals , last_rf_higa3_begin , last_rf_higa3_end , last_rf_setp_count , last_rf_setp_temp , last_rf_setp_intervals , last_rf_setp_begin , last_rf_setp_end , first_psmm_time , first_psmm_act_str , first_psmm_pn_count , first_psmm_cell1 , first_psmm_sector1 , first_psmm_pn1_strength , first_psmm_pn1_onewaydelay , first_psmm_maho_pn1_keep , first_psmm_pn1_pilotset,first_psmm_cell2, first_psmm_sector2 , first_psmm_pn2_strength , first_psmm_pn2_onewaydelay , first_psmm_pn2_keep , first_psmm_pn2_pilotset , first_psmm_cell3 , first_psmm_sector3 , first_psmm_pn3_strength , first_psmm_pn3_onewaydelay , first_psmm_pn3_keep , first_psmm_pn3_pilotset , first_psmm_cell4 , first_psmm_sector4 , first_psmm_pn4_strength , first_psmm_pn4_onewaydelay , first_psmm_pn4_keep , first_psmm_pn4_pilotset , first_psmm_cell5 , first_psmm_sector5 , first_psmm_pn5_strength , first_psmm_pn5_onewaydelay , first_psmm_pn5_keep , first_psmm_pn5_pilotset , first_psmm_cell6 , first_psmm_sector6 , first_psmm_pn6_strength , first_psmm_pn6_onewaydelay , first_psmm_pn6_keep , first_psmm_pn6_pilotset , first_sho_time , first_sho_cause , first_sho_post_agst , first_sho_result , last_maho_time , init_maho_act_str , last_maho_pn_count , last_maho_cell1 , last_maho_sector1 , last_maho_pn1_strength , last_maho_pn1_onewaydelay , last_maho_pn1_keep , last_maho_pn1_pilotset , last_maho_cell2 , last_maho_sector2 , last_maho_pn2_strength , last_maho_pn2_onewaydelay , last_maho_pn2_keep , last_maho_pn2_pilotset , last_maho_cell3 , last_maho_sector3 , last_maho_pn3_strength , last_maho_pn3_onewaydelay , last_maho_pn3_keep , last_maho_pn3_pilotset , last_maho_cell4 , last_maho_sector4 , last_maho_pn4_strength , last_maho_pn4_onewaydelay , last_maho_pn4_keep , last_maho_pn4_pilotset , last_maho_cell5 , last_maho_sector5 , last_maho_pn5_strength , last_maho_pn5_onewaydelay , last_maho_pn5_keep , last_maho_pn5_pilotset , last_maho_cell6 , last_maho_sector6 , last_maho_pn6_strength , last_maho_pn6_onewaydelay , last_maho_pn6_keep , last_maho_pn6_pilotset , last_sho_time , last_sho_cause , last_sho_result , last_sho_post_agst , last_psmm_time , init_psmm_act_str , last_psmm_pn_count , last_psmm_cell1 , last_psmm_sector1 , last_psmm_pn1_strength , last_psmm_pn1_onewaydelay , last_psmm_pn1_keep , last_psmm_pn1_pilotset , last_psmm_cell2 , last_psmm_sector2 , last_psmm_pn2_strength , last_psmm_pn2_onewaydelay , last_psmm_pn2_keep , last_psmm_pn2_pilotset , last_psmm_cell3 , last_psmm_sector3 , last_psmm_pn3_strength , last_psmm_pn3_onewaydelay , last_psmm_pn3_keep , last_psmm_pn3_pilotset , last_psmm_cell4 , last_psmm_sector4 ,last_psmm_pn4_strength,last_psmm_pn4_onewaydelay , last_psmm_pn4_keep , last_psmm_pn4_pilotset , last_psmm_cell5 , last_psmm_sector5 , last_psmm_pn5_strength , last_psmm_pn5_onewaydelay , last_psmm_pn5_keep , last_psmm_pn5_pilotset , last_psmm_cell6 , last_psmm_sector6 , last_psmm_pn6_strength , last_psmm_pn6_onewaydelay , last_psmm_pn6_keep , last_psmm_pn6_pilotset , first_sho_fail_time , first_sho_fail_cause , last_ho_block_time , last_ho_block_cause , last_ho_block_pn_count , last_ho_block_pn , last_sho_fail_time , last_sho_fail_cause , one_pilot_count , one_pilot_duration , two_pilots_count , two_pilot_duration , three_pilots_count , threr_pilot_duration , four_pilots_count , four_pilot_duration , five_pilots_count , five_pilot_duration , six_pilots_count , six_pilot_duration , psmm_received_count , ppsmm_received_count , sho_count , sho_fail_count , loc_s_add_count , loc_s_add_fail_count , loc_sr_add_count , loc_sr_add_fail_count , loc_s_drop_count , loc_s_drop_fail_count , loc_sr_drop_count , loc_sr_drop_fail_count , ext_s_add_count , ext_s_add_fail_count , ext_s_drop_count , ext_s_drop_fail_count , hho_type , hho_tgt_freq , hho_tgt_count , hho_tgt1_market_id , hho_tgt1_switch_numeric , hho_tgt1_cell , hho_tgt1_sector , hho_tgt2_cell , hho_tgt2_sector , hho_tgt3_cell , hho_tgt3_sector , hho_result , hho_maho_time , hho_maho_act_count , hho_maho_act_str , hho_maho_pn_count , hho_maho_cell1 , hho_maho_sector1 , hho_maho_pn1_strength , hho_maho_pn1_onewaydelay , hho_maho_pn1_pilotset , hho_maho_cell2 , hho_maho_sector2 , hho_maho_pn2_strength , hho_maho_pn2_onewaydelay , hho_maho_pn2_pilotset , hho_maho_cell3 , hho_maho_sector3 , hho_maho_pn3_strength , hho_maho_pn3_onewaydelay , hho_maho_pn3_pilotset , hho_maho_cell4 , hho_maho_sector4 , hho_maho_pn4_strength , hho_maho_pn4_onewaydelay , hho_maho_pn4_pilotset , hho_maho_cell5 , hho_maho_sector5 , hho_maho_pn5_strength , hho_maho_pn5_onewaydelay , hho_maho_pn5_pilotset , hho_maho_cell6 , hho_maho_sector6 , hho_maho_pn6_strength , hho_maho_pn6_onewaydelay , hho_maho_pn6_pilotset , ics_count , ics_fail_count ,ics_begin_time ,ics_begin_tgt_count , ics_begin_src_count , ics_begin_tgt_cell , ics_begin_tgt_sector , ics_begin_src1_cell , ics_begin_src1_sector , ics_begin_src2_cell , ics_begin_src2_sector , ics_end_time , ics_end_tgt_count , ics_end_src_count , ics_end_tgt_cell , ics_end_tgt_sector , ics_end_src1_cell , ics_end_src1_sector , ics_end_src2_cell , ics_end_src2_sector , sch_fwd_rc3_cap , sch_fwd_rc4_cap , sch_fwd_dynamic_apply_count , sch_fwd_extend_apply_count , sch_fwd_release_apply_count , sch_fwd_upgrade_rate_count , sch_fwd_lower_rate_count , sch_fwd_keep_rate_count , sch_fwd_1x_req_up_rate , sch_fwd_2x_sch_up_rate , sch_fwd_4x_sch_up_rate , sch_fwd_8x_sch_up_rate , sch_fwd_16x_sch_up_rate , pilot_0_3_duration , pilot_3_6_duration , pilot_6_9_duration , pilot_9_15_duration , pilot_15_32_duration , sdrop_count , last_sdrop_time , fwd_fch_assigned_rc_type , rev_ratereduction , rev_tch_target_fer , rrm_reserved , voice_abnormal_fmr , pwr_abnormal_flag , abnormal_flag_rsvd , dpus_cpu_id , dsp_id , dsp_occupancy , voice_count_per_dsp , data_count_per_dsp , eib_count , bytes_fwd , bytes_rvs , is_only_eighth_frame_up , is_only_eighth_frame_down , is_trau_to_mux_msg_fail , is_trau_to_tc_msg_fail , is_mux_to_trau_msg_fail , is_mux_to_fpmdc_msg_fail , is_fpmdc_to_mux_msg_fail , is_fpmdc_to_bts_msg_fail , only_eighth_frame_up_count , only_eighth_frame_down_count , time_adjust_abnormal_count , rev_errframe , rev_sch_errframe , fer_3_percent_count , fer_3_to_7_percent_count , fer_7_to_15_percent_count , fer_over_15_percent_count , fwd_lostt_on_sig_3_rate , fwd_lostt_on_sig_3_to_7 , fwd_lostt_on_sig_7_to_15 , fwd_lostt_on_sig_over_15 , rev_frame_all_sig_3 , rev_frame_all_sig_3_to_7 , rev_frame_all_sig_7_to_15 , rev_frame_all_sig_over_15 , rx_frame_from_tc_1_percent , rx_frame_from_tc_2_percent , rx_frame_from_tc_4_percent , rx_frame_from_tc_8_percent , rx_frame_from_tc_null , rx_frame_from_tc_other , tx_frame_to_tc_1_percent , tx_frame_to_tc_2_percent , tx_frame_to_tc_4_percent , tx_frame_to_tc_8_percent , tx_frame_to_tc_null , tx_frame_to_tc_other , sch_rev_1x_average_fer , sch_rev_2x_average_fer , sch_rev_4x_average_fer , sch_rev_8x_average_fer , sch_rev_16x_average_fer , sch_rev_32x_average_fer , sig_leg_pwr_rev_higa_count , ppp_session_on , ppu_rp_frame_number , ppu_rp_slot_number ,bpu_rp_frame_number from mod_cdr_hw where imsi="460036271583050";
----------------------------------------------------------------------------------------------------------------------------
19) select * from mod_cdr_hw where imsi="460036271583050";
3、測試結果3.1串行測試
3.1.1 行存儲模式3.1.1.1 數據入庫測試3.1.1.1.1 數據表無索引下面是基準表（一倍容量）的情況：
3.1.1.1.2 數據表有索引3.1.1.2 系統性能指標入庫時的性能指標（錄像/截屏）-----針對無索引的數據入庫
3.1.1.2.1 master hosttable: mod_cdr_hw
/tmp/nmonreport/mdw-3112-cdr.txt
CPU
DISK
MEMORY
NetWork
table: mod_do_hw
/tmp/nmonreport/mdw-3112-do.txt
CPU
DISK
MEMORY
NETWORK
3.1.1.2.2 segment host ---sdw1table: mod_cdr_hw
/tmp/sdw1-3112-cdr.txt
CPU
DISK
MEMORY
NETWORK
table: mod_do_hw
/tmp/sdw1-3112-do.txt
CPU
DISK
MEMORY
NETWORK
3.1.1.2.3 segment host ---sdw2table: mod_cdr_hw
/tmp/sdw2-3112-cdr.txt
CPU
DISK
MEMORY
NETWORK
table: mod_do_hw
/tmp/sdw2-3112-do.txt
CPU
DISK
MEMORY
NETWORK
3.1.1.2.4 segment host ---sdw3table: mod_cdr_hw
/tmp/sdw3-3112-cdr.txt
CPU
DISK
MEMORY
NETWORK
table: mod_do_hw
/tmp/sdw3-3112-do.txt
CPU
DISK
MEMORY
NETWORK
3.1.1.2.5 segment host ---sdw4table: mod_cdr_hw
/tmp/sdw4-3112-cdr.txt
CPU
DISK
MEMORY
NETWORK
table: mod_do_hw
/tmp/sdw4-3112-do.txt
CPU
DISK
MEMORY
NETWORK
3.1.1.3 查詢性能指標3.1.1.3.1 數據表無索引3.1.1.3.2 數據表有索引create index ind_r_mod_cdr_hw on r_mod_cdr_hw(imsi);
耗時：24.7s
所占空間：838MB
create index ind_r_mod_cdr_hw_accesscell on r_mod_cdr_hw(access_cell);
耗時：17.3s
所占空間：597MB
create index ind_r_mod_cdr_hw_release_cfc on r_mod_cdr_hw(release_cfc);
耗時：20.4s
所占空間：597MB
create index ind_r_mod_do_hw_imsi on r_mod_do_hw(imsi);
耗時：51.4s
所占空間：2177MB
以下是針對有索引字段查詢時生成的執行計劃
uway=# explain analyze select * from r_mod_cdr_hw where access_time > To_Date("2010-12-28 00:00:00", "yyyy-mm-dd hh24:mi:ss") and access_time < To_Date("2010-12-29 00:00:00", "yyyy-mm-dd hh24:mi:ss") and access_cell=1039;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice1; segments: 32) (cost=0.00..1424419.48 rows=31 width=4420)
Rows out: 28657 rows at destination with 34 ms to first row, 16928 ms to end, start offset by 6.379 ms.
-> Append-only Scan on r_mod_cdr_hw (cost=0.00..1424419.48 rows=31 width=4420)
Filter: access_time::text > "2010-12-28"::text AND access_time::text < "2010-12-29"::text AND access_cell = 1039::numeric
Rows out: Avg 895.5 rows x 32 workers. Max 946 rows (seg15) with 75 ms to first row, 16229 ms to end, start offset by 211
1344 ms.
Slice statistics:
(slice0) Executor memory: 964K bytes.
(slice1) Executor memory: 1214K bytes avg x 32 workers, 1214K bytes max (seg0).
Statement statistics:
Memory used: 128000K bytes
Total runtime: 16941.112 ms
(11 rows)
Time: 16952.889 ms
uway=# explain analyze select * from r_mod_cdr_hw where access_time > To_Date("2010-12-28 00:00:00", "yyyy-mm-dd hh24:mi:ss") and access_time < To_Date("2010-12-29 00:00:00", "yyyy-mm-dd hh24:mi:ss") and release_cfc="4";
QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice1; segments: 32) (cost=0.00..1424419.48 rows=270 width=4420)
Rows out: 197344 rows at destination with 58 ms to first row, 19174 ms to end, start offset by 6.256 ms.
-> Append-only Scan on r_mod_cdr_hw (cost=0.00..1424419.48 rows=270 width=4420)
Filter: access_time::text > "2010-12-28"::text AND access_time::text < "2010-12-29"::text AND release_cfc = 4::numeric
Rows out: Avg 6167.0 rows x 32 workers. Max 6340 rows (seg28) with 78 ms to first row, 15840 ms to end, start offset by -
32230036278 ms.
Slice statistics:
(slice0) Executor memory: 964K bytes.
(slice1) Executor memory: 1214K bytes avg x 32 workers, 1214K bytes max (seg0).
Statement statistics:
Memory used: 128000K bytes
Total runtime: 19222.335 ms
(11 rows)
Time: 19227.216 ms
uway=# explain analyze select * from r_mod_cdr_hw where access_time > To_Date("2010-12-28 00:00:00", "yyyy-mm-dd hh24:mi:ss") and access_time < To_Date("2010-12-29 00:00:00", "yyyy-mm-dd hh24:mi:ss") and imsi="460036271583050";
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice1; segments: 32) (cost=128.28..16021.83 rows=1 width=4420)
Rows out: 3725 rows at destination with 195 ms to first row, 10714 ms to end, start offset by 6.140 ms.
-> Bitmap Append-Only Row-Oriented Scan on r_mod_cdr_hw (cost=128.28..16021.83 rows=1 width=4420)
Recheck Cond: imsi = "460036271583050"::bpchar
Filter: access_time::text > "2010-12-28"::text AND access_time::text < "2010-12-29"::text
Rows out: Avg 116.4 rows x 32 workers. Max 149 rows (seg25) with 430 ms to first row, 4784 ms to end, start offset by -32
230036147 ms.
-> Bitmap Index Scan on ind_r_mod_cdr_hw (cost=0.00..128.27 rows=6 width=0)
Index Cond: imsi = "460036271583050"::bpchar
Bitmaps out: Avg 1.0 x 32 workers. Max 1 (seg0) with 35 ms to end, start offset by -7563 ms.
Work_mem used: 56K bytes avg, 89K bytes max (seg0).
Slice statistics:
(slice0) Executor memory: 1003K bytes.
(slice1) Executor memory: 1928K bytes avg x 32 workers, 1928K bytes max (seg0). Work_mem: 89K bytes max.
Statement statistics:
Memory used: 128000K bytes
Total runtime: 10721.569 ms
(16 rows)
Time: 10726.714 ms
uway=# explain analyze select b.* from r_mod_cdr_hw b, r_ne_cell_c c where access_cell=1038 and c.ne_sys_id = b.related_cell;
QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice2; segments: 32) (cost=1284532.87..1314248.15 rows=517 width=4420)
Rows out: 22229 rows at destination with 14969 ms to first row, 17523 ms to end, start offset by 4814 ms.
-> Hash Join (cost=1284532.87..1314248.15 rows=517 width=4420)
Hash Cond: c.ne_sys_id = b.related_cell
Rows out: Avg 694.7 rows x 32 workers. Max 755 rows (seg25) with 14841 ms to first row, 15403 ms to end, start offset by
-32230031362 ms.
Executor memory: 3124K bytes avg, 3388K bytes max (seg25).
Work_mem used: 3124K bytes avg, 3388K bytes max (seg25).
(seg25) Hash chain length 125.8 avg, 267 max, using 6 of 4111 buckets.
-> Broadcast Motion 32:32 (slice1; segments: 32) (cost=0.00..22982.72 rows=65558 width=12)
Rows out: Avg 65558.0 rows x 32 workers at destination. Max 65558 rows (seg0) with 0.064 ms to first row, 128 ms to
end, start offset by 12298 ms.
-> Seq Scan on r_ne_cell_c c (cost=0.00..1348.58 rows=2049 width=12)
Rows out: Avg 2048.7 rows x 32 workers. Max 2056 rows (seg17) with 352 ms to first row, 353 ms to end, start
offset by 8921 ms.
-> Hash (cost=1284326.20..1284326.20 rows=517 width=4420)
Rows in: Avg 694.7 rows x 32 workers. Max 755 rows (seg25) with 14825 ms to end, start offset by -32230031362 ms.
-> Append-only Scan on r_mod_cdr_hw b (cost=0.00..1284326.20 rows=517 width=4420)
Filter: access_cell = 1038::numeric
Rows out: Avg 694.7 rows x 32 workers. Max 755 rows (seg25) with 67 ms to first row, 14821 ms to end, start o
ffset by -32230031362 ms.
Slice statistics:
(slice0) Executor memory: 2135K bytes.
(slice1) Executor memory: 1429K bytes avg x 32 workers, 1429K bytes max (seg0).
(slice2) Executor memory: 10231K bytes avg x 32 workers, 10231K bytes max (seg0). Work_mem: 3388K bytes max.
Statement statistics:
Memory used: 128000K bytes
Total runtime: 22341.101 ms
(24 rows)
Time: 22347.867 ms
uway=# explain analyze select * from r_mod_do_hw where imsi="460036101389257";
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice1; segments: 32) (cost=387.82..223363.61 rows=73 width=2758)
Rows out: 120 rows at destination with 77 ms to first row, 383 ms to end, start offset by 3.469 ms.
-> Bitmap Append-Only Row-Oriented Scan on r_mod_do_hw (cost=387.82..223363.61 rows=73 width=2758)
Recheck Cond: imsi = "460036101389257"::bpchar
Rows out: Avg 3.8 rows x 32 workers. Max 7 rows (seg4) with 221 ms to first row, 282 ms to end, start offset by -7640 ms.
-> Bitmap Index Scan on ind_r_mod_do_hw_imsi (cost=0.00..387.24 rows=73 width=0)
Index Cond: imsi = "460036101389257"::bpchar
Bitmaps out: Avg 1.0 x 32 workers. Max 1 (seg0) with 151 ms to end, start offset by -7641 ms.
Work_mem used: 28K bytes avg, 57K bytes max (seg4).
Slice statistics:
(slice0) Executor memory: 785K bytes.
(slice1) Executor memory: 1474K bytes avg x 32 workers, 1513K bytes max (seg0). Work_mem: 57K bytes max.
Statement statistics:
Memory used: 128000K bytes
Total runtime: 392.537 ms
(15 rows)
Time: 399.117 ms
3.1.2 列存儲模式3.1.2.1數據入庫測試3.1.2.1.1數據表無索引下面是基準表（一倍容量）的情況：
3.1.2.1.2數據表有索引下面是基準表（一倍容量）的情況：
3.1.2.2 系統性能指標入庫時的性能指標（錄像/截屏）-----針對無索引的數據入庫
3.1.2.2.1 master hosttable: mod_cdr_hw
/tmp/nmonreport/mdw-3122-cdr.txt
CPU
DISK
MEMORY
NETWORK
table: mod_do_hw
/tmp/nmonreport/mdw-3122-do.txt
CPU
DISK
MEMORY
NETWORK
3.1.2.2.2 segment host ---sdw1table: mod_cdr_hw
/tmp/sdw1-3122-cdr.txt
CPU
DISK
MEMORY
NETWORK
table: mod_do_hw
/tmp/sdw1-3122-do.txt
CPU
DISK
MEMORY
NETWORK
3.1.2.2.3 segment host ---sdw2table: mod_cdr_hw
/tmp/sdw2-3122-cdr.txt
CPU
DISK
MEMORY
NETWORK
table: mod_do_hw
/tmp/sdw2-3122-do.txt
監控與上類似，在此省略。
3.1.2.2.4 segment host ---sdw3table: mod_cdr_hw
/tmp/sdw3-3122-cdr.txt
CPU
DISK
MEMORY
NETWORK
table: mod_do_hw
/tmp/sdw3-3122-do.txt
監控與上類似，在此省略。
3.1.2.2.5 segment host ---sdw4table: mod_cdr_hw
/tmp/sdw4-3122-cdr.txt
CPU
DISK
MEMORY
NETWORK
table: mod_do_hw
/tmp/sdw4-3122-do.txt
監控與上類似，在此省略。
3.1.2.3 查詢性能指標3.1.2.3.1 數據表無索引以下是查詢耗時最長的執行計劃：
12: Gather Motion 32:1 (slice3; segments: 32) (cost=529.46..6935218.25 rows=593 width=7673)
Rows out: 54770 rows at destination with 730 ms to first row, 52948 ms to end, start offset by 278 ms.
-> Hash Join (cost=529.46..6935218.25 rows=593 width=7673)
Hash Cond: b.related_cell = c.ne_sys_id
Rows out: Avg 18256.7 rows x 3 workers. Max 24720 rows (seg20) with 681 ms to first row, 21538 ms to end, start offset by
4691 ms.
Executor memory: 92K bytes avg, 102K bytes max (seg10).
Work_mem used: 92K bytes avg, 102K bytes max (seg10).
(seg10) Hash chain length 1.0 avg, 2 max, using 337 of 4111 buckets.
(seg20) Hash chain length 1.0 avg, 3 max, using 318 of 4111 buckets.
-> Redistribute Motion 32:32 (slice1; segments: 32) (cost=0.00..6934389.69 rows=777 width=2757)
Hash Key: b.related_cell
Rows out: Avg 18256.7 rows x 3 workers at destination. Max 24720 rows (seg20) with 396 ms to first row, 20063 ms to
end, start offset by 4977 ms.
-> Append-only Columnar Scan on mod_do_hw b (cost=0.00..6933892.60 rows=777 width=2757)
Filter: related_bts = 1080010000032000::numeric
Rows out: Avg 1711.6 rows x 32 workers. Max 1778 rows (seg3) with 679 ms to first row, 51865 ms to end, start
offset by -6521 ms.
-> Hash (cost=401.97..401.97 rows=319 width=4916)
Rows in: Avg 318.7 rows x 32 workers. Max 353 rows (seg10) with 140 ms to end, start offset by 1878796 ms.
-> Redistribute Motion 32:32 (slice2; segments: 32) (cost=0.00..401.97 rows=319 width=4916)
Hash Key: c.ne_sys_id
Rows out: Avg 318.7 rows x 32 workers at destination. Max 353 rows (seg10) with 0.071 ms to first row, 138 ms
to end, start offset by 1878796 ms.
-> Seq Scan on r_ne_cell_c_bj c (cost=0.00..197.99 rows=319 width=4916)
Rows out: Avg 318.7 rows x 32 workers. Max 324 rows (seg5) with 0.072 ms to first row, 0.150 ms to end,
start offset by -6519 ms.
Slice statistics:
(slice0) Executor memory: 1594K bytes.
(slice1) Executor memory: 61003K bytes avg x 32 workers, 61003K bytes max (seg7).
(slice2) Executor memory: 1583K bytes avg x 32 workers, 1583K bytes max (seg0).
(slice3) Executor memory: 1569K bytes avg x 32 workers, 1627K bytes max (seg0). Work_mem: 102K bytes max.
Statement statistics:
Memory used: 128000K bytes
Total runtime: 53235.824 ms
(30 rows)
Time: 53240.630 ms
3.1.2.3.2 數據表有索引create index ind_mod_cdr_hw on mod_cdr_hw(imsi);
耗時：47s
所占空間：838MB
create index ind_mod_cdr_hw_accesscell on mod_cdr_hw(access_cell);
耗時：9s
所占空間：597MB
create index ind_mod_cdr_hw_release_cfc on mod_cdr_hw(release_cfc);
耗時：2s
所占空間：597MB
create index ind_mod_do_hw_imsi on mod_do_hw(imsi);
耗時：81.5s
所占空間：2177MB
以下是針對有索引字段查詢時生成的執行計劃：
uway=# explain analyze select * from mod_cdr_hw where access_time > To_Date("2010-12-28 00:00:00", "yyyy-mm-dd hh24:mi:ss") and access_time < To_Date("2010-12-29 00:00:00", "yyyy-mm-dd hh24:mi:ss") and access_cell=1039;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice1; segments: 32) (cost=1345.24..1535922.24 rows=31 width=4421)
Rows out: 28657 rows at destination with 228 ms to first row, 12018 ms to end, start offset by 99 ms.
-> Bitmap Append-Only Column-Oriented Scan on mod_cdr_hw (cost=1345.24..1535922.24 rows=31 width=4421)
Recheck Cond: access_cell = 1039::numeric
Filter: access_time::text > "2010-12-28"::text AND access_time::text < "2010-12-29"::text
Rows out: Avg 895.5 rows x 32 workers. Max 960 rows (seg6) with 216 ms to first row, 11442 ms to end, start offset by -76
72 ms.
-> Bitmap Index Scan on ind_mod_cdr_hw_accesscell (cost=0.00..1344.99 rows=524 width=0)
Index Cond: access_cell = 1039::numeric
Bitmaps out: Avg 1.0 x 32 workers. Max 1 (seg0) with 0.932 ms to end, start offset by -7659 ms.
Work_mem used: 218K bytes avg, 218K bytes max (seg0).
Slice statistics:
(slice0) Executor memory: 1003K bytes.
(slice1) Executor memory: 96457K bytes avg x 32 workers, 96457K bytes max (seg0). Work_mem: 218K bytes max.
Statement statistics:
Memory used: 128000K bytes
Total runtime: 12121.626 ms
(16 rows)
Time: 12126.295 ms
uway=# explain analyze select * from mod_cdr_hw where access_time > To_Date("2010-12-28 00:00:00", "yyyy-mm-dd hh24:mi:ss") and access_time < To_Date("2010-12-29 00:00:00", "yyyy-mm-dd hh24:mi:ss") and release_cfc="4";
QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice1; segments: 32) (cost=0.00..2981525.48 rows=236 width=4421)
Rows out: 197344 rows at destination with 6987 ms to first row, 43425 ms to end, start offset by 96 ms.
-> Append-only Columnar Scan on mod_cdr_hw (cost=0.00..2981525.48 rows=236 width=4421)
Filter: access_time::text > "2010-12-28"::text AND access_time::text < "2010-12-29"::text AND release_cfc = 4::numeric
Rows out: Avg 6167.0 rows x 32 workers. Max 6297 rows (seg29) with 11408 ms to first row, 42316 ms to end, start offset b
y -32230036097 ms.
Slice statistics:
(slice0) Executor memory: 964K bytes.
(slice1) Executor memory: 90623K bytes avg x 32 workers, 90623K bytes max (seg0).
Statement statistics:
Memory used: 128000K bytes
Total runtime: 43564.882 ms
(11 rows)
Time: 43569.843 ms
uway=# explain analyze select * from mod_cdr_hw where access_time > To_Date("2010-12-28 00:00:00", "yyyy-mm-dd hh24:mi:ss") and access_time < To_Date("2010-12-29 00:00:00", "yyyy-mm-dd hh24:mi:ss") and imsi="460036271583050";
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice1; segments: 32) (cost=128.34..16992.27 rows=1 width=4421)
Rows out: 3725 rows at destination with 7013 ms to first row, 15510 ms to end, start offset by 3488 ms.
-> Bitmap Append-Only Column-Oriented Scan on mod_cdr_hw (cost=128.34..16992.27 rows=1 width=4421)
Recheck Cond: imsi = "460036271583050"::bpchar
Filter: access_time::text > "2010-12-28"::text AND access_time::text < "2010-12-29"::text
Rows out: Avg 116.4 rows x 32 workers. Max 141 rows (seg18) with 10864 ms to first row, 13703 ms to end, start offset by
7275 ms.
-> Bitmap Index Scan on ind_mod_cdr_hw (cost=0.00..128.33 rows=6 width=0)
Index Cond: imsi = "460036271583050"::bpchar
Bitmaps out: Avg 1.0 x 32 workers. Max 1 (seg0) with 38 ms to end, start offset by -4195 ms.
Work_mem used: 57K bytes avg, 81K bytes max (seg21).
Slice statistics:
(slice0) Executor memory: 1003K bytes.
(slice1) Executor memory: 96448K bytes avg x 32 workers, 96457K bytes max (seg0). Work_mem: 81K bytes max.
Statement statistics:
Memory used: 128000K bytes
Total runtime: 18999.447 ms
(16 rows)
Time: 19004.289 ms
uway=# explain analyze select b.* from mod_cdr_hw b, r_ne_cell_c c where access_cell=1038 and c.ne_sys_id = b.related_cell;
QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice2; segments: 32) (cost=1536051.82..1565786.65 rows=524 width=4421)
Rows out: 22229 rows at destination with 19118 ms to first row, 25332 ms to end, start offset by 5465 ms.
-> Hash Join (cost=1536051.82..1565786.65 rows=524 width=4421)
Hash Cond: c.ne_sys_id = b.related_cell
Rows out: Avg 694.7 rows x 32 workers. Max 739 rows (seg8) with 19064 ms to first row, 23954 ms to end, start offset by 2
116851 ms.
Executor memory: 3124K bytes avg, 3339K bytes max (seg8).
Work_mem used: 3124K bytes avg, 3339K bytes max (seg8).
(seg8) Hash chain length 123.2 avg, 275 max, using 6 of 2063 buckets.
-> Broadcast Motion 32:32 (slice1; segments: 32) (cost=0.00..22982.72 rows=65558 width=12)
Rows out: Avg 65558.0 rows x 32 workers at destination. Max 65558 rows (seg0) with 0.104 ms to first row, 1880 ms t
o end, start offset by 20249 ms.
-> Seq Scan on r_ne_cell_c c (cost=0.00..1348.58 rows=2049 width=12)
Rows out: Avg 2048.7 rows x 32 workers. Max 2056 rows (seg17) with 38 ms to first row, 40 ms to end, start of
fset by 9297 ms.
-> Hash (cost=1535842.42..1535842.42 rows=524 width=4421)
Rows in: Avg 694.7 rows x 32 workers. Max 739 rows (seg8) with 19013 ms to end, start offset by 2116886 ms.
-> Bitmap Append-Only Column-Oriented Scan on mod_cdr_hw b (cost=1349.18..1535842.42 rows=524 width=4421)
Recheck Cond: access_cell = 1038::numeric
Rows out: Avg 694.7 rows x 32 workers. Max 739 rows (seg8) with 7354 ms to first row, 18904 ms to end, start
offset by 2116886 ms.
-> Bitmap Index Scan on ind_mod_cdr_hw_accesscell (cost=0.00..1344.99 rows=524 width=0)
Index Cond: access_cell = 1038::numeric
Bitmaps out: Avg 1.0 x 32 workers. Max 1 (seg0) with 15 ms to end, start offset by -2131 ms.
Work_mem used: 218K bytes avg, 218K bytes max (seg0).
Slice statistics:
(slice0) Executor memory: 2173K bytes.
(slice1) Executor memory: 1429K bytes avg x 32 workers, 1429K bytes max (seg0).
(slice2) Executor memory: 104917K bytes avg x 32 workers, 104930K bytes max (seg3). Work_mem: 3339K bytes max.
Statement statistics:
Memory used: 128000K bytes
Total runtime: 30802.399 ms
(28 rows)
Time: 30824.174 ms
uway=# explain analyze select * from mod_do_hw where imsi="460036101389257";
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice1; segments: 32) (cost=387.83..227131.54 rows=73 width=2757)
Rows out: 120 rows at destination with 5782 ms to first row, 19279 ms to end, start offset by 3269 ms.
-> Bitmap Append-Only Column-Oriented Scan on mod_do_hw (cost=387.83..227131.54 rows=73 width=2757)
Recheck Cond: imsi = "460036101389257"::bpchar
Rows out: Avg 3.9 rows x 31 workers. Max 8 rows (seg4) with 8044 ms to first row, 18427 ms to end, start offset by -4377
ms.
-> Bitmap Index Scan on ind_mod_do_hw_imsi (cost=0.00..387.25 rows=73 width=0)
Index Cond: imsi = "460036101389257"::bpchar
Bitmaps out: Avg 1.0 x 32 workers. Max 1 (seg0) with 79 ms to end, start offset by -4367 ms.
Work_mem used: 27K bytes avg, 57K bytes max (seg4).
Slice statistics:
(slice0) Executor memory: 785K bytes.
(slice1) Executor memory: 61909K bytes avg x 32 workers, 62461K bytes max (seg3). Work_mem: 57K bytes max.
Statement statistics:
Memory used: 128000K bytes
Total runtime: 22548.456 ms
(15 rows)
Time: 22556.316 ms
3.2并行測試（沒有數據入庫，只有并行查詢）
3.2.1 行存儲模式3.2.1.1 模擬并發5用戶3.2.1.1.1 數據表無索引● sql-1 情況：
● sql-2 情況：
3.2.1.1.2 數據表有索引ind_r_mod_cdr_hw on r_mod_cdr_hw(imsi); 所占空間：838MB
ind_r_mod_cdr_hw_accesscell on r_mod_cdr_hw(access_cell); 所占空間：597MB
ind_r_mod_cdr_hw_release_cfc on r_mod_cdr_hw(release_cfc); 所占空間：597MB
ind_r_mod_do_hw_imsi on r_mod_do_hw(imsi); 所占空間：2177MB
Session 3執行的sql:
QUERY PLAN -------------------------------------------------------------------------------------------------------------------------- Gather Motion 32:1 (slice1; segments: 32) (cost=0.00..1424419.48 rows=270 width=4420)
Rows out: 197344 rows at destination with 0.038 ms to first row, 104425 ms to end, start offset by 690 ms.
-> Append-only Scan on r_mod_cdr_hw (cost=0.00..1424419.48 rows=270 width=4420)
Filter: access_time::text > "2010-12-28"::text AND access_time::text < "2010-12-29"::text AND release_cfc = 4::numeric
Rows out: Avg 6167.0 rows x 32 workers. Max 6340 rows (seg28) with 4.797 ms to first row, 53403 ms to end, start offset by -32230035716 ms.
Slice statistics:
(slice0) Executor memory: 964K bytes.
(slice1) Executor memory: 1214K bytes avg x 32 workers, 1214K bytes max (seg0).
Statement statistics:
Memory used: 128000K bytes
Total runtime: 105161.289 ms
(11 rows)
Session 5執行的sql:
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice1; segments: 32) (cost=387.82..223363.61 rows=73 width=2758)
Rows out: 120 rows at destination with 6.923 ms to first row, 383 ms to end, start offset by 654 ms.
-> Bitmap Append-Only Row-Oriented Scan on r_mod_do_hw (cost=387.82..223363.61 rows=73 width=2758)
Recheck Cond: imsi = "460036101389257"::bpchar
Rows out: Avg 3.8 rows x 32 workers. Max 7 rows (seg4) with 41 ms to first row, 105 ms to end, start offset by -6914 ms.
-> Bitmap Index Scan on ind_r_mod_do_hw_imsi (cost=0.00..387.24 rows=73 width=0)
Index Cond: imsi = "460036101389257"::bpchar
Bitmaps out: Avg 1.0 x 32 workers. Max 1 (seg0) with 0.269 ms to end, start offset by -6916 ms.
Work_mem used: 28K bytes avg, 57K bytes max (seg4).
Slice statistics:
(slice0) Executor memory: 785K bytes.
(slice1) Executor memory: 1475K bytes avg x 32 workers, 1513K bytes max (seg0). Work_mem: 57K bytes max.
Statement statistics:
Memory used: 128000K bytes
Total runtime: 1044.431 ms
(15 rows)
3.2.1.1.3 系統性能指標性能指標（錄像/截屏）-----針對無索引時的并行查詢
3.2.1.1.3.1 master host/tmp/nmonreport/mdw-3211-sql-1.txt
CPU
DISK
MEMORY
NETWORK
3.2.1.1.3.2 segment host---sdw1/tmp/sdw1-3211-sql-1.txt
CPU
DISK
MEMORY
NETWORK
3.2.1.1.3.3 segment host---sdw2/tmp/sdw2-3211-sql-1.txt
CPU
DISK
MEMORY
NETWORK
3.2.1.1.3.4 segment host---sdw3/tmp/sdw3-3211-sql-1.txt
CPU
DISK
MEMORY
NETWORK
3.2.1.1.3.5 segment host---sdw4/tmp/sdw4-3211-sql-1.txt
CPU
DISK
MEMORY
NETWORK
3.2.1.2 模擬并發10用戶3.2.1.2.1數據表無索引● sql-1 情況：
● sql-2 情況(根據測試情況來看，此部分已略掉，結果可參考并發5用戶)：
3.2.1.2.2數據表有索引---未測試可參考 3.2.1.1.2節 模擬并發5用戶—數據表有索引部分的測試結果。
3.2.1.2.3 系統性能指標性能指標（錄像/截屏）-----針對無索引時的并行查詢
3.2.1.2.3.1 master host/tmp/nmonreport/mdw-3212-sql-1.txt
CPU
DISK
MEMORY
NETWORK
3.2.1.2.3.2 segment host---sdw1/tmp/sdw1-3212-sql-1.txt
CPU
DISK
MEMORY
NETWORK
3.2.1.2.3.3 segment host---sdw2/tmp/sdw2-3212-sql-1.txt
CPU
DISK
MEMORY
NETWORK
3.2.1.2.3.4 segment host---sdw3/tmp/sdw3-3212-sql-1.txt
CPU
DISK
可參考sdw2的圖例，與之類似。
MEMORY
NETWORK
可參考sdw2的圖例，與之類似。
3.2.1.2.3.5 segment host---sdw4/tmp/sdw4-3212-sql-1.txt
CPU
DISK
可參考sdw2的圖例，與之類似。
MEMORY
NETWORK
可參考sdw2的圖例，與之類似。
3.2.2 列存儲模式3.2.2.1 模擬并發5用戶3.2.2.1.1 數據表無索引● sql-1 情況：
● sql-2 情況：
3.2.2.1.2 數據表有索引ind_mod_cdr_hw on mod_cdr_hw(imsi); 所占空間：838MB
ind_mod_cdr_hw_accesscell on mod_cdr_hw(access_cell); 所占空間：597MB
ind_mod_cdr_hw_release_cfc on mod_cdr_hw(release_cfc); 所占空間：597MB
ind_mod_do_hw_imsi on mod_do_hw(imsi); 所占空間：2177MB
Session1執行的sql:
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice2; segments: 32) (cost=1536051.82..1565786.65 rows=524 width=4421)
Rows out: 22229 rows at destination with 37454 ms to first row, 63142 ms to end, start offset by 4905 ms.
-> Hash Join (cost=1536051.82..1565786.65 rows=524 width=4421)
Hash Cond: c.ne_sys_id = b.related_cell
Rows out: Avg 694.7 rows x 32 workers. Max 739 rows (seg8) with 41787 ms to first row, 61068 ms to end, start offset by 2116684 ms.
Executor memory: 3124K bytes avg, 3339K bytes max (seg8).
Work_mem used: 3124K bytes avg, 3339K bytes max (seg8).
(seg8) Hash chain length 123.2 avg, 275 max, using 6 of 2063 buckets.
-> Broadcast Motion 32:32 (slice1; segments: 32) (cost=0.00..22982.72 rows=65558 width=12)
Rows out: Avg 65558.0 rows x 32 workers at destination. Max 65558 rows (seg0) with 0.100 ms to first row, 11041 ms to end, start offset by 47458 ms.
-> Seq Scan on r_ne_cell_c c (cost=0.00..1348.58 rows=2049 width=12)
Rows out: Avg 2048.7 rows x 32 workers. Max 2056 rows (seg17) with 0.039 ms to first row, 0.903 ms to end, start offset by 9736 ms.
-> Hash (cost=1535842.42..1535842.42 rows=524 width=4421)
Rows in: Avg 694.7 rows x 32 workers. Max 739 rows (seg8) with 41751 ms to end, start offset by 2116684 ms.
-> Bitmap Append-Only Column-Oriented Scan on mod_cdr_hw b (cost=1349.18..1535842.42 rows=524 width=4421)
Recheck Cond: access_cell = 1038::numeric
Rows out: Avg 694.7 rows x 32 workers. Max 739 rows (seg8) with 12136 ms to first row, 41469 ms to end, start offset by 2116684 ms.
-> Bitmap Index Scan on ind_mod_cdr_hw_accesscell (cost=0.00..1344.99 rows=524 width=0)
Index Cond: access_cell = 1038::numeric
Bitmaps out: Avg 1.0 x 32 workers. Max 1 (seg0) with 0.541 ms to end, start offset by -2120 ms.
Work_mem used: 218K bytes avg, 218K bytes max (seg0).
Slice statistics:
(slice0) Executor memory: 2173K bytes.
(slice1) Executor memory: 1429K bytes avg x 32 workers, 1429K bytes max (seg0).
(slice2) Executor memory: 104917K bytes avg x 32 workers, 104930K bytes max (seg3). Work_mem: 3339K bytes max.
Statement statistics:
Memory used: 128000K bytes
Total runtime: 68051.518 ms
(28 rows)
Session4執行的sql:
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------
Gather Motion 32:1 (slice1; segments: 32) (cost=387.83..227131.54 rows=73 width=2757)
Rows out: 120 rows at destination with 10520 ms to first row, 24830 ms to end, start offset by 1764 ms.
-> Bitmap Append-Only Column-Oriented Scan on mod_do_hw (cost=387.83..227131.54 rows=73 width=2757)
Recheck Cond: imsi = "460036101389257"::bpchar
Rows out: Avg 3.9 rows x 31 workers. Max 8 rows (seg4) with 11110 ms to first row, 21384 ms to end, start offset by -5768 ms.
-> Bitmap Index Scan on ind_mod_do_hw_imsi (cost=0.00..387.25 rows=73 width=0)
Index Cond: imsi = "460036101389257"::bpchar
Bitmaps out: Avg 1.0 x 32 workers. Max 1 (seg0) with 0.646 ms to end, start offset by -5640 ms.
Work_mem used: 27K bytes avg, 57K bytes max (seg4).
Slice statistics:
(slice0) Executor memory: 785K bytes.
(slice1) Executor memory: 61909K bytes avg x 32 workers, 62461K bytes max (seg3). Work_mem: 57K bytes max.
Statement statistics:
Memory used: 128000K bytes
Total runtime: 26595.714 ms
(15 rows)
3.2.2.2 模擬并發10用戶---未測試此部分未測試，可參考 3.2.2.1節 列存儲模式---模擬并發5用戶 部分。
3.3并行測試（數據入庫的同時，并行查詢）
3.3.1 行存儲模式3.3.1.1數據入庫測試入庫表信息（同時入庫以下兩張表）：
3.3.1.2 模擬并發5用戶---未測試此部分可參考 3.3.2.2節--列存儲模式下的并發5用戶測試部分。
3.3.1.3 模擬并發10用戶3.3.1.3.1 數據表無索引● sql-1 情況：
3.3.1.3.2 系統性能指標性能指標（錄像/截屏）-----針對無索引時的并行查詢，與此同時入庫正在同步進行。
3.3.1.3.2.1 master host/tmp/nmonreport/mdw-3313-sql-2.txt
CPU
DISK
MEMORY
NETWORK
3.3.1.3.2.2 master host---sdw1/tmp/sdw1-3313-sql-2.txt
CPU
DISK
MEMORY
NETWORK
3.3.1.3.2.3 master host---sdw2/tmp/sdw2-3313-sql-2.txt
CPU
DISK
MEMORY
NETWORK
3.3.1.3.2.4 master host---sdw3/tmp/sdw3-3313-sql-2.txt
CPU
DISK
MEMORY
NETWORK
3.3.1.3.2.5 master host---sdw4/tmp/sdw4-3313-sql-2.txt
CPU
DISK
MEMORY
NETWORK
3.3.2 列存儲模式3.3.2.1數據入庫測試入庫表信息（同時入庫以下兩張表）：
3.3.2.2 模擬并發5用戶3.3.2.2.1 數據表無索引3.3.2.2.2 系統性能指標性能指標（錄像/截屏）-----針對無索引時的并行查詢，與此同時入庫正在同步進行。
3.3.2.2.2.1 master host/tmp/nmonreport/mdw-3322-sql-1.txt
CPU
DISK
MEMORY
NETWORK
3.3.2.2.2.2 segment host---sdw1/tmp/sdw1-3322-sql-1.txt
CPU
DISK
MEMORY
NETWORK
3.3.2.2.2.3 segment host---sdw2/tmp/sdw2-3322-sql-1.txt
CPU
DISK
MEMORY
NETWORK
3.3.2.2.2.4 segment host---sdw3/tmp/sdw3-3322-sql-1.txt
監控圖同上，在此省略。
3.3.2.2.2.5 segment host---sdw4/tmp/sdw4-3322-sql-1.txt
監控圖同上，在此省略。
3.3.2.3 模擬并發10用戶---未測試此部分可參考 3.3.2.2節模擬并發5用戶。
3.4分區輪換測試
Gp不支持job功能，只能自動配置系統任務。
3.5 segment instance 無mirror且宕instance測試
Gp中一旦出現有segment無效，則整個db將不可用。
報錯信息如下：
ERROR: All segment databases are unavailable
********** 錯誤 **********
ERROR: All segment databases are unavailable
SQL 狀態: 58M01
3.6主備master切換測試
正常狀態如下：
Primary master : mdw
Standby mater : smdw
入庫數據： ne_cell_c 65558條記錄 3964k
Mod_cdr_hw(release_cfc=’4’) 197344條記錄 55M
切換測試方案：
Kill 掉mdw的postgre進程，導致gp down掉，之后用smdw啟動gp
啟動語法：
Gpactivatestandby –d standby_master_datadir -f
Gp啟動之后，做如下查詢驗證：
ne_cell_c 65558條記錄 3964k
Mod_cdr_hw(release_cfc=’4’) 197344條記錄 55M
Select * from ne_cell_c;
數據沒有發現問題。
3.7 segment instance有mirror宕instance測試
3.7.1 測試前環境Segment host : 3 臺
Mater host : 1臺
每個segment host有４個primary gpseg
4個 mirror gpseg
其中映射關系如下(輪回)：
Sdw1 鏡像 sdw4 的 4個gpseg
Sdw3 鏡像 sdw1 的 4個gpseg
Sdw4 鏡像 sdw3 的 4個gpseg
GP處于正常可用狀態。
3.7.2 測試1測試方法：將交換機上的網線拔掉1根，此網線連接的是sdw4
測試結果：GP仍可用，數據沒有丟失。
測試方法：再次拔掉1跟網線
測試結果：GP不再可用，已經宕掉。
3.7.3 測試2測試方法：將sdw4上的postgre進程全部kill掉
測試結果：GP仍可用，數據沒有丟失，此時原mirror的segment instance的role由mirror轉變為primary。
3.7.4 測試3測試方法：將sdw4機器上的eth0網卡down掉
測試結果：GP仍可用，數據沒有丟失，此時該網卡上fail的primary instance 由其mirror的 instance接管。
測試方法：再次down掉sdw4上的eth1網卡
測試結果：GP仍可用，數據沒有丟失，此時該網卡上再次fail的primary instance 由其mirror的 instance接管。
4、結論1、存儲方式的選擇：默認情況下（采用zlib 5級壓縮），行存儲模式入庫之后所占空間是文本時的60%，即節省了40%的空間，而列存儲模式入庫之后所占空間是文本時的15%，即節省了85%的空間。
2、數據入庫速度：由于行存儲的壓縮效果較列存儲要差很多，這也就導致了在使用行存儲時CPU的消耗要明顯小于列存儲時對CPU的消耗，直接影響是行存儲入庫時間大于列存儲入庫時間。
3、不同的存儲方式對創建索引的影響：在行存儲和列存儲上分別創建相同的單列btree索引，行存儲上不同索引創建消耗的時間相差不大，而列存儲上相差很明顯，選擇性強的消耗的時間長，選擇性弱的消耗的時間短，這也正好體現了行列存儲的本質區別。
4、索引對數據入庫的影響：在行存儲數據表上創建3個索引，有無索引對數據入庫影響1/7的時間（數據表：44.8G，索引：2.71G），而在列存儲數據表上創建3個索引，有無索引對數據入庫影響1/7的時間（數據表：44.8G，索引：2.71G），此時沒有什么區別。
5、存儲方式對查詢的影響：在行存儲模式下，當全表掃描時，不同的查詢列數查詢耗用的時間沒區別，這也體現了行存儲的特性，而在列存儲模式下，正好相反，不同的查詢列數查詢耗用的時間是成正比的，查詢的列數越多，所消耗的時間越長，時間也成線性關系；還有一點，相同的查詢語句（都是全列查詢），行存儲所需要的時間是列存儲下耗用時間的1/2。
6、索引對查詢的影響：將具有索引的列作為查詢條件時，執行計劃顯示查詢時并不一定每次都利用該索引去查詢，如果沒有利用索引查詢，那么該查詢耗時與之前沒有區別，而一旦利用了索引，那么該查詢將較之前的查詢快幾倍甚至幾十倍。
7、并行查詢的影響：并行查詢時，無論數據是按照行存儲還是按照列存儲，并行查詢的規律是一致的，即小于并行查詢語句在串行方式下查詢耗時之和，當較串行執行耗時節省的時間有限，如，串行耗時之和為140s，并行需要128s，串行耗時之和為400s，并行需要337s。
8、資源優先分析：由于GP使用資源的方式是盡可能發揮資源的最大優勢，所以在發生資源瓶頸的時候，必然會出現資源競爭的情況，而當先執行數據入庫之后，再執行并發的N個查詢，此時資源由入庫占有轉為查詢占有，也就是說查詢具有資源利用的高優先級。
9、資源使用分析：此次測試采用了1個master host和4個segment host，如此一來，在資源耗用的時候，4個segment host所消耗的資源幾乎是一致的，即負載均衡性特點非常明顯。
10、資源瓶頸分析：由于數據入庫時都是壓縮的，導致cpu利用較高，經常100%，而磁盤和網卡利用率較低，在資源最繁忙的時候，磁盤的i/o和網卡的最高指標都較GP安裝時候的測試具有較大差距，應該是數據在內存中達到一定數據量之后，才有入庫的需求，而內存也需要大量的消耗，所以瓶頸主要體現在CPU和內存上。
11、分區輪換影響：由于GP不支持job功能，所以該部分功能只能利用操作系統來配置jobs，從而增加了操作系統方面的配置。
12、segment的一個instance宕掉對GP系統的影響：在無mirror的情況下，如果發生了一個segment的instance宕掉，將導致整個GP不可用，而在有mirror的時候，則可以避免GP的不可用，但缺點就是需要消耗一半的資源來做mirror，從而使有效的可用資源下降一倍。
最后，說明一下本次測試的數據量：44.8G*8+97G*8=1134.4G=1.108TB。
【篇2】材料測試報告
XXXX系統產品中級版
項目測試報告
目錄
1.概述 3
1.1測試目的 3
1.2項目背景 3
2.測試環境 3
3.測試人員 3
4.實際進度 4
5.提交文檔 4
6.功能點 4
6.1數據庫端 4
6.2客戶端 6
7.意見 7
8.項目總結 9
1.概述1.1測試目的通過測試，發現數據庫端、客戶端的錯誤；
驗證軟件是否滿足軟件需求和設計要求；
檢查軟件對誤操作的處理能力；
為軟件可靠性與安全性的評估提供依據。
1.2項目背景目前項目已經開發完成，將進入試運行和驗收階段，現在對項目的整個測試過程做一個總結。
2.測試環境硬件環境：
數據庫服務器: 惠普服務器ML150G3 XEON 5110/2G/160G*2/1000M/RAID1
軟件環境：
數據庫服務器
Operating System ： windows2003
Database System : Oracle 10g
3.測試人員人員：
角色：測試工程師
4.實際進度實際測試時間：服務器端：3天；客戶端：4天
5.提交文檔6.功能點6.1數據庫端6.2客戶端7.意見客戶端：
1． 用戶管理中，不設置密碼，應不允許保存
2．每個查詢窗口統一風格
3．油量信息中，每次修正記錄之間應有適當的分割符區分
4．油量信息中，油量曲線不能自由拖動
8.項目總結1．系統測試環境具備，文檔資料齊全，符合驗收測試條件。
2．測試項總數 21個功能模塊：服務器端共8個BUG；客戶端共57個BUG
嚴重度——高 1，2 等級的BUG –16個，修復率100%
嚴重度——中 3，4，5 等級的BUG—41個，92%
3． 該項目集成了飛行數據解決方案中常用的功能，較為全面的對QAR原始數據，飛行計劃，FOC數據進行了挖掘和應用。并對初級版中遺留的問題進行了修改。
4．飛行數據管理系統（中級版）實現了以下功能并測試通過：
服務器端：
用戶對系統的訪問；
系統的注冊，加密；
FOC數據入庫，提取時間油量信息；
客戶端：
系統注冊，加密；
查看FOC已入庫的數據；
用戶權限設置；
飛機號注冊；
查看系統日志。
5．綜合以上觀點，測試組認為：
該項目較好地完成了需求分析報告的內容，功能點基本滿足設計需要，同意通過測試。
【篇3】材料測試報告
國神光電科技(上海有限公司陽極氧化鋁打黑處理分析報告
文檔版本作者保密等級
V1.0焦燕星一般
發布日期審核人文檔編號
2014-6-16
第1頁內部文檔，未經允許禁止擴散
國神光電科技(上海有限公司
測試項目一，陽極氧化鋁打黑處理分析報告....................................................................................3
1、市場簡介2、測試結果分析
3、實驗過程數據記錄及其猜想
第2頁內部文檔，未經允許禁止擴散
國神光電科技(上海有限公司
測試項目一，陽極氧化鋁打黑處理測試報告
本工藝測試主要目的是確認短脈寬對現有市場上蘋果陽極氧化鋁打黑是否能夠達到要求
陽極氧化鋁測試測試項目測試平臺測試內容測試人測試時間
2014.5.1-2014.6.16
陽極氧化鋁打黑處理測試
國神Y09-N04激光器（G006型號）
通過在所購買的陽極化鋁和所帶來的陽極氧化鋁做測試
焦燕星
0、市場及其技術發展狀況
在市場上由于蘋果所采用的陽極氧化鋁外殼的技術，從而導致很多手機公司也大量采用該技術。但是現有的該技術存在效率上的一個問題，因此還沒有大量普及。但是一旦該技術在效率上和效果上達到要求那么，市場的量會很大。在該應用市場上ESI激光器研究的較為深透，同時也達到較好的要求，他們在該應用上的研究已經很久。現有的蘋果要求指標在提高，由原本的L=28即可達到要求，然后到現在要求的L
