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", temperature_c as sol_temperature_c FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 AND sensor_id = $3 ORDER BY 1 | 356.187177 seconds | 13.7 | 404 | 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 | 347.810473 seconds | 13.4 | 405 | 0 seconds |
| SELECT "timestamp" AS "time", humidity_pct as balcony FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 311.546794 seconds | 12.0 | 406 | 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 | 229.295059 seconds | 8.9 | 408 | 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 | 166.481154 seconds | 6.4 | 20 | 0 seconds |
| COPY public.power_monitorings ("timestamp", voltage_v, current_a, power_w, energy_kwh, frequency_hz, power_factor) TO stdout | 122.296316 seconds | 4.7 | 20 | 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 | 115.092325 seconds | 4.4 | 20 | 0 seconds |
| SELECT "timestamp" AS "time", ground_pressure_gpa / $1 as pk_pressure_hg FROM climate_changes WHERE "timestamp" BETWEEN $2 AND $3 AND city_id = $4 OR -- St. Petersburg city_id = $5 OR -- Vojeykovo city_id = $6 -- Pulkovo ORDER BY 1 | 59.350946 seconds | 2.3 | 385 | 0 seconds |
| LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE | 57.529227 seconds | 2.2 | 31112 | 0 seconds |
| COPY public.who_covid (date_reported, country_code, country, who_region, new_cases, cumulative_cases, new_deaths, cumulative_deaths) TO stdout | 22.992584 seconds | 0.9 | 20 | 0 seconds |