Outliers
Queries that have longest execution time in aggregate
Showing 10 entries
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 656.332719 seconds 7.3 150 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 610.757654 seconds 6.8 150 0 seconds
LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE 513.532594 seconds 5.7 1222426 0 seconds
COPY public.power_monitorings ("timestamp", voltage_v, current_a, power_w, energy_kwh, frequency_hz, power_factor) TO stdout 502.313382 seconds 5.6 150 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 345.899481 seconds 3.8 648 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 332.024673 seconds 3.7 657 0 seconds
SELECT "timestamp" AS "time", humidity_pct as balcony FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 308.032537 seconds 3.4 651 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 254.829662 seconds 2.8 466 0 seconds
CREATE TABLE IF NOT EXISTS "schema_migrations" ("version" bigint, "inserted_at" timestamp(0), PRIMARY KEY ("version")) 253.215571 seconds 2.8 1222427 0 seconds
select installed_version from pg_available_extensions where name=$1 179.947524 seconds 2.0 85516 0 seconds