| 0,04 | 0 | 0,03 | 0 | 1,03 |
|---|---|---|---|---|
| execution time (ms) | planning time (ms) | slowest node (ms) | largest node (rows) | costliest node |
| a | {} |
| b | {"actual time":"0.043..0.043","loops":"1","Actual Total Time":"0.043","rows":"0"} |
| Indent Depth | 0 |
| Node Type | Limit/Offset |
| Limit | 10 |
| Offset | 5 |
LIMIT/OFFSET |
0ms | NaN |
| Rows: 0 |
| Order | ASC |
| b | {"actual time":"0.041..0.041","loops":"1","Actual Total Time":"0.041","rows":"0"} |
| Indent Depth | 4 |
| Column | EXAMPLE1.EXPERIENCE |
| Node Type | Sort |
SORT |
0,01ms | NaN |
| Rows: 0 |
| a | {"cost":"1.45","rows":"0.3"} |
| b | {"actual time":"0.032..0.032","loops":"1","Actual Total Time":"0.032","rows":"0"} |
| Indent Depth | 8 |
| Node Type | -> Stream results |
-> STREAM RESULTS |
0ms | NaN |
| Rows: 0 |
| a | {"cost":"1.45","rows":"0.3"} |
| b | {"actual time":"0.029..0.029","loops":"1","Actual Total Time":"0.029","rows":"0"} |
| Indent Depth | 12 |
| Node Type | Nested loop |
| Join Type | inner |
NESTED LOOP |
0ms | ∞ |
| Rows: 0 |
| Table Name | ADDRESS2 |
| a | {"cost":"0.35","rows":"1"} |
| b | {"actual time":"0.028..0.028","loops":"1","Actual Total Time":"0.028","rows":"0"} |
| Indent Depth | 16 |
| Node Type | Table scan |
TABLE SCAN |
0,03ms | ∞ |
| Rows: 0 |
| a | {"cost":"1.03","rows":"0.3"} |
| b | {} |
| Indent Depth | 16 |
| Node Type | Filter |
| Filter Expression | ["EXAMPLE1.EXPERIENCE > 20"] |
FILTER |
0ms | NaN |
| Rows: 0 |
| a | {"cost":"1.03","rows":"1"} |
| b | {} |
| Indent Depth | 20 |
| Node Type | -> Single-row index lookup on EXAMPLE1 using PRIMARY (ID=ADDRESS2.PERSON_ID) |
-> SINGLE-ROW INDEX LOOKUP ON EXAMPLE1 USING PRIMARY (ID=ADDRESS2.PERSON_ID) |
0ms | ∞ |
| Rows: 0 |