Skip to content

Instantly share code, notes, and snippets.

@databasetech0073

databasetech0073/gist:55c5722da8105dfcc647ab3bd1b24a48 Secret

Created November 16, 2022 17:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save databasetech0073/55c5722da8105dfcc647ab3bd1b24a48 to your computer and use it in GitHub Desktop.
Save databasetech0073/55c5722da8105dfcc647ab3bd1b24a48 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SQL Plan Monitoring Details (Plan Hash Value=2056239125)
=================================================================================================================================================================================================================================================================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Write | Write | Cell | Mem | Temp | Activity | Activity Detail |
| | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | Reqs | Bytes | Offload | (Max) | (Max) | (%) | (# samples) |
=================================================================================================================================================================================================================================================================================
| 24 | PX RECEIVE | | 9M | 3M | 24 | +1979 | 16 | 37M | | | | | | | | 0.05 | Cpu (8) |
| 25 | PX SEND HASH | :TQ10011 | 9M | 3M | 25 | +1978 | 16 | 37M | | | | | | | | 0.05 | Cpu (8) |
| 26 | VIEW | | 9M | 3M | 25 | +1978 | 16 | 37M | | | | | | | | 0.12 | Cpu (21) |
| 27 | WINDOW SORT PUSHED RANK | | 9M | 3M | 110 | +1893 | 16 | 70M | 162K | 19GB | 120K | 19GB | | 2G | 11G | 4.68 | Cpu (234) |
| | | | | | | | | | | | | | | | | | direct path read temp (478) |
| | | | | | | | | | | | | | | | | | direct path write temp (108) |
| 28 | PX RECEIVE | | 9M | 3M | 86 | +1893 | 16 | 70M | | | | | | | | 0.11 | Cpu (19) |
| 29 | PX SEND HASH | :TQ10010 | 9M | 3M | 77 | +1893 | 16 | 70M | | | | | | | | 0.25 | Cpu (43) |
| 30 | WINDOW CHILD PUSHED RANK | | 9M | 3M | 1752 | +218 | 16 | 70M | 146K | 19GB | 101K | 19GB | | 4G | 10G | 41.97 | Cpu (6748) |
| | | | | | | | | | | | | | | | | | direct path read temp (553) |
| | | | | | | | | | | | | | | | | | direct path write temp (47) |
| 31 | HASH JOIN RIGHT OUTER | | 9M | 2M | 1676 | +218 | 16 | 7G | | | | | | 217M | | 23.08 | Cpu (4041) |
| 32 | BUFFER SORT | | | | 4 | +216 | 16 | 1M | | | | | | 97M | | | |
| 33 | PX RECEIVE | | 10647 | 24 | 4 | +216 | 16 | 1M | | | | | | | | | |
| 34 | PX SEND HASH | :TQ10005 | 10647 | 24 | 1633 | +216 | 1 | 1M | | | | | | | | 0.01 | Cpu (2) |
| 35 | VIEW | | 10647 | 24 | 1632 | +217 | 1 | 1M | | | | | | | | | |
| 36 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FDA1E71E_D71F1BDE | 10647 | 24 | 1632 | +217 | 1 | 1M | 106 | 104MB | | | | | | 0.01 | cell multiblock physical read (1) |
SQL Plan Monitoring Details (Plan Hash Value=3957617523)
===================================================================================================================================================================================================================================================================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Write | Write | Mem | Temp | Activity | Activity Detail |
| | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | Reqs | Bytes | (Max) | (Max) | (%) | (# samples) |
===================================================================================================================================================================================================================================================================================
| 23 | TABLE ACCESS STORAGE FULL | DPM | 4M | 30627 | | | | | | | | | . | . | | |
| 24 | PX RECEIVE | | 9M | 4M | | | | | | | | | . | . | | |
| 25 | PX SEND HASH | :TQ10011 | 9M | 4M | | | | | | | | | . | . | | |
| 26 | VIEW | | 9M | 4M | | | | | | | | | . | . | | |
| 27 | WINDOW SORT PUSHED RANK | | 9M | 4M | | | | | | | | | . | . | | |
| 28 | PX RECEIVE | | 9M | 4M | | | | | | | | | . | . | | |
| 29 | PX SEND HASH | :TQ10010 | 9M | 4M | | | 16 | | | | | | . | . | | |
| 30 | WINDOW CHILD PUSHED RANK | | 9M | 4M | 3112 | +915 | 16 | 0 | | | 3M | 1TB | 9GB | 1TB | 0.06 | Cpu (7) |
| 31 | HASH JOIN RIGHT OUTER | | 9M | 3M | 3112 | +915 | 16 | 10G | | | | | 648MB | . | 0.08 | Cpu (9) |
| 32 | BUFFER SORT | | | | 8 | +908 | 16 | 4M | | | | | 350MB | . | 0.01 | Cpu (1) |
| 33 | PX RECEIVE | | 30888 | 66 | 7 | +909 | 16 | 4M | | | | | . | . | | |
| 34 | PX SEND HASH | :TQ10005 | 30888 | 66 | 7 | +908 | 1 | 4M | | | | | . | . | 0.01 | Cpu (1) |
| 35 | VIEW | | 30888 | 66 | 7 | +908 | 1 | 4M | | | | | . | . | | |
| 36 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6D1B_38C7BCF3 | 30888 | 66 | 7 | +908 | 1 | 4M | 396 | 395MB | | | . | . | 0.05 | Cpu (1) |
| | | | | | | | | | | | | | | | | cell multiblock physical read (5) |
SQL Plan Monitoring Details (Plan Hash Value=2917514310)
===================================================================================================================================================================================================================================================================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Write | Write | Mem | Temp | Activity | Activity Detail |
| | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | Reqs | Bytes | (Max) | (Max) | (%) | (# samples) |
===================================================================================================================================================================================================================================================================================
| 23 | VIEW | | 5M | 44M | | | | | | | | | . | . | | |
| 24 | WINDOW SORT PUSHED RANK | | 5M | 44M | | | | | | | | | . | . | | |
| 25 | PX RECEIVE | | 5M | 44M | | | | | | | | | . | . | | |
| 26 | PX SEND HASH | :TQ10009 | 5M | 44M | | | 16 | | | | | | . | . | | |
| 27 | WINDOW CHILD PUSHED RANK | | 5M | 44M | 2681 | +932 | 16 | 0 | | | 2M | 1TB | 6GB | 1TB | | |
| 28 | HASH JOIN RIGHT OUTER | | 5M | 39M | 2681 | +932 | 16 | 7G | | | | | 718MB | . | | |
| 29 | BUFFER SORT | | | | 7 | +926 | 16 | 4M | | | | | 356MB | . | 0.02 | Cpu (2) |
| 30 | PX RECEIVE | | 37989 | 62 | 7 | +926 | 16 | 4M | | | | | . | . | | |
| 31 | PX SEND HASH | :TQ10002 | 37989 | 62 | 5 | +926 | 1 | 3M | | | | | . | . | | |
| 32 | VIEW | | 37989 | 62 | 5 | +926 | 1 | 3M | | | | | . | . | | |
| 33 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D7FC5_38C7BCF3 | 37989 | 62 | 7 | +925 | 1 | 3M | 299 | 298MB | | | . | . | 0.05 | Cpu (1) |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment