QUERY FOR VENTURA DEPLOY

mail@pastecode.io avatar
unknown
mysql
a year ago
1.1 kB
1
Indexable
Never
SELECT AVG(firecmd_time) as firecmd_after_deploy, AVG(start_session_time) as start_session_time_after_deploy, count(*) as num FROM `browserstack-production.automate.automate_test_sessions_partitioned` 
WHERE DATE(_PARTITIONTIME) >= "2023-03-08" and DATE(_PARTITIONTIME) <= "2023-03-09"
and terminal in ("45.95.36.96",
"45.95.36.106",
"45.95.36.147",
"193.186.253.66",
"193.186.253.42",
"209.10.150.56",
"193.186.253.72",
"65.74.147.193",
"65.74.147.191",
"65.74.147.50",
"65.74.147.62",
"65.74.147.75",
"209.10.150.131",
"45.95.36.109",
"45.95.36.137",
"45.95.36.51",
"45.95.36.24",
"193.186.253.143",
"65.74.147.96",
"65.74.147.98",
"65.74.147.108",
"65.74.147.101",
"65.74.147.116",
"65.74.147.119",
"65.74.147.122",
"65.74.147.123",
"65.74.147.128",
"65.74.147.115",
"65.74.185.113",
"65.74.147.91",
"65.74.147.97",
"65.74.147.103",
"65.74.147.79",
"193.186.253.98",
"193.186.253.120",
"45.95.36.44",
"45.95.36.93",
"45.95.36.97",
"45.95.36.146",
"45.95.36.49",
"65.74.147.80",
"65.74.147.34",
"65.74.147.114",
"65.74.147.136",
"65.74.147.143",
"65.74.185.112",
"65.74.185.89",
"193.186.253.174")
and os = "OS X"
and os_version = "Ventura"