Skip to content

Instantly share code, notes, and snippets.

@systay

systay/scatter-output.htm

Created November 9, 2019 07:18
Show Gist options
  • Save systay/a64bf85f9d6727f5a5e53339a9c97de9 to your computer and use it in GitHub Desktop.
Save systay/a64bf85f9d6727f5a5e53339a9c97de9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
scatter-output.htm
<html>
<head>
<title>Vitess Scatter Query Statistics</title>
<style>
table, th, td {
border: 1px solid black;
}
</style>
</head>
<body>
<table border="1">
<thead>
<tr>
<th>Query</th>
<th># of executions</th>
<th>Avg time/query</th>
<th>% time of reads</th>
<th>% time of scatters</th>
<th>% of reads</th>
<th>% of scatters</th>
</tr>
</thead>
<tr>
<td>select * from user as u1 join user as u2 on u1.Id = u2.Id</td>
<td>1</td>
<td>255.441µs</td>
<td>22</td>
<td>26</td>
<td>25</td>
<td>33</td>
</tr>
<tr>
<td>select * from user where Id &gt; 15</td>
<td>1</td>
<td>164.875µs</td>
<td>14</td>
<td>17</td>
<td>25</td>
<td>33</td>
</tr>
<tr>
<td>select * from user</td>
<td>1</td>
<td>549.455µs</td>
<td>48</td>
<td>56</td>
<td>25</td>
<td>33</td>
</tr>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment