Outliers
Queries that have longest execution time in aggregate
Queries that have longest execution time in aggregate
| Query | Exec time | Prop exec time | Calls | Sync io time |
|---|---|---|---|---|
| SELECT "timestamp" AS "time", lighting_lm as sol_lightning_lm FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 AND sensor_id = $3 ORDER BY 1 | 13.633785 seconds | 9.7 | 10 | 0 seconds |
| SELECT "timestamp" AS "time", size_um FROM particle_concentrations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 13.624908 seconds | 9.7 | 2 | 0 seconds |
| SELECT "timestamp" AS "time", power_factor FROM power_monitorings WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 13.243728 seconds | 9.4 | 2 | 0 seconds |
| SELECT "timestamp" AS "time", frequency_hz FROM power_monitorings WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 13.135216 seconds | 9.3 | 2 | 0 seconds |
| SELECT "timestamp" AS "time", temperature_c as sol_temperature_c FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 AND sensor_id = $3 ORDER BY 1 | 12.322739 seconds | 8.7 | 10 | 0 seconds |
| SELECT "timestamp" AS "time", humidity_pct as balcony FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 12.153838 seconds | 8.6 | 10 | 0 seconds |
| SELECT "timestamp" AS "time", mass_1p0_ugm3, mass_2p5_ugm3 FROM particle_concentrations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 11.479528 seconds | 8.1 | 2 | 0 seconds |
| SELECT "timestamp" AS "time", AVG( charge_pct ) OVER( ORDER BY timestamp ROWS BETWEEN $1 PRECEDING AND CURRENT ROW ) as avg_charge_pct FROM solar_observations WHERE "timestamp" BETWEEN $2 AND $3 ORDER BY 1 | 10.688464 seconds | 7.6 | 10 | 0 seconds |
| SELECT "timestamp" AS "time", num_0p5_ncm3, num_1p0_ncm3 FROM particle_concentrations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 6.122136 seconds | 4.3 | 2 | 0 seconds |
| SELECT "timestamp" AS "time", voltage_v FROM power_monitorings WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 5.185557 seconds | 3.7 | 2 | 0 seconds |