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 | 83.584585 seconds | 7.7 | 24 | 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 | 80.750183 seconds | 7.5 | 24 | 0 seconds |
LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE | 71.170556 seconds | 6.6 | 191659 | 0 seconds |
COPY public.power_monitorings ("timestamp", voltage_v, current_a, power_w, energy_kwh, frequency_hz, power_factor) TO stdout | 61.655745 seconds | 5.7 | 24 | 0 seconds |
CREATE TABLE IF NOT EXISTS "schema_migrations" ("version" bigint, "inserted_at" timestamp(0), PRIMARY KEY ("version")) | 39.308942 seconds | 3.6 | 191660 | 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 | 30.330060 seconds | 2.8 | 93 | 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 | 28.504177 seconds | 2.6 | 93 | 0 seconds |
COPY public.who_covid (date_reported, country_code, country, who_region, new_cases, cumulative_cases, new_deaths, cumulative_deaths) TO stdout | 27.289829 seconds | 2.5 | 24 | 0 seconds |
SELECT "timestamp" AS "time", charge_pct as sol_charge_pct FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 22.872332 seconds | 2.1 | 94 | 0 seconds |
SELECT "timestamp" AS "time", humidity_pct as balcony FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 22.581218 seconds | 2.1 | 93 | 0 seconds |