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.power_monitorings ("timestamp", voltage_v, current_a, power_w, energy_kwh, frequency_hz, power_factor) TO stdout | 526.425817 seconds | 27.3 | 5 | 0 seconds |
| LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE | 253.888205 seconds | 13.2 | 6619 | 0 seconds |
| select register_city( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 ) | 112.666688 seconds | 5.8 | 1441 | 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 | 99.216118 seconds | 5.1 | 5 | 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 | 89.204784 seconds | 4.6 | 5 | 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) | 84.001277 seconds | 4.4 | 1212 | 0 seconds |
| CREATE TABLE IF NOT EXISTS "schema_migrations" ("version" bigint, "inserted_at" timestamp(0), PRIMARY KEY ("version")) | 78.203974 seconds | 4.1 | 6619 | 0 seconds |
| COPY public.who_covid (date_reported, country_code, country, who_region, new_cases, cumulative_cases, new_deaths, cumulative_deaths) TO stdout | 60.277713 seconds | 3.1 | 5 | 0 seconds |
| INSERT INTO "openweather_maps" ("city_id","clouds_all_pt","description","feels_like_c","ground_level_mb","humidity_pct","icon","ow_temperature_c","pressure_mb","sea_level_mb","temp_max_c","temp_min_c","timestamp","visibility_m","weather_tag","wind_direction_deg","wind_gust_ms","wind_speed_ms") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18) | 56.407248 seconds | 2.9 | 963 | 0 seconds |
| INSERT INTO "clock_updates" ("icon","is_night_flag","sky_color_html","timestamp","ya_temperature_c") VALUES ($1,$2,$3,$4,$5) | 26.860001 seconds | 1.4 | 482 | 0 seconds |