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 |
|---|---|---|---|---|
| COPY public.particle_concentrations ("timestamp", mass_1p0_ugm3, mass_2p5_ugm3, mass_4p0_ugm3, mass_10p0_ugm3, num_0p5_ncm3, num_1p0_ncm3, num_2p5_ncm3, num_4p0_ncm3, num_10p0_ncm3, size_um) TO stdout | 10.236239 seconds | 10.4 | 1 | 0 seconds |
| COPY public.solar_observations ("timestamp", temperature_c, humidity_pct, charge_pct, lighting_lm, battery_voltage_mv, photo_light_mv, sensor_id) TO stdout | 5.353386 seconds | 5.4 | 1 | 0 seconds |
| COPY _timescaledb_internal._hyper_1_1235_chunk ("timestamp", humidity_pct, dht_temperature_c, bmp_temperature_c, pressure_hg, sealevel_pressure_hg, altitude_m, real_altitude_m, lighting_lm, photo_light_mv, luminance_tag, raspi_temp_c, scd_temperature_c, scd_humidity_pct, scd_co2_ppm) TO stdout | 5.229701 seconds | 5.3 | 1 | 0 seconds |
| COPY public.power_monitorings ("timestamp", voltage_v, current_a, power_w, energy_kwh, frequency_hz, power_factor) TO stdout | 4.947284 seconds | 5.0 | 1 | 0 seconds |
| LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE | 4.450564 seconds | 4.5 | 4994 | 0 seconds |
| 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 | 4.353827 seconds | 4.4 | 2 | 0 seconds |
| SELECT "timestamp" AS "time", humidity_pct as balcony FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 4.180327 seconds | 4.2 | 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 | 4.137604 seconds | 4.2 | 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 | 3.966486 seconds | 4.0 | 2 | 0 seconds |
| INSERT INTO "air_pollutions" ("aqi_idx","city_id","co_ugm3","nh3_ugm3","no2_ugm3","no_ugm3","o3_ugm3","pm10_ugm3","pm2_5_ugm3","so2_ugm3","timestamp") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) | 3.627051 seconds | 3.7 | 191 | 0 seconds |