Artem
01/13/2021, 2:13 PMZach Zeid
01/13/2021, 2:14 PMArtem
01/13/2021, 2:18 PMtheopolis
01/13/2021, 2:42 PMArtem
01/14/2021, 11:23 AMtheopolis
01/14/2021, 5:08 PMtime
and the specific query:
/tmp » time osqueryi --disable_extensions "select count(1) from users"
+----------+
| count(1) |
+----------+
| 105 |
+----------+
^[[Aosqueryi --disable_extensions "select count(1) from users" 0.06s user 0.03s system 27% cpu 0.346 total
/tmp » time osqueryi --disable_extensions "select count(1) from users join users"
+----------+
| count(1) |
+----------+
| 11025 |
+----------+
osqueryi --disable_extensions "select count(1) from users join users" 2.55s user 1.79s system 45% cpu 9.470 total
inet_aton
method:
/tmp » osqueryi --disable_extensions "select inet_aton('1.0.1.5') as ipInt"
+----------+
| ipInt |
+----------+
| 16777477 |
+----------+
Artem
01/14/2021, 5:20 PM