Outliers
Queries that have longest execution time in aggregate
Showing 10 entries
Query Exec time Prop exec time Calls
 		Sync io time
LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE 132.502934 seconds 4.2 401266 0 seconds
select installed_version from pg_available_extensions where name=$1 353.467239 seconds 11.1 164392 0 seconds
SELECT "timestamp" AS "time", charge_pct as sol_charge_pct FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 145.493914 seconds 4.6 856 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 253.236160 seconds 8.0 831 0 seconds
SELECT "timestamp" AS "time", humidity_pct as balcony FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 211.988363 seconds 6.7 831 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 249.258075 seconds 7.8 830 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 136.119758 seconds 4.3 51 0 seconds
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 126.713328 seconds 4.0 51 0 seconds
COPY public.power_monitorings ("timestamp", voltage_v, current_a, power_w, energy_kwh, frequency_hz, power_factor) TO stdout 95.822745 seconds 3.0 51 0 seconds
COPY public.who_covid (date_reported, country_code, country, who_region, new_cases, cumulative_cases, new_deaths, cumulative_deaths) TO stdout 77.511882 seconds 2.4 51 0 seconds