Features
All Batch execution information in one view
For all operations, display inline:
- Overall cost. The number is color-coded when the cost is higher than 1%.
- Cost break-down: IO, CPU, Data size and the number of rows returned.
- Numbers are color-coded when they are more significant than a threshold.
- When the estimated number of rows is different from the actual number, the estimated number of rows is present and color-coded.
- Table and Index names, if available.
- Execution Flags.
❮
63.61%
IO:
CPU:
SIZE:
ROWS:
ESTIMATED:
97.46%
7.82%
87.61 MB
363108
120
Index Seek
[OBR_Derived]
[IX_OBR_ExternalId]
Ordered, FORWARD, Row Store, Partitioned
Properties
❮
0.00%
IO:
CPU:
SIZE:
ROWS:
0.00%
0.00%
950 B
50
Aggregate
Stream Aggregate
by
[SequenceNumber]
Properties
General
Estimated
Actual
End Of Scans
1
Executions
1
Is Interleaved Executed
false
Logical Operation
Aggregate
Node Id
57
Physical Operation
Stream Aggregate
Metrics
Average Row Size
19
CPU
0.000104455
Execution Mode
Row
IO
0
Rebinds
0
Rewinds
0
Total Subtree Cost
0.00379116
Reads
Rows
50
50
- Operation Properties
- including Estimated vs Actual
- Breakdown for Parallel executions
❮
0.00%
IO:
CPU:
SIZE:
ROWS:
ESTIMATED:
0.00%
0.00%
354 B
6
1
Clustered Index Seek
[ORCA_Clinical_Event]
[IX_ORCA_Cl..._Event_EID]
Lookup, Ordered, FORWARD, Row Store, Parallel, Partitioned
Properties
General
Estimated
Actual
0
1
2
3
4
5
6
7
8
Batches
0
0
0
0
0
0
0
0
0
End Of Scans
0
0
0
0
0
0
0
0
0
0
Execution Mode
Row
Row
Row
Row
Row
Row
Row
Row
Row
Row
Executions
6
0
1
1
1
1
1
1
0
0
Is Interleaved Executed
false
false
false
false
false
false
false
false
false
false
Logical Operation
Clustered Index Seek
Node Id
33
Physical Operation
Clustered Index Seek
Metrics
Average Row Size
59
CPU
0.0001581
IO
0.003125
Rebinds
0.0202618
Rewinds
0
Table Cardinality
940021000
Total Subtree Cost
0.00329114
Reads
Rows
1
6
0
1
1
1
1
1
1
0
0
Partitions
Partition Count
1
Output
[id]
❮
7.56%
IO:
CPU:
SIZE:
ROWS:
ESTIMATED:
0.00%
22.50%
1.06 KB
99
2209
Left Anti Semi Join
Merge Join
Properties
Inner Side Columns
[id]
Outer Side Columns
[id]
Residual
[id] = [id]
25.46%
❯
26.11%
❯
- Joins insights
- Aggregations insights
❮
8.16%
IO:
CPU:
SIZE:
ROWS:
0.00%
22.46%
114 B
3
Aggregate
Hash Match
Properties
Build
Hash Keys
[event_code]
Residual
[event_code] IS [event_code]
91.22%
❯
Output
[Expr1002]
[Expr1003]
[event_code]
Order By
[event_code] DESC
❮
0.62%
IO:
CPU:
SIZE:
ROWS:
0.72%
0.06%
114 B
3
Top N Sort
Sort
[event_code] DESC
4 ROWS
Properties
99.38%
❯
- Sorting insights
- Multiple statements analisys in a single view
2
statements
99.82%
select event_code, max(person_id), min(person_id) as minp from phs.event group by event_code having event_code like 'H%' order by event_code desc offset 2 row fetch next 2 row only
Properties
99.82%
❯
GO
0.18%
select top 1 * from phs.event
Properties
0.18%
❯
GO
