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 |
|---|---|---|---|---|
| LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE | 1.229855 seconds | 18.7 | 2347 | 0 seconds |
| SELECT t.oid, t.typname, t.typsend, t.typreceive, t.typoutput, t.typinput, coalesce(d.typelem, t.typelem), coalesce(r.rngsubtype, $1), ARRAY ( SELECT a.atttypid FROM pg_attribute AS a WHERE a.attrelid = t.typrelid AND a.attnum > $2 AND NOT a.attisdropped ORDER BY a.attnum ) FROM pg_type AS t LEFT JOIN pg_type AS d ON t.typbasetype = d.oid LEFT JOIN pg_range AS r ON r.rngtypid = t.oid OR (t.typbasetype <> $3 AND r.rngtypid = t.typbasetype) WHERE (t.typrelid = $4) AND (t.typelem = $5 OR NOT EXISTS (SELECT $6 FROM pg_catalog.pg_type s WHERE s.typrelid != $7 AND s.oid = t.typelem)) | 1.084957 seconds | 16.5 | 2 | 0 seconds |
| select register_city( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 ) | 0.739476 seconds | 11.3 | 87 | 0 seconds |
| CREATE TABLE IF NOT EXISTS "schema_migrations" ("version" bigint, "inserted_at" timestamp(0), PRIMARY KEY ("version")) | 0.521390 seconds | 7.9 | 2347 | 0 seconds |
| select installed_version from pg_available_extensions where name=$1 | 0.453594 seconds | 6.9 | 208 | 0 seconds |
| SELECT t.oid, t.typname, t.typsend, t.typreceive, t.typoutput, t.typinput, coalesce(d.typelem, t.typelem), coalesce(r.rngsubtype, $1), ARRAY ( SELECT a.atttypid FROM pg_attribute AS a WHERE a.attrelid = t.typrelid AND a.attnum > $2 AND NOT a.attisdropped ORDER BY a.attnum ) FROM pg_type AS t LEFT JOIN pg_type AS d ON t.typbasetype = d.oid LEFT JOIN pg_range AS r ON r.rngtypid = t.oid OR (t.typbasetype <> $3 AND r.rngtypid = t.typbasetype) WHERE (t.typrelid = $4) AND (t.typelem = $5 OR NOT EXISTS (SELECT $6 FROM pg_catalog.pg_type s WHERE s.typrelid != $7 AND s.oid = t.typelem)) | 0.433618 seconds | 6.6 | 2 | 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) | 0.423313 seconds | 6.4 | 58 | 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) | 0.369955 seconds | 5.6 | 75 | 0 seconds |
| INSERT INTO "weather_conditions" ("altitude_m","bmp_temperature_c","dht_temperature_c","humidity_pct","lighting_lm","luminance_tag","photo_light_mv","pressure_hg","raspi_temp_c","real_altitude_m","scd_co2_ppm","scd_humidity_pct","scd_temperature_c","sealevel_pressure_hg","timestamp") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15) | 0.199750 seconds | 3.0 | 410 | 0 seconds |
| INSERT INTO "solar_observations" ("battery_voltage_mv","charge_pct","humidity_pct","lighting_lm","photo_light_mv","sensor_id","temperature_c","timestamp") VALUES ($1,$2,$3,$4,$5,$6,$7,$8) | 0.180112 seconds | 2.7 | 411 | 0 seconds |