forked from docs/doc-exports
luhuayi
177cd61a57
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
17 lines
5.6 KiB
HTML
17 lines
5.6 KiB
HTML
<a name="EN-US_TOPIC_0000002052813786"></a><a name="EN-US_TOPIC_0000002052813786"></a>
|
|
|
|
<h1 class="topictitle1">SQL Diagnosis</h1>
|
|
<div id="body8662426"><p id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_p1376845711316">GaussDB(DWS) clusters support SQL diagnosis, which shows the complete execution plans of specific SQL queries. You can search for SQL queries (such as slow queries) using a combination of multiple filter criteria.</p>
|
|
<p id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_p1625849763">To use SQL diagnosis, perform the following steps:</p>
|
|
<ol id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_en-us_topic_0000001076708521_ol1482535782316"><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_en-us_topic_0000001076708521_li3826105742313"><span>Log in to the GaussDB(DWS) console.</span></li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_en-us_topic_0000001076708521_li1382685717234"><span>Choose <strong id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_b1747911122717">Dedicated Clusters</strong> > <strong id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_b1480141152720">Clusters<span id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_text1748010120275"></span></strong> and locate the cluster to be monitored.</span></li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_en-us_topic_0000001076708521_li118261257172315"><span>In the <strong id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_b1784718245597">Operation</strong> column of the target cluster, click <strong id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_b18848124155911">Monitoring Panel</strong>.</span></li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li645764432318"><span>In the navigation pane on the left, choose <strong id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_b711712314515">Utilities</strong> > <strong id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_b788033654518">SQL Diagnosis</strong>. The metrics include:</span><p><ul id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_ul1153203522418"><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li35324352248">Query ID</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li115321835142416">Database</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li18532163515240">Schema Name</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li35330356248">User Name</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li0533135122419">Client</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li16533153513249">Client IP Address</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li2533193515249">Running Time (ms)</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li5533113510247">CPU Time (ms)</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li18534235182412">Scale-Out Started</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li553423520248">Completed</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_li1553493518248">Details</li></ul>
|
|
</p></li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_en-us_topic_0000001076708521_li8826165722320"><span>On the <strong id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_b114256187541226">SQL Diagnosis</strong> page, you can view the SQL diagnosis information. In the <strong id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_b85696733441226">Details</strong> column of a specified query ID, click <strong id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_b184726947641226">View</strong> to view the detailed SQL diagnosis result, including:</span><p><ul id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_en-us_topic_0000001076708521_ul1826185742314"><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_en-us_topic_0000001076708521_li28261157122311">Alarm Information</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_en-us_topic_0000001076708521_li12826135712318">SQL Statement</li><li id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_en-us_topic_0000001076708521_li5826175710232">Execution Plan</li></ul>
|
|
<p id="EN-US_TOPIC_0000002052813786__en-us_topic_0000002044806292_en-us_topic_0000001372679770_en-us_topic_0000001076708521_p4827185742312"></p>
|
|
</p></li></ol>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0403.html">Performance Diagnosis</a></div>
|
|
</div>
|
|
</div>
|
|
|