Downhole self-excited torsional resonance will lead to premature failure of drilling tools and seriously affect drilling efficiency. To clarify the main characteristics of drill string torsional vibration and formulate reasonable and reliable vibration reduction strategies, this study analyzes engineering parameter data collected by the new near-bit measuring tool in time domain, frequency domain and time-frequency domain, it is found that: When high-frequency torsional vibration (HFTO) occurs, the amplitude of tangential acceleration will increase, time domain analysis shows that tangential acceleration changes most sharply, the root mean square value and variance are also high, indicating that tangential acceleration can better reflect the characteristics of HFTO. Frequency domain analysis shows that the main frequency is greater than 50 Hz in tangential acceleration, and the main frequency shift phenomenon is observed, which is related to the change of WOB. When HFTO and stick-slip are coupled, the rotational speed and tangential acceleration increase substantially in the slip phase and decrease rapidly in the stick-slip phase. Time-frequency domain analysis shows that there will be a mixture of two frequencies in radial acceleration, the vibration characteristics are more complicated. In addition, when stick-slip is superimposed on HFTO, which can lead to an amplification or reduction of HFTO loads, and different strategies are needed to minimize the loads related to HFTO and stick-slip. The research results can visually observe the characteristic differences of HFTO, stick-slip and their coupling vibration, which has an important guiding role in identifying HFTO and proposing mitigation strategies in subsequent drilling, thus ensuring the efficiency and safety of drilling operations.